Skip to content

Instantly share code, notes, and snippets.

@brunojabs

brunojabs/postgres_configs

Last active August 29, 2015 13:57
Show Gist options
  • Save brunojabs/9770265 to your computer and use it in GitHub Desktop.
Save brunojabs/9770265 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Configs
Raw
postgres_configs
$ sudo su postgres -c psql
$ create user user_name with password 'user_password';
$ alter user user_name superuser;
# FATAL: Peer authentication failed for user
## change local peer to MD5, line 90
$ sudo subl /etc/postgresql/9.1/main/pg_hba.conf
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment