deneuv34/backe_restore.md

Created January 28, 2021 08:59

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/deneuv34/2d55568d8df28fc946834e10571981a9.js"></script>
Save deneuv34/2d55568d8df28fc946834e10571981a9 to your computer and use it in GitHub Desktop.

Download ZIP

Backup and Restore PostgreSQL

Raw

backe_restore.md

Backup

This command mean is backup data with plain .sql file to defined path output

$ pg_dump -x -h localhost -p 5432 -U bioskoponline -W -F p db_name > /path/to/file.sql

Restore

To restore the generated plain sql file, you can only restore by psql command:

$ psql -h localhost -U postgres -p 54321 db_name < /path/to/file.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment