Remove c
article thumbnail

Configuring PostgreSQL and LDAP Using StartTLS

Percona

Even though there is an encrypted session between psql and the Postgres server, there is no encrypted session between Postgres and LDAP as authentication is performed: SSL connection (protocol: TLSv1.3, Download Percona Distribution for PostgreSQL Today!

C++ 98
article thumbnail

Data Redundancy With the PostgreSQL Citus Extension

Percona

Step three: Check packages Inspecting the nodes confirms Citus has been correctly installed: for u in citus1 citus2 citus3 citus4 citus-coord-01 do echo " = NODE: $u =" lxc exec $u -- su - postgres -c 'psql db01'<<_eof_ select extname, extversion from pg_extension; _eof_ done | less -S = NODE: citus1 = extname | extversion -+ plpgsql | 1.0

C++ 98
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Percona Toolkit – A Quick Introduction to Summary

Percona

. $ t-pg-summary -U postgres INFO[0000] Connecting to the database server using: sslmode=disable dbname=postgres INFO[0000] Connection OK INFO[0000] Detected PostgreSQL version: 16.0.0 Client Hostname: Version : PostgreSQL 16.0 - Percona Distribution on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11. . $

Cache 114
article thumbnail

High Memory Usage on ProxySQL Server

Percona

Your MySQL connection id is 1 Server version: 5.5.30 (ProxySQL Admin Module) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'c' to clear the current input statement. 2) mysql-query_digests_max_digest_length – This is by default set to 2048. Commands end with ; or g. Type 'help;' or 'h' for help.

Servers 60
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Character POS ASCII Value Formula Value A 1 65 67 C 2 67 69 Checksum 136 Comparing ​​ the checksum values indicates ​​ that the values do not match and ​​ damage ​​ has occurred to the data. ​​ Incorrect configurations lead to data loss.

Servers 40