Skip to content

Instantly share code, notes, and snippets.

@vielhuber
vielhuber / script.sh
Last active April 18, 2024 09:11
PostgreSQL: Backup and restore export import pg_dump with password on command line #sql
# best practice: linux
nano ~/.pgpass
*:5432:*:username:password
chmod 0600 ~/.pgpass
# best practice: windows
edit %APPDATA%\postgresql\pgpass.conf
*:5432:*:username:password
# linux