Skip site navigation (1) Skip section navigation (2)

Re: Forgot Root Password

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
Cc: Kranti K K Parisa? <kranti(dot)parisa(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Forgot Root Password
Date: 2008-04-26 17:21:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Ray Stell <stellr(at)cns(dot)vt(dot)edu> writes:
> On Sat, Apr 26, 2008 at 11:00:35AM +0530, Kranti K K Parisa? wrote:
>> Can anyone suggest a way to retrieve/update the postgres root password ?

> edit pg_hba.conf so that localhost connections from localhost are
> trusted maybe like this:

> host    all         all          trust

> you have to restart, but then you can do an alter user and so can all
> the other local users.

"ident" mode might be a safer option.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Márcio Aguiar RibeiroDate: 2008-04-26 18:45:05
Subject: Re: Server format and recovery
Previous:From: Joshua D. DrakeDate: 2008-04-26 15:09:15
Subject: Re: Forgot Root Password

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group