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

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(at)gmail(dot)com>
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(at)gmail(dot)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
>>
>
>
>
>
>