pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedForgot Root Password
5+ messages / 5 participants
[nested] [flat]
* Forgot Root Password
@ 2008-04-26 05:30 Kranti K K Parisa™ <kranti.parisa@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Kranti K K Parisa™ @ 2008-04-26 05:30 UTC (permalink / raw)
To: pgsql-admin
Hi,
Can anyone suggest a way to retrieve/update the postgres root password ?
thanks in advance
--
Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Forgot Root Password
@ 2008-04-26 12:34 Ray Stell <stellr@cns.vt.edu>
parent: Kranti K K Parisa™ <kranti.parisa@gmail.com>
0 siblings, 3 replies; 5+ messages in thread
From: Ray Stell @ 2008-04-26 12:34 UTC (permalink / raw)
To: Kranti K K Parisa? <kranti.parisa@gmail.com>; +Cc: pgsql-admin
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 127.0.0.1/32 trust
you have to restart, but then you can do an alter user and so can all the other local
users.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Forgot Root Password
@ 2008-04-26 12:56 Craig McElroy <craig.mcelroy@contegix.com>
parent: Ray Stell <stellr@cns.vt.edu>
2 siblings, 0 replies; 5+ messages in thread
From: Craig McElroy @ 2008-04-26 12:56 UTC (permalink / raw)
To: pgsql-admin
Also, if you wish to avoid a full restart of the database, this change
would be picked up by a "pg_ctl reload" as well.
Cheers,
-craig
---
Craig A. McElroy
Contegix LLC
Beyond Managed Hosting(r) for Your Enterprise
On Apr 26, 2008, at 7:34 AM, Ray Stell wrote:
> 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 127.0.0.1/32 trust
>
> you have to restart, but then you can do an alter user and so can
> all the other local
> users.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Forgot Root Password
@ 2008-04-26 15:09 Joshua D. Drake <jd@commandprompt.com>
parent: Ray Stell <stellr@cns.vt.edu>
2 siblings, 0 replies; 5+ messages in thread
From: Joshua D. Drake @ 2008-04-26 15:09 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: Kranti K K Parisa? <kranti.parisa@gmail.com>; pgsql-admin
Ray Stell wrote:
> 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 127.0.0.1/32 trust
>
> you have to restart, but then you can do an alter user and so can all the other local
> users.
You do not need to restart, just reload.
pg_ctl -D data reload
Joshua D. Drake
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Forgot Root Password
@ 2008-04-26 17:21 Tom Lane <tgl@sss.pgh.pa.us>
parent: Ray Stell <stellr@cns.vt.edu>
2 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2008-04-26 17:21 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: Kranti K K Parisa? <kranti.parisa@gmail.com>; pgsql-admin
Ray Stell <stellr@cns.vt.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 127.0.0.1/32 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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-04-26 17:21 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-26 05:30 Forgot Root Password Kranti K K Parisa™ <kranti.parisa@gmail.com>
2008-04-26 12:34 ` Ray Stell <stellr@cns.vt.edu>
2008-04-26 12:56 ` Craig McElroy <craig.mcelroy@contegix.com>
2008-04-26 15:09 ` Joshua D. Drake <jd@commandprompt.com>
2008-04-26 17:21 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox