Versions Compared

Old Version 7

changes.mady.by.user Unknown User (huyennth@fpt.com.vn)

Saved on

compared with

New Version 8

changes.mady.by.user Ondrej Špalek

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
https://www.youtube.com/watch?v=WhmIWKNsiKY480

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.

Sv translation
languageen

Application level backup

See Domain Backup guide or use video tutorial below

Widget Connector
width640
urlheight
Info

All settings, meta-data and raw data are stored within the PostgreSQL database server. Database backup is sufficient to preserve the entire BellaDati application.

The most common is the SQL dump, which backups the database contents using the dump command:

Code Block
pg_dump -U user -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:

Code Block
pg_restore -v -c -O -d belladati_db -U user path_to_dump/dump.backup

...