| Lists: | pgsql-sql |
|---|
| From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
|---|---|
| To: | Postgres SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | database cluster |
| Date: | 2001-11-20 13:39:42 |
| Message-ID: | 005a01c171c8$cf7b0b70$de138f80@virginia.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-sql |
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
| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Jodi Kanter" <jkanter(at)virginia(dot)edu>, "Postgres SQL Mailing List" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: database cluster |
| Date: | 2001-11-23 01:49:57 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOKEIHCAAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(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