Skip to content

Instantly share code, notes, and snippets.

@BLaurenB

BLaurenB/postgres-info.txt

Created March 1, 2021 21:06
Show Gist options
  • Save BLaurenB/c9310c2c5af85cc2110124760c581f9a to your computer and use it in GitHub Desktop.
Save BLaurenB/c9310c2c5af85cc2110124760c581f9a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres-info.txt
Situation: copy Prod data and load it into QA.
Problems:
- 3 servers, all with different cersions fo Postgres. Caused issues trying to load data from 12.x into 10.x. Resolved by using pg_dump and special file locations
- need to copy files from 1 server to another -- used scp command line tool.
- databases had different names and different users. Resolved by making empty db on target server that had same name, same user.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment