Обсуждение: 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.
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 Kanter
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(804) 924-2846
jkanter@virginia.edu
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