Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

change postgres user password programmatically

9 views
Skip to first unread message

Mick

unread,
Jan 30, 2015, 6:47:46 PM1/30/15
to
Hi all,
Is there a way to programmatically set/change the password for the postgres user just by running queries and not touching the pg_hba.conf file?

I ran "alter user postgres with password 'test'", it ran successfully, then closed pgAdmin, restarted the service and logged back in with pgAdmin and it let me in with no password.

Please help.
Thank you in advance.
0 new messages