Technical Notes

Problem/Case When using typical physical streaming, pg_wal size grows very fast and unexpectedly on DR (Disaster)/Backup/Standby node Solut...

-- show the connection info # \ conninfo -- show IP address connected by the postgres client # select inet_server_addr (); -- enable timing ...

1st step on 2nd node: $ echo "DROP SUBSCRIPTION exampledb_node_2" | psql on 1st node: $ echo "DROP PUBLICATION exampledb...

-> Check log level from config file # cat /var/lib/pgsql/data/postgresql.conf e.g. log_min_messages= 'ERROR' (default value) ...

e.g. current service name: postgresql.service desired service name: postgresql-9.1.service Run following commands to change service name...

You are able to run a SQL query/statement with "echo" command by  shell module for the ansible task. # an example task for sql ...

Action postgres=# drop database example ; Error ERROR:  database " example " is being accessed by other users DETAIL:  There ...

Preparation of Test Data test=#  create table employees (id integer, name varchar, department_id integer); test=#  create table departm...

Preparation of Test Data test=#  create table  T_JSON_DATA  (id INTEGER, body JSON); test=# insert into T_JSON_DATA values (1, '{ ...