Created
August 31, 2018 12:46
-
-
Save gzamudio/9994534a1b4d84d357aea6157f60e2a0 to your computer and use it in GitHub Desktop.
Postgres config
This file contains 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
1) Abrir Terminal | |
2) Modificar contraseña de usuario ‘postgres’: | |
sudo -u postgres psql | |
alter user postgres with password 'new_password' | |
3) Abrir el archivo localizado en /etc/postgresql/<version_number>/main/pg_hba.conf, y modificar para que quede de la siguiente manera: | |
# Database administrative login by Unix domain socket | |
local all postgres md5 | |
# TYPE DATABASE USER ADDRESS METHOD | |
# "local" is for Unix domain socket connections only | |
local all all md5 | |
# IPv4 local connections: | |
host all all 127.0.0.1/32 md5 | |
# IPv6 local connections: | |
host all all ::1/128 md5 | |
Solo se debe cambiar el METHOD 'peer' a 'md5'. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment