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

Поиск
Список
Период
Сортировка
От Francis Santiago
Тема Re: how do i change the password for 'postgres' user
Дата
Msg-id CAGrKvM8KPxrMY+=DwP9ccW7bDsP9mV6980uwiRGfbqN2vymNWA@mail.gmail.com
обсуждение исходный текст
Ответ на how do i change the password for 'postgres' user  (Gopi G <gopiputty@gmail.com>)
Ответы Re: how do i change the password for 'postgres' user  (Gopi G <gopiputty@gmail.com>)
Список 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@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




В списке pgsql-admin по дате отправления:

Предыдущее
От: Francis Santiago
Дата:
Сообщение: Re: what are all the default users and roles in postgres 9.2
Следующее
От: Gopi G
Дата:
Сообщение: Re: how do i change the password for 'postgres' user