Postgres DB Backup & Restore
How to restore postgres db in terminal
DB BACKUP:
pg_dump -U
user_role
db_name >
archive_name.sql
DB RESTORE:
psql -U
user_role
db_name <
/directory/archive.sql or .dump or .tar
pg_dump -U
user_role
db_name >
archive_name.sql
psql -U
user_role
db_name <
/directory/archive.sql or .dump or .tar
Comments
Post a Comment