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

On Monday, March 30, 2015 06:27:19 AM Adrian Klaver wrote:
> On 03/30/2015 01:09 AM, Arup Rakshit 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 ?
>
> How did you install Postgres?

I didn't install. I joined a company as an Application developer, where the machine I have been assigned had PostgreSql already installed. I changed the configuration of the pg_hba.config as *trust*, and it worked.

Thanks for the help to all of you.

--
================
Regards,
Arup Rakshit
================
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.

--Brian Kernighan