No Translation available yet
You have Czech selected as language but this page has not been translated yet. Translate the page or view the content in the default space language below.
Display default
Application level backup
See Domain Backup guide.
Database level backup
There are three fundamentally different approaches to backing up PostgreSQL data:
SQL dump
File system level backup
Continuous archiving
Each has its own strengths and weaknesses; each is discussed on the PostgreSQL documentation pages.
The most common is the SQL dump, which backups the database contents using the dump command:
pg_dump -U user -p port -F c -v -f "path_to_dump/dump.backup" belladati_db
Copy the backup file to your new system and restore it in the target database:
pg_restore -v -c -O -d belladati_db -U user -p port path_to_dump/dump.backup