From jkanter@virginia.edu Tue Nov 20 13:39:29 2001 Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAKDdTm22719 for ; Tue, 20 Nov 2001 08:39:29 -0500 (EST) (envelope-from jkanter@virginia.edu) Received: from smtp.mail.virginia.edu by mail.virginia.edu id aa17068; 20 Nov 2001 8:39 EST Received: from jlk3xpc (d-128-19-222.bootp.Virginia.EDU [128.143.19.222]) by smtp.mail.Virginia.EDU (8.9.3/8.9.3) with SMTP id IAA26300 for ; Tue, 20 Nov 2001 08:39:31 -0500 Message-ID: <005a01c171c8$cf7b0b70$de138f80@virginia.edu> From: Jodi Kanter To: Postgres SQL Mailing List Subject: database cluster Date: Tue, 20 Nov 2001 08:39:42 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0057_01C1719E.E681C400" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200111/322 X-Sequence-Number: 5704 This is a multi-part message in MIME format. ------=_NextPart_000_0057_01C1719E.E681C400 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I mistakenly created a second database cluster. Can someone tell me how to = remove=20 this?=20 Also, I need to reinitialize my original cluster since I did not have my lo= cale set=20 properly. I have corrected that and now have LC_COLLATE=3D"C" but I believe= that I=20 have to run initdb again. However, the directory structure already exists a= nd 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 ------=_NextPart_000_0057_01C1719E.E681C400 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I mistakenly created a second database clu= ster. Can=20 someone tell me how to remove
this?
Also, I need to reinitialize my= =20 original cluster since I did not have my locale set
properly. I have=20 corrected that and now have LC_COLLATE=3D"C" but I believe that I
have = to run=20 initdb again. However, the directory structure already exists and it will= =20 not
allow me to initialize into the same location.
 
Thanks
Jodi Kanter

_______________________________
Jodi= =20 L Kanter
BioInformatics Database Administrator
University of=20 Virginia
(804) 924-2846
jkanter@virginia.edu

------=_NextPart_000_0057_01C1719E.E681C400-- From chriskl@familyhealth.com.au Fri Nov 23 01:49:40 2001 Received: from mail.iinet.net.au (symphony-05.iinet.net.au [203.59.3.37]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAN1nem95197 for ; Thu, 22 Nov 2001 20:49:40 -0500 (EST) (envelope-from chriskl@familyhealth.com.au) Received: (qmail 14455 invoked by uid 666); 23 Nov 2001 01:49:38 -0000 Received: from unknown (HELO houston.familyhealth.com.au) (203.59.231.6) by mail.iinet.net.au with SMTP; 23 Nov 2001 01:49:38 -0000 Received: (from root@localhost) by houston.familyhealth.com.au (8.11.6/8.11.6) id fAN1ndb52442 for pgsql-sql@postgresql.org; Fri, 23 Nov 2001 09:49:39 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Received: from mariner (mariner.internal [192.168.0.101]) by houston.familyhealth.com.au (8.11.6/8.9.3) with SMTP id fAN1ncG52345; Fri, 23 Nov 2001 09:49:38 +0800 (WST) From: "Christopher Kings-Lynne" To: "Jodi Kanter" , "Postgres SQL Mailing List" Subject: Re: database cluster Date: Fri, 23 Nov 2001 09:49:57 +0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 In-Reply-To: <005a01c171c8$cf7b0b70$de138f80@virginia.edu> Importance: Normal X-scanner: scanned by Inflex 0.1.5c - (http://www.inflex.co.za/) X-Archive-Number: 200111/328 X-Sequence-Number: 5710 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