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

Поиск
Список
Период
Сортировка
От Gopi G
Тема Re: how do i change the password for 'postgres' user
Дата
Msg-id CAC9HVwkwBPZiuJcM1KjQahH=cN8Q9xexRhrsvrZrBOvWcKnX=A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how do i change the password for 'postgres' user  (Francis Santiago <santiagocfc@gmail.com>)
Ответы Re: how do i change the password for 'postgres' user
Список pgsql-admin
Дерево обсуждения

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





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

Предыдущее
От: Francis Santiago
Дата:
Сообщение: Re: how do i change the password for 'postgres' user
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: how do i change the password for 'postgres' user