Re: [GENERAL] Upgrading Postgres question

2008-11-10 Thread Erik Jones
On Nov 10, 2008, at 10:03 AM, Scott Marlowe wrote: On Wed, Nov 5, 2008 at 2:19 PM, Tony Fernandez <[EMAIL PROTECTED]> wrote: Hello all, I am in the process of updating my DB on Postgres 8.1.11 to 8.3.4. I also use Slony 1.2.14 for replication. Then you're set. One of the primary purp

Re: [GENERAL] Upgrading Postgres question

2008-11-10 Thread Scott Marlowe
On Wed, Nov 5, 2008 at 2:19 PM, Tony Fernandez <[EMAIL PROTECTED]> wrote: > Hello all, > > > > I am in the process of updating my DB on Postgres 8.1.11 to 8.3.4. I also > use Slony 1.2.14 for replication. Then you're set. One of the primary purposes of slony is upgrading in place. Take one of y

Re: [GENERAL] Upgrading Postgres question

2008-11-10 Thread Richard Huxton
Tony Fernandez wrote: > Hello all, > > > > I am in the process of updating my DB on Postgres 8.1.11 to 8.3.4. I > also use Slony 1.2.14 for replication. The other option is to use slony itself - it will replicate between versions. -- Richard Huxton Archonet Ltd -- Sent via pgsql-gener

Re: [GENERAL] Upgrading Postgres question

2008-11-10 Thread Tony Fernandez
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joao Ferreira gmail Sent: Monday, November 10, 2008 10:36 AM To: pgsql-general Subject: Re: [GENERAL] Upgrading Postgres question On Wed, 2008-11-05 at 15:08 -0600, Tony Fernandez wrote: > Hello all, > > > > I am in

Re: [GENERAL] Upgrading Postgres question

2008-11-10 Thread Joao Ferreira gmail
On Wed, 2008-11-05 at 15:08 -0600, Tony Fernandez wrote: > Hello all, > > > > I am in the process of updating my DB on Postgres 8.1.11 to 8.3.4. I > also use Slony 1.2.14 for replication. > > > > Is there a safe path on how to accomplish this, please advice on what > steps I will need to c

[GENERAL] Upgrading Postgres question

2008-11-10 Thread Tony Fernandez
Hello all, I am in the process of updating my DB on Postgres 8.1.11 to 8.3.4. I also use Slony 1.2.14 for replication. Is there a safe path on how to accomplish this, please advice on what steps I will need to consider. Bear in mind that I am planning to skip from Postgres 8.1.x to 8.3.x

[GENERAL] Upgrading Postgres version

2008-11-10 Thread Tony Fernandez
Hello all, I am in the process of updating my DB on Postgres 8.1.11 to 8.3.4. I also use Slony 1.2.14 for replication. Is there a safe path on how to accomplish this, please advice on what steps I will need to consider. Bear in mind that I am planning to skip from Postgres 8.1.x to 8.3.x

[GENERAL] Upgrading Postgres large databases with blobs

2007-03-10 Thread CAJ CAJ
Hello, For some reason, my first attempt to send this email to the list didn't get through We have several independent database servers with ~50GB+ databases running postgres 8.0.x. We are planning to upgrade these databases to postgres 8.2.xover the weekend We plan to use the following st

Re: [GENERAL] upgrading postgres from 7.0 to 7.1

2001-07-17 Thread Chad R. Larson
On Mon, Jul 02, 2001 at 11:52:47PM -0700, Pieter Vissenberg wrote: > The postmaster seems to be running smoothly (psql session works > fine). However when I try to connect to the database via Apache > with PHP, I get an errormessage in the style of 'pconnect() > failed. Is the postmaster (with -

[GENERAL] upgrading postgres from 7.0 to 7.1

2001-07-10 Thread Pieter Vissenberg
Dear all, I upgraded my PostgreSQL installation using Redhat's RPM. I believe the start up script in /etc/rc.d/init.d has not been changed. The postmaster seems to be running smoothly (psql session works fine). However when I try to connect to the database via Apache with PHP, I get an errormessa

[GENERAL] upgrading postgres

2000-08-31 Thread Robert Kernell
Where can I find step-by-step instructions for upgrading postgres? Bob Kernell Research Scientist AS&M email: [EMAIL PROTECTED]