| Auszug |
|---|
|
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.
| Status |
|---|
| colour | Blue |
|---|
| title | Administrator |
|---|
|
| Status |
|---|
| colour | Green |
|---|
| title | Updated: Jul 2026 |
|---|
|
| Status |
|---|
| colour | Grey |
|---|
| title | applies to Nuclos 4.2026.x |
|---|
|
The recommended, scriptable method for a PostgreSQL backup is pg_dump in custom format.
Steps
- Open a terminal or
cmd. - Run the following command:
| Codeblock |
|---|
|
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) |
| Tipp |
|---|
|
After the run, check that the file size is plausible. Use pg_restore to restore a custom dump. |
Related pages
Create a Postgres backup
pgAdmin.
Open →
