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 11673.1174970228@sss.pgh.pa.us
Whole thread Raw
In response to Could not create relation: File exists error  (Jesse Cleary <jcleary@email.unc.edu>)
Responses 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:
> This script has been running successfully for several months (70-90 min each night).  Out of the blue I'm now getting
thefollowing error message after each psql command, except the last vacuum full analyze command: 

> ERROR:  could not create relation 1663/835021/4294967254: File exists

Hm, it seems suggestive that the last number is only a few counts short
of UINT_MAX.  Not sure what to make of it though.  Do you in fact have
files under $PGDATA/base/835021/ with names in that range?

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: How can I select a comment on a column?
Next
From: Oleg Bartunov
Date:
Subject: Re: pg_dump without psql rights