Postgres Pro
Downloads
Home   >   mailing lists

Re: Could not create relation: File exists error - Mailing list pgsql-general

From Tom Lane
Subject Re: Could not create relation: File exists error
Date
Msg-id 27939.1175011999@sss.pgh.pa.us
Whole thread Raw
In response to Re: Could not create relation: File exists error  (Jesse Cleary <jcleary@email.unc.edu>)
List pgsql-general
Tree view 
Jesse Cleary <jcleary@email.unc.edu> writes:
> One exception is notable - $PGDATA/base/835021/4294967264 - this file
> has a size of 0 and a timestamp that coincides with the date and time
> range of the nightly run when these errors first appeared.  This seems
> like a good clue, but not sure what I should do next?  Thanks...

Hm.  I guess the next question is whether any of those 429... numbers
appear in pg_class.relfilenode of your database?

            regards, tom lane

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: [pgsql-advocacy] Is there a shortage of postgresql skilled ops people
Next
From: "George Pavlov"
Date:
Subject: Re: Temporarily disable all table indices