Postgres Pro
Downloads
Home   >   mailing lists

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

From Gopi G
Subject how do i change the password for 'postgres' user
Date
Msg-id CAC9HVwmbzYXdPixFzRwmEVe0XJhw5OTtxHrv2BcTEM3UDX77=g@mail.gmail.com
Whole thread Raw
Responses Re: how do i change the password for 'postgres' user  (Francis Santiago <santiagocfc@gmail.com>)
Re: how do i change the password for 'postgres' user  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
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: Gopi G
Date:
Subject: Re: what are all the default users and roles in postgres 9.2
Next
From: Francis Santiago
Date:
Subject: Re: what are all the default users and roles in postgres 9.2