Postgres Pro
Downloads
Home   >   mailing lists

Re: how do i change the password for 'postgres' user - Mailing list pgsql-admin

From Francis Santiago
Subject Re: how do i change the password for 'postgres' user
Date
Msg-id CAGrKvM8KPxrMY+=DwP9ccW7bDsP9mV6980uwiRGfbqN2vymNWA@mail.gmail.com
Whole thread Raw
In response to how do i change the password for 'postgres' user  (Gopi G <gopiputty@gmail.com>)
Responses Re: how do i change the password for 'postgres' user
List pgsql-admin
Tree view
you entered as the Postgres user, it seems that not because he says : postgres=>

When you enter with the postgres user, it is: postgres=# 

2018-02-23 20:26 GMT-03:00 Gopi G <gopiputty@gmail.com>:
I have postgres 9.2 running in AWS EC2 (aws linux) instance. 
I followed documentation and tried to do 

postgres=> ALTER USER Postgres WITH PASSWORD 'password';

ERROR:  must be superuser to alter replication users


surprisingly I am not finding any way to solve this problem. 
and how do I login using 'postgres' linux os user that is created when I installed postgres 9.2?

gopi




pgsql-admin by date:

Previous
From: Francis Santiago
Date:
Subject: Re: what are all the default users and roles in postgres 9.2
Next
From: Gopi G
Date:
Subject: Re: how do i change the password for 'postgres' user