Skip to content

Instantly share code, notes, and snippets.

@emailrhoads

emailrhoads/pgdump on pg12 from AWS.sh

Created July 12, 2021 19:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save emailrhoads/2b5880e7092cd28bdf1f4b9404c5beb6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save emailrhoads/2b5880e7092cd28bdf1f4b9404c5beb6 to your computer and use it in GitHub Desktop.
Download ZIP
PGdump from AWS #aws
Raw
pgdump on pg12 from AWS.sh
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee /etc/apt/sources.list.d/pgdg.list
sudo apt update
sudo apt -y install postgresql-client-12
sudo apt -y install postgresql-12 postgresql-client-12
PGDATABASE=$GEMINI_DB PGHOST=$GEMINI_DB_HOST PGUSER=$GEMINI_DB_USER PGPASSWORD=$GEMINI_DB_PASSWORD pg_dump $GEMINI_DB -Ft -f cm_gemini_20210712.tar
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment