via @fanf

+ https://www.freshports.org/databases/postgresql-repmgr/

./pg_ctl promote -D /usr/edb/as12/data

Once the command is executed, it verifies any files available in the pg_wal folder, replays them, and then starts as a master node. It does not try to connect to the (old) master server, and hence the promotion is very fast.

Percona Operator for PostgreSQL v2.6.0 adds PostgreSQL 17 support. Since pg_tde comes pre-installed in Percona's official PostgreSQL 17 images, you can encrypt PostgreSQL data at rest.

via le taf

via le taf

\l - Display database
\c - Connect to database
\dn - List schemas
\dt - List tables inside public schemas
\dt schema1.* - List tables inside a particular schema.
                For example: 'schema1'.
\du - List users

via le taf