* Assad Jarrahian (jarraa@xxxxxxxxx) wrote: > jarraa@proximity:/etc/postgresql-common$ sudo pg_upgradecluster 8.0 main > Error: target cluster 8.1/main already exists This is complaining that you already did an initdb on the 8.1 version, I believe. > 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. Basically you should be able to modify /etc/postgresql/8.1/postmaster.conf (iirc) and get the 8.1 postmaster running on some alternate port. You can then use pg_restore to load up all your data from your 8.0 install into your 8.1 install. Then you just need to stop your 8.0 postmaster, modify the port for your 8.1 postmaster to the 'normal' one and restart it. Basically, Debian lets you have both installed. Once you're happy with your 8.1 install you can remove/purge your 8.0 packages. Just to note: I havn't actually done this myself yet (been thinking about it though). Also, this isn't entirely appropriate for this list (being a Debian-specific question). You can file a bug on http://bugs.debian.org asking for additional documentation to be included in the package, or if you run into problems. Enjoy, Stephen
Attachment:
signature.asc
Description: Digital signature
