Re: database cluster

You can't just initdb over an existing installation. Use pg_dumpall to
create a full backup schema of your databases. Then, move your existing dir
off somewhere, then re-run initdb, restore the backup up schema and once
everything's working, remove the old dirs that you moved off.

Chris

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Jodi Kanter
Sent: Tuesday, 20 November 2001 9:40 PM
To: Postgres SQL Mailing List
Subject: [SQL] database cluster

I mistakenly created a second database cluster. Can someone tell me how to
remove
this?
Also, I need to reinitialize my original cluster since I did not have my
locale set
properly. I have corrected that and now have LC_COLLATE="C" but I believe
that I
have to run initdb again. However, the directory structure already exists
and it will not
allow me to initialize into the same location.

Thanks
Jodi Kanter
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(804) 924-2846
jkanter(at)virginia(dot)edu