Use the pg_dump command for backup and pg_restore for restoration. For example, pg_dump -U username -d dbname > backup.sql for backup and psql -U username -d dbname < backup.sql for restore.
pg_dump
pg_restore
pg_dump -U username -d dbname > backup.sql
psql -U username -d dbname < backup.sql
No comments:
Post a Comment