pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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