General operations

Basic commands for day-to-day operations

Start and stop database instance

systemctl <stop|start|restart> <environment_name>-<instance_name>

Show database instance log

journalctl --follow --unit <environment_name>-<instance_name>

Trigger full backup

<environment_name>-<instance_name>-backup-full.sh

Show available backups

using the wrapper

<environment_name>-<instance_name>-pgbackrest info

using pgbackrest direct

pgbackrest --stanza=<environment_name>-<instance_name> info

Start psql shell

using the wrapper

<environment_name>-<instance_name>-psql postgres

using psql direct

sudo -u postgres psql --user <superuser_name> postgres