Last active
November 8, 2019 00:26
-
-
Save zmb3/f63bb10344bc2ae1580e55768d33b2f8 to your computer and use it in GitHub Desktop.
Backup/Restore Concourse DB
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # from Concourse DB VM: | |
| # backup | |
| cd /var/vcap/packages/postgresql_9.3/bin | |
| ./pg_dump -U vcap -d atc --format=c --schema-only --file=concourse-schema.sql | |
| ./pg_dump -U vcap -d atc --format=c --data-only --file=concourse-data.sql | |
| # restore | |
| cd /var/vcap/packages/postgresql_9.3/bin | |
| ./pg_restore -U vcap -d atc -v concourse-schema.sql | |
| ./pg_restore -U vcap -d atc -v concourse-data.sql |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment