Re: [ADMIN] Forgot Root Password

2008-04-26 Thread Tom Lane
Ray Stell <[EMAIL PROTECTED]> 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: > hostall

Re: [ADMIN] Forgot Root Password

2008-04-26 Thread Joshua D. Drake
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: hostall all 127.0.0.1/

Re: [ADMIN] Forgot Root Password

2008-04-26 Thread Craig McElroy
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:3

Re: [ADMIN] Vacuumdb error - corruption

2008-04-26 Thread Andrew Sullivan
On Fri, Apr 25, 2008 at 06:03:12PM -0400, Bhella Paramjeet-PFCW67 wrote: > No database is not sitting on NFS storage. We are using emc storage and > the file system is fibre attached to storage. What's the filesystem? Are you sure you don't have any bad memory in the box? I'm suspicious of the

[ADMIN] ERROR: could not open relation

2008-04-26 Thread Q Master
I get this strange error Caused by: org.postgresql.util.PSQLException: ERROR: could not open relation 1663/53544/58374: No such file or directory How do I recover from it ? Version 8.2 on windows. I think I had an hardware issue in the past where my box rebooted few times I assume this is du

Re: [ADMIN] Vacuumdb error - corruption

2008-04-26 Thread Eric Comeau
> -Original Message- > From: Bhella Paramjeet-PFCW67 [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 24, 2008 1:13 PM > To: Tom Lane > Cc: pgsql-admin@postgresql.org; Subbiah Stalin-XCGF84 > Subject: Re: Vacuumdb error - corruption > > > According to our sysadmin there are no bad disk

Re: [ADMIN] Forgot Root Password

2008-04-26 Thread Ray Stell
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: hostall all 127.0.0.1/32 trust