Message-ID: <1519633827.2714.6.camel@cybertec.at>
Subject: Re: how do i change the password for 'postgres' user
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Gopi G <gopiputty@gmail.com>, Francis Santiago <santiagocfc@gmail.com>
Cc: Pgsql-admin <pgsql-admin@postgresql.org>
Date: Mon, 26 Feb 2018 09:30:27 +0100
In-Reply-To: 
 <CAC9HVwkwBPZiuJcM1KjQahH=cN8Q9xexRhrsvrZrBOvWcKnX=A@mail.gmail.com>
References: 
	<CAC9HVwmbzYXdPixFzRwmEVe0XJhw5OTtxHrv2BcTEM3UDX77=g@mail.gmail.com>
	 <CAGrKvM8KPxrMY+=DwP9ccW7bDsP9mV6980uwiRGfbqN2vymNWA@mail.gmail.com>
	 <CAC9HVwkwBPZiuJcM1KjQahH=cN8Q9xexRhrsvrZrBOvWcKnX=A@mail.gmail.com>
Organization: Cybertec
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk

Gopi G wrote:
> On Sat, Feb 24, 2018 at 6:48 AM, Francis Santiago <santiagocfc@gmail.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@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
> > 
> 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=> 

Check \du in psql to see if you have any superusers left.

If not, you must stop the server and start it in single user mode
(postgres --single -D /data/directory dbname).

Once you are connected as superuser or in single user mode,
give "postgres" its superuser privilege back:

ALTER ROLE postgres SUPERUSER;

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com