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






























Comments

Popular posts from this blog

Uninstall ODOO module using terminal

How to Delete Menuitem-Odoo