Search Postgresql Archives

Re: Upgrading from 8.0 to 8.1 on Debian

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



* 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux