Hi All, I am a bit stumped. So I have a couple of Postgresql versions on my server, namely 8.0 and 8.1 (using Debian package manager). I am trying to get 8.1 to be the default database and delete 8.0
I used pg_dump to dump my db's into a file (Question: Where do I dump the data of the tables in the db?). I tried running pg_upgradecluster as shown below, and I get an error. [EMAIL PROTECTED]:/etc/postgresql-common$ sudo pg_upgradecluster 8.0 main Error: target cluster 8.1/main already exists I went through /usr/share/doc/postgresql-common/architecture.html and am a little lost. What would be the step by step process in this case? I would like to backup the db (plus its data), then point everything to the new Postgresql version and get all my db's on to that. Any help would be much appreciated. Thanks. -assad ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
