Re: BUG #6240: About - postgreswdinit.sql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chethan HB" <chethanbasavaraj(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6240: About - postgreswdinit.sql
Date: 2011-10-05 15:23:15
Message-ID: 20003.1317828195@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

"Chethan HB" <chethanbasavaraj(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Cristian Cruz 2011-10-05 17:45:23 Re: BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)
Previous Message Alvaro Herrera 2011-10-05 14:57:54 Re: BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2011-10-05 15:24:57 Re: function "XXX" already exists with same argument types
Previous Message pasman pasmański 2011-10-05 15:22:53 Re: Restoring 2 Tables From All Databases Backup