Re: [GENERAL] Could not create relation: File exists error

2007-03-27 Thread Jesse Cleary
Tom Lane wrote: Jesse Cleary <[EMAIL PROTECTED]> writes: This script has been running successfully for several months (70-90 min each night). Out of the blue I'm now getting the following error message after each psql command, except the last vacuum full analyze command: ERROR: could not

Re: [GENERAL] Could not create relation: File exists error

2007-03-27 Thread Tom Lane
Jesse Cleary <[EMAIL PROTECTED]> writes: > This script has been running successfully for several months (70-90 min each > night). Out of the blue I'm now getting the following error message after > each psql command, except the last vacuum full analyze command: > ERROR: could not create relatio

Re: [GENERAL] Could not create relation: File exists error

2007-03-27 Thread Tom Lane
Jesse Cleary <[EMAIL PROTECTED]> 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

Re: [GENERAL] Could not create relation: File exists error

2007-03-27 Thread Jesse Cleary
Tom Lane wrote: Jesse Cleary <[EMAIL PROTECTED]> writes: This script has been running successfully for several months (70-90 min each night). Out of the blue I'm now getting the following error message after each psql command, except the last vacuum full analyze command: ERROR:

Re: [GENERAL] Could not create relation: File exists error

2007-03-26 Thread Tom Lane
Jesse Cleary <[EMAIL PROTECTED]> writes: > This script has been running successfully for several months (70-90 min each > night). Out of the blue I'm now getting the following error message after > each psql command, except the last vacuum full analyze command: > ERROR: could not create relati