surabhi.ahuja wrote:
> i am trying to install postgresql-8.0.1
Why? The most recent release for 8.0 is 8.0.6 and you're clearly
compiling from source, so why have you deliberately chosen an old release?
> i am now trying to do
> /usr/local/pgsql/bin/initdb -D data/
I'd specify an absolute path here myself: -D /usr/local/pgsql/data
> however this is what i get:
>
> The files belonging to this database system will be owned by user "surabi".
OK - you've chosen to override the default user of "postgres",
presumably you know what you're doing.
> This user must also own the server process.
[snip]
> creating system views ... ok
> loading pg_description ... FATAL: duplicate key violates unique constraint "pg_description_o_c_o_index"
> child process exited with exit code 1
> initdb: removing contents of data directory "data"
Well - the error says what the problem is, somehow the pg_description
table is being loaded with duplicate rows. The primary-key is stopping
this form happening (good).
At a guess, this is due to one of three things:
1. You have two versions of the postgresql source and somehow bits are
getting mixed up.
2. You have made alterations to the source-code and duplicated an OID
already in use somewhere
3. You somehow have a non-release or development version of the code
from CVS which had a bug in it at the second you downloaded it.
In any case, I'd recommend deleting your existing source tree (and all
of /usr/local/pgsql), download 8.0.6 and run a new ./configure; make;
make install cycle.
--
Richard Huxton
Archonet Ltd
