By default, should never change the postgres user password
See http://serverfault.com/a/325596/61030
To access the database as postgres,
- go into the server
- use
sudo -u postgres psql postgres
Last active
August 29, 2015 14:26
-
-
Save simkimsia/75995639e575707db5f1 to your computer and use it in GitHub Desktop.
pg_hba.conf for 9.3 so that I can access via TCP/IP connection over remote connection
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # "local" is for Unix domain socket connections only | |
| local all postgres peer | |
| local all all peer | |
| # IPv4 local connections: | |
| host all all 127.0.0.1/32 md5 | |
| # IPv6 local connections: | |
| host all all ::1/128 ident |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment