Language: Deutsch · English
Postgres backup via console/script
PostgreSQL backup via pg_dump – scriptable custom-format dump incl. parameter explanation.
HOW-TO ADMINISTRATOR STAND: JUL 2026 GILT FUER NUCLOS 4.2026.X
Auf dieser Seite
The recommended, scriptable method for a PostgreSQL backup is pg_dump in custom format.
Steps
- Open a terminal or
cmd. - Run the following command:
pg_dump -U postgres -h localhost -d nuclosdb -n nuclos -F c > /home/backup/nuclos.backup
Parameters
| 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) |
Verification
After the run, check that the file size is plausible. Use pg_restore to restore a custom dump.
Related pages
Überblick
Inhalte