| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Arup Rakshit <aruprakshit(at)rocketmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to recover or resent the password for the user 'postgres' |
| Date: | 2015-03-30 08:18:00 |
| Message-ID: | CAB7nPqQ3QgoHF9zqbMtgd_V_MreL7dSNkWmMvgHOa-Utgk1qRg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Mar 30, 2015 at 5:09 PM, Arup Rakshit <aruprakshit(at)rocketmail(dot)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(at)myapp(add_postgres_addapter)]$ su - postgres
> Password:
> su: Sorry
> [shreyas(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | avpro avpro | 2015-03-30 08:20:15 | Link Office Word form document with data from PostgreSQL |
| Previous Message | Arup Rakshit | 2015-03-30 08:09:24 | How to recover or resent the password for the user 'postgres' |