Skip to content

Instantly share code, notes, and snippets.

@coilysiren

coilysiren/.pgpass

Created February 20, 2020 04:49
Show Gist options
  • Save coilysiren/d8b6d817d5d6c34082a97efa0d1878bc to your computer and use it in GitHub Desktop.
Save coilysiren/d8b6d817d5d6c34082a97efa0d1878bc to your computer and use it in GitHub Desktop.
Download ZIP
psql / pgcli with pgpass example
Raw
.pgpass
# hostname:port:database:username:password
lynn-db-one.us-west-2.rds.amazonaws.com:5432:database:username:password
lynn-db-two.us-west-2.rds.amazonaws.com:5432:database:username:password
Raw
.zshrc
alias pgcli-lynn-db-one='pgcli --host lynn-db-one.us-west-2.rds.amazonaws.com --user username database'
alias pgcli-lynn-db-two='pgcli --host lynn-db-two.us-west-2.rds.amazonaws.com --user username database'
alias psql-lynn-db-one='psql --host lynn-db-one.us-west-2.rds.amazonaws.com --user username database'
alias psql-lynn-db-two='psql --host lynn-db-two.us-west-2.rds.amazonaws.com --user username database'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment