Postgres

Relation dababase

Tips

Just connect to Postgres in localhost

% psql

Make backup a full backup

% pg_dumpall > full_dump.sql

Check tablespaces

postgres=# \db

Check roles:

  SELECT * FROM pg_roles;

Update password on Role:

  ALTER ROLE replica_user ENCRYPTED PASSWORD '<PASSWORD>';