Home > mailing lists

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

how do i change the password for 'postgres' user

From

Gopi G

Date:

24 February 2018, 05:26:20

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

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

From

Francis Santiago

Date:

24 February 2018, 20:48:10

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

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

From

Gopi G

Date:

25 February 2018, 11:19:08

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@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

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

From

"David G. Johnston"

Date:

25 February 2018, 11:34:24

On Friday, February 23, 2018, Gopi G <gopiputty@gmail.com> wrote:

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

Something is odd here besides using an out-of-support version of PostgreSQL. I'm figuring that you'll have better luck asking your distro packager (i.e., Amazon) directly. That said the best way to change passwords with psql is the \password meta-command.

Most packages make the postgres user a superuser but apparently your distro thinks differently and you need to learn from them how things work.

David J.

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

From

Laurenz Albe

Date:

26 February 2018, 14:30:27

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