Re: BUG #6240: About - postgreswdinit.sql - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6240: About - postgreswdinit.sql
Date
Msg-id 20003.1317828195@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6240: About - postgreswdinit.sql  ("Chethan HB" <chethanbasavaraj@gmail.com>)
List pgsql-bugs
"Chethan HB" <chethanbasavaraj@gmail.com> writes:
> Jan  1 02:05:10.531239 warn CLA-0 postgres[9919]: [2-1] ERROR:  could not
> create file "base/16384/11500": File exists        [This error is from postgres
> server]
> Jan  1 02:05:10.531317 warn CLA-0 postgres[9919]: [2-2] STATEMENT:  create
> database postgreswd;

This is extremely strange on several levels.  Are you sure you are using
an unmodified Postgres 9.0.4 server?  In my copy of 9.0, there would
never be a file with a relfilenode number as small as 11500, not to
mention that CREATE DATABASE should certainly not be targeting a
nonempty subdirectory of $PGDATA/base to create a new database in.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)
Next
From: Daniel Cristian Cruz
Date:
Subject: Re: BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)