Postgresql database backup and recovery methods

Example: Backup and Recovery in command mode

Start-run-cmd the dos console is displayed. Then, go to the PostgreSQL installation directory bin in the console and find the pg_dump.exe,psql.exe files.

Backup

The code is as follows:	Copy code
C:/Program Files/PostgreSQL/9.2/bin> pg_dump-h localhost-U postgres cxy> cxy. bak Restore C:/Program Files/PostgreSQL/9.2/bin> psql-h localhost-U postgres-d cxy <cxy. backup

The Yunqi community editor reminds you that Postgresql backups include SQL dump file system-level backup (cold backup) l online hot backup (Archive) and so on.