On Mon, 31 May 2010 17:23:51 +0200
Szymon Guz <mabew...@gmail.com> wrote:

> > Yeah it is. But what is it going to be an upgrade process? On a
> > production box?
> > Any experience to share on upgrading from source on Debian?

> Usually that's pretty easy: for upgrading the minor version (e.g.
> from 8.3.1 to 8.3.3) it should be enough to compile the new
> sources, stop server, run `make install` and run the server with
> new binaries. Upgrading from 8.3 to 8.4 can be easily done using
> dump from current version. There is nothing wrong to run the new
> and old postgres versions parallel so you can copy data from one
> database to another. There is also pgmigrator, but I haven't
> checked that yet.

That's clear but there are a bunch of small and possibly very
annoying details that make deploying in production a bit more
challenging than ./configure, make, make install.

I admit I only compiled postgres in my /home when I was developing
an extension. It is something I do rarely and never on production.

If I was thinking to upgrade on a debian box that is already running
a packaged version I'd have to understand how deal with debian
patches (I think most were related to paths where postgres expect to
find it's stuff).

Once I understand what all debian patches do I'll try to see if I
can avoid them all so that upgrading will be easier the next time.

I'll have to see how debian ./configure the package, I'll have to
replicate the init.d script for the newer version, take care of
making the 2 servers run temporarily on different ports... etc...

I could even think of making a .deb

I think about it I could even come up with a longer list of things I
should do.

I bet I'm not the first one that's going to upgrade Debian from
source. So someone may share his recipe and caveats.

I was actually thinking to test 9.0 in my /home on some real world
DB. That could be a chance to learn how to upgrade from source.

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to