Re: database cluster - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: database cluster
Date
Msg-id GNELIHDDFBOCMGBFGEFOKEIHCAAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to database cluster  (Jodi Kanter <jkanter@virginia.edu>)
List pgsql-sql
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@postgresql.org
[mailto:pgsql-sql-owner@postgresql.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@virginia.edu



pgsql-sql by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Question
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: SELECT * FROM t where p or q;