Backing up one database

suggest change

pg_dump -Fc -f DATABASE.pgsql DATABASE

The -Fc selects the “custom backup format” which gives you more power than raw SQL; see pg_restore for more details. If you want a vanilla SQL file, you can do this instead:

pg_dump -f DATABASE.sql DATABASE

or even

pg_dump DATABASE > DATABASE.sql

Found a mistake? Have a question or improvement idea? Let me know.

Backup and Restore:

*Backup and Restore

*Backing up one database

*Restoring backups

*Backing up the whole cluster

*Using psql to export data

*Using Copy to import

*Using Copy to export