How To Backup and Restore PostgreSQL Database Using pg_dump and psqlHow To Backup and Restore PostgreSQL Database Using pg_dump and psql This is a guest post written by SathiyaMoorthy pg_dump is an effective tool to backup postgres database. It creates a *.sql file with CREATE TABLE, ALTER TABLE, and COPY SQL statements of source database. To restore these dumps psql command is enough. Using pg_dump, you can backup a local database and restore it on a remote datab
