Skip to content

Instantly share code, notes, and snippets.

@raybesiga

raybesiga/script.sh

Forked from vielhuber/script.sh
Created July 11, 2018 16:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save raybesiga/d61f41f95845d9fdcb77e8c7395ec152 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save raybesiga/d61f41f95845d9fdcb77e8c7395ec152 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL: Backup and restore pg_dump with password on command line #sql
Raw
script.sh
# best practice: linux
nano ~/.pgpass
*:5432:*:username:password
chmod 0600 ~/.pgpass
# best practice: windows
edit %APPDATA%\postgresql\pgpass.conf
*:5432:*:username:password
# linux
PGPASSWORD="password" pg_dump -h host -p port -U username database > file.sql
# windows
PGPASSWORD=password&& pg_dump -h host -p port -U username database > file.sql
# alternative
pg_dump --dbname=postgresql://username:password@host:port/database > file.sql
# restore
psql -U postgres database < file.sql
# backup and restore
PGPASSWORD=password && pg_dump -h 127.0.0.1 -p 5432 -U username database > tmp.sql
psql -U postgres -d database -c "drop schema public cascade; create schema public;"
psql -U postgres -d database -1 -f tmp.sql
rm tmp.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment