Re: [ADMIN] upgrade postgres 8.1.21 to version 8.3.6

2010-07-14 Thread Silvio Brandani
Gabriele Bartolini ha scritto: Ciao Silvio, On Tue, 13 Jul 2010 22:52:51 +0200, Iñigo Martinez Lasala You should script database migration process in order to make it faster. Upgrading binaries is really simple. A yum upgrade should be enough. Yes, faster and repeatable. Something you

Re: [ADMIN] upgrade postgres 8.1.21 to version 8.3.6

2010-07-14 Thread Gabriele Bartolini
Ciao Silvio, On Tue, 13 Jul 2010 22:52:51 +0200, Iñigo Martinez Lasala > You should script database migration process in order to make it faster. > Upgrading binaries is really simple. A yum upgrade should be enough. Yes, faster and repeatable. Something you can launch with a script that does eve

Re: [ADMIN] upgrade postgres 8.1.21 to version 8.3.6

2010-07-13 Thread Iñigo Martinez Lasala
With a 1GB database you should have no problem to perform upgrade in three quarters of hour. You should script database migration process in order to make it faster. Upgrading binaries is really simple. A yum upgrade should be enough. However, prior upgrading binaries, you should perform a databa

Re: [ADMIN] upgrade postgres 8.1.21 to version 8.3.6

2010-07-13 Thread Scott Marlowe
2010/7/13 Silvio Brandani : > We need to upgrade the postgres running on our production system under Red > Hat Enterprise Linux Server release 5.1  from version 8.1.21 to version > 8.3.6. > > we could have a stop/maintenance window of 3/4 our the sum of size of > databases is around  1G . > Which i

Re: [ADMIN] upgrade postgres 8.1.21 to version 8.3.6

2010-07-13 Thread Jens Wilke
Am Dienstag 13 Juli 2010 11:30:20 schrieb Silvio Brandani: > We need to upgrade the postgres running on our production system under > Red Hat Enterprise Linux Server release 5.1 from version 8.1.21 to > version 8.3.6. Have a look here: http://wiki.postgresql.org/wiki/RPM_Installation#How_do_I_per