Re: How to recover or resent the password for the user 'postgres'

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: How to recover or resent the password for the user 'postgres'
Дата
Msg-id CAB7nPqQ3QgoHF9zqbMtgd_V_MreL7dSNkWmMvgHOa-Utgk1qRg@mail.gmail.com
обсуждение исходный текст
Ответ на How to recover or resent the password for the user 'postgres'  (Arup Rakshit <aruprakshit@rocketmail.com>)
Список pgsql-general
Дерево обсуждения


On Mon, Mar 30, 2015 at 5:09 PM, Arup Rakshit <aruprakshit@rocketmail.com> wrote:
Hi,

I am trying to follow what has been mentioned below **Setting Up Postgres** (https://www.digitalocean.com/community/tutorials/how-to-setup-ruby-on-rails-with-postgres).

But no luck!

[shreyas@myapp(add_postgres_addapter)]$ su - postgres
Password:
su: Sorry
[shreyas@myapp (add_postgres_addapter)]$

It is asking me the password, whereas I don't know the password of the user `postgres`. How would I create a new role with a password in this case ?

The user whose password has visibly been lost is not the database user postgres, but the OS user postgres. If you have root on this server access, simply enforce the password to a new value.
--
Michael

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

Предыдущее
От: Arup Rakshit
Дата:
Сообщение: How to recover or resent the password for the user 'postgres'
Следующее
От: avpro avpro
Дата:
Сообщение: Link Office Word form document with data from PostgreSQL