Re: how do i change the password for 'postgres' user

[Gopi G <gopiputty@xxxxxxxxx>]

Hi Francis

I did login like postgres.

Here is from my command:

~$ sudo -u postgres psql postgres

could not change directory to "/home/ec2-user"

Password: 

psql (9.2.24)

Type "help" for help.

postgres=> 

On Sat, Feb 24, 2018 at 6:48 AM, Francis Santiago <santiagocfc@xxxxxxxxx> wrote:

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@xxxxxxxxx>:

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