Nuclos pg_dump: PostgreSQL backup console, script, custom format, pg_restore, schema nuclos, dump.

Language: Deutsch · English

Postgres backup via console/script

PostgreSQL backup via pg_dump – scriptable custom-format dump incl. parameter explanation.

On this page

The recommended, scriptable method for a PostgreSQL backup is pg_dump in custom format.

Steps

pg_dump -U postgres -h localhost -d nuclosdb -n nuclos -F c > /home/backup/nuclos.backup

Option	Meaning
-U	database user
-h	server/host name
-d	database name
-n	schema name (Nuclos: `nuclos`)
-F c	custom format (recommended, compressed, for `pg_restore`)

After the run, check that the file size is plausible. Use pg_restore to restore a custom dump.

Overview.

pgAdmin.