Last active
August 29, 2015 14:08
-
-
Save claytantor/dfc58203690de7ebbec2 to your computer and use it in GitHub Desktop.
Reset your postgres user password
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
[ec2-user@ip-10-45-187-20 ~]$ pg_config | |
BINDIR = /usr/bin | |
DOCDIR = /usr/share/doc/pgsql | |
HTMLDIR = /usr/share/doc/pgsql | |
INCLUDEDIR = /usr/include | |
PKGINCLUDEDIR = /usr/include/pgsql | |
INCLUDEDIR-SERVER = /usr/include/pgsql/server | |
LIBDIR = /usr/lib64 | |
PKGLIBDIR = /usr/lib64/pgsql | |
LOCALEDIR = /usr/share/locale | |
MANDIR = /usr/share/man | |
SHAREDIR = /usr/share/pgsql | |
SYSCONFDIR = /etc/sysconfig/pgsql | |
PGXS = /usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk | |
CONFIGURE = '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--target=x86_64-amazon-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib64' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/var/lib' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--disable-rpath' '--with-perl' '--with-tcl' '--with-tclconfig=/usr/lib64' '--with-python' '--with-ldap' '--with-openssl' '--with-pam' '--with-krb5' '--with-gssapi' '--with-ossp-uuid' '--with-libxml' '--with-libxslt' '--enable-nls' '--enable-dtrace' '--with-system-tzdata=/usr/share/zoneinfo' '--sysconfdir=/etc/sysconfig/pgsql' '--datadir=/usr/share/pgsql' 'build_alias=x86_64-redhat-linux-gnu' 'host_alias=x86_64-redhat-linux-gnu' 'target_alias=x86_64-amazon-linux-gnu' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DLINUX_OOM_SCORE_ADJ=0' | |
CC = gcc | |
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 | |
CFLAGS = -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DLINUX_OOM_SCORE_ADJ=0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard | |
CFLAGS_SL = -fpic | |
LDFLAGS = -Wl,--as-needed | |
LDFLAGS_EX = | |
LDFLAGS_SL = | |
LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm | |
VERSION = PostgreSQL 9.2.7 | |
1. In pg_hba.conf, insert or change the below line. | |
from : | |
local all postgres | |
to | |
local all postgres trust sameuser | |
2. Restart PostgreSQL services in order for Step 1 changes to take effect : | |
In Linux, | |
/etc/init.d/postgresql-8.3 restart | |
In FreeBSD, | |
/usr/local/etc/rc.d/postgres restart | |
3. Login to PostgreSQL on the local machine with the user name "postgres" to change the password : | |
e.g. | |
psql -U postgres | |
4. At the "postgres=#" prompt, change the user name "postgres" password : | |
e.g. | |
ALTER USER postgres with password 'secure-password'; | |
5. Quit PostgreSQL interactive session by executing "\q", to exit | |
6. Alter the configuration (what we did in Step 1) to disable password-less login from local machine to PostgreSQL by changing the word "trust" to "md5" in pg_hba.conf. | |
e.g. | |
from: | |
local all postgres trust sameuser | |
to: | |
local all postgres md5 sameuser | |
7. Restart PostgreSQL to make Step 6 changes take effect by repeating Step 2. | |
8. Re-login to PostgreSQL using the new password by : | |
psql -U postgres | |
Voilla !!! |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment