how do i change the password for 'postgres' user

From: Gopi G <gopiputty(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: how do i change the password for 'postgres' user
Date: 2018-02-23 23:26:20
Message-ID: CAC9HVwmbzYXdPixFzRwmEVe0XJhw5OTtxHrv2BcTEM3UDX77=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Francis Santiago 2018-02-24 14:42:44 Re: what are all the default users and roles in postgres 9.2
Previous Message Gopi G 2018-02-23 23:20:55 Re: what are all the default users and roles in postgres 9.2