pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
database cluster
2+ messages / 2 participants
[nested] [flat]

* database cluster
@ 2001-11-20 13:39 Jodi Kanter <jkanter@virginia.edu>
  2001-11-23 01:49 ` Re: database cluster Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  0 siblings, 1 reply; 2+ messages in thread

From: Jodi Kanter @ 2001-11-20 13:39 UTC (permalink / raw)
  To: 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@virginia.edu

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: database cluster
  2001-11-20 13:39 database cluster Jodi Kanter <jkanter@virginia.edu>
@ 2001-11-23 01:49 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  0 siblings, 0 replies; 2+ messages in thread

From: Christopher Kings-Lynne @ 2001-11-23 01:49 UTC (permalink / raw)
  To: Jodi Kanter <jkanter@virginia.edu>; 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-11-23 01:49 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-11-20 13:39 database cluster Jodi Kanter <jkanter@virginia.edu>
2001-11-23 01:49 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox