Re: [GENERAL] Can't open Postgres at all!!!

2006-08-24 Thread Joshua D. Drake
006 9:06 AM To: Silvela, Jaime (Exchange) Cc: pgsql-general Subject: Re: [GENERAL] Can't open Postgres at all!!! "Silvela, Jaime \(Exchange\)" <[EMAIL PROTECTED]> writes: I just came back this morning after doing a REINDEX of pg_class Nothing is working. I try to REIN

Re: [GENERAL] Can't open Postgres at all!!!

2006-08-24 Thread Tom Lane
"Silvela, Jaime \(Exchange\)" <[EMAIL PROTECTED]> writes: >> If the index entries for the system catalogs themselves are hosed, >> you may have to start the session with PGOPTIONS="-P" (to disable >> trusting system indexes) in order to do REINDEX successfully. > Excuse my ignorance, how do I do t

Re: [GENERAL] Can't open Postgres at all!!!

2006-08-24 Thread Silvela, Jaime \(Exchange\)
sday, August 24, 2006 9:06 AM To: Silvela, Jaime (Exchange) Cc: pgsql-general Subject: Re: [GENERAL] Can't open Postgres at all!!! "Silvela, Jaime \(Exchange\)" <[EMAIL PROTECTED]> writes: > I just came back this morning after doing a REINDEX of pg_class > Nothing is

Re: [GENERAL] Can't open Postgres at all!!!

2006-08-24 Thread Silvela, Jaime \(Exchange\)
Excuse my ignorance, how do I do that. Linux env setting? Is it a command line option for Postmaster? -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, August 24, 2006 9:06 AM To: Silvela, Jaime (Exchange) Cc: pgsql-general Subject: Re: [GENERAL] Can't

Re: [GENERAL] Can't open Postgres at all!!!

2006-08-24 Thread Tom Lane
"Silvela, Jaime \(Exchange\)" <[EMAIL PROTECTED]> writes: > I just came back this morning after doing a REINDEX of pg_class > Nothing is working. I try to REINDEX pg_class and it complains > ERROR: could not open relation 1663/16390/2662: No such file or > directory If the index entries for the