"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