I have an existing 8.4 cluster (named
main) that I want to upgrade to 9.1. However, when I go to upgrade it, I get an error because 9.1 already has a cluster named
main (apparently a default cluster that is created when I did a
sudo apt-get install postgresql-9.1-postgis):
$ pg_upgradecluster 8.4 main Error: target cluster 9.1/main already exists
What should I do?
Remove the default 9.1/main cluster? How?
Rename the 9.1/main cluster? How?
Is there anything special about the Postgresql default
Ubuntu 11.10 Oneiric, Postgresql 8.4.8 and 9.1.4
Update: I just found this AskUbuntu question-and-answer that says to first do a
pg_dropcluster --stop 9.1 main I tried that and it worked. So now I'm wondering if there's any data, configuration settings, etc. in the default 9.1
main cluster that I might be losing by dropping it?