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

From: Francis Santiago <santiagocfc(at)gmail(dot)com>
To: Gopi G <gopiputty(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: how do i change the password for 'postgres' user
Date: 2018-02-24 14:48:10
Message-ID: CAGrKvM8KPxrMY+=DwP9ccW7bDsP9mV6980uwiRGfbqN2vymNWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gopi G 2018-02-25 05:19:08 Re: how do i change the password for 'postgres' user
Previous Message Francis Santiago 2018-02-24 14:42:44 Re: what are all the default users and roles in postgres 9.2