PostgreSQL

Migrate Database

Find Settings of existing Database sudo -u postgres psql --cluster <version>/main -- Database...

Backup Database

Find Database to Backup 1. List all Postgres Instances: pg_lsclusters root@SRV-PSQL-PRD-01:~# ...

Access Instance by Port

1. Identify Instance Port pg_lsclusters root@db-psql-prd-01:~# pg_lsclusters Ver Cluster Port St...

pgadmin4

Create Application Database

Creating a Postgres Database for an Application (CLI) Option 1: DBA creates the database directly...