Le lundi 31 mai 2010 10:23:51, Szymon Guz a écrit : > 2010/5/31 Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> > > > On Mon, 31 May 2010 08:47:25 -0600 > > > > Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > > > On Mon, May 31, 2010 at 2:29 AM, Michal Szymanski > > > > > > <dyrex@xxxxxxxxxxxxxx> wrote: > > > > Hi, > > > > Currently we use Debian, but it chosen by our OS admnistrator. > > > > Now we can change our OS and it is question what Linux edition > > > > will be the best. We would like have access to new versions of > > > > Postgres as soon as possible, for Debian sometimes we had to > > > > wait many weeks for official packages. > > > > > > Pgsql is pretty easy to build from source. > > > > 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. > > Remember to make a database dump before the whole operation :) > > regards > Szymon Guz Me as system architec, sysadmin and manager (gerencial power) jejej :) we have choose Mandriva, it is quite easy to install and to maintain, and speaking about packages there are many support in them, including PGSQL LD -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
