Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Phoenix Kiula
On 8/26/08, Scott Marlowe [EMAIL PROTECTED] wrote: Slony replication lets postgresql accomplish this, which is really quite impressive. We just upgraded from an 8.1 server to an 8.3 server via slony, and it went smooth as silk. db downtime was measured in seconds. Thanks for this

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Phoenix Kiula
On 8/26/08, Phoenix Kiula [EMAIL PROTECTED] wrote: On 8/26/08, Scott Marlowe [EMAIL PROTECTED] wrote: Slony replication lets postgresql accomplish this, which is really quite impressive. We just upgraded from an 8.1 server to an 8.3 server via slony, and it went smooth as silk.

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Magnus Hagander
Phoenix Kiula wrote: On 8/26/08, Phoenix Kiula [EMAIL PROTECTED] wrote: On 8/26/08, Scott Marlowe [EMAIL PROTECTED] wrote: Slony replication lets postgresql accomplish this, which is really quite impressive. We just upgraded from an 8.1 server to an 8.3 server via slony, and it

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Phoenix Kiula
You need to download Slony 1.2.14, which supports both 8.2 and 8.3. You'll find it under Quick downloads. Ok done. Slony is installed. Now what? How should I install a new database which is 8.3.3? I was also told that the postgresql.conf settings across 8.2 and 8.3 are different so I

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Tomasz Ostrowski
On 2008-08-26 13:39, Phoenix Kiula wrote: Ok done. Slony is installed. Now what? http://www.slony.info/documentation/versionupgrade.html I think nobody would guide you step by step. Either read documentation and do it yourself or hire an expert:

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Phoenix Kiula
On 8/26/08, Tomasz Ostrowski [EMAIL PROTECTED] wrote: I think nobody would guide you step by step. Either read documentation and do it yourself or hire an expert: Thanks. I suppose that spirit is quite evident in the documentation. Why make it easy or easily understandable when you can win

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Richard Broersma
On Tue, Aug 26, 2008 at 5:02 AM, Tomasz Ostrowski [EMAIL PROTECTED] wrote: http://www.slony.info/documentation/versionupgrade.html I think nobody would guide you step by step. Well they may, then is nothing wrong with asking especially when breaking new ground. Since my databases are

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Andrew Sullivan
On Mon, Aug 25, 2008 at 08:36:34PM -0600, Scott Marlowe wrote: Slony replication lets postgresql accomplish this, which is really quite impressive. Pleased as I am to hear accounts of Slony being used successfully to solve the upgrade problem -- it was one of our design goals in the early

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Richard Broersma
On Tue, Aug 26, 2008 at 5:31 AM, Phoenix Kiula [EMAIL PROTECTED] wrote: I suppose that spirit is quite evident in the documentation. All kidding aside, the problem that you are having IS recognized as a weakness with PostgreSQL. This is why some are already working on solving the problem of in

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Scott Marlowe
On Tue, Aug 26, 2008 at 5:39 AM, Phoenix Kiula [EMAIL PROTECTED] wrote: You need to download Slony 1.2.14, which supports both 8.2 and 8.3. You'll find it under Quick downloads. Ok done. Slony is installed. Now what? How should I install a new database which is 8.3.3? Which OS are you

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Scott Marlowe
On Tue, Aug 26, 2008 at 6:31 AM, Phoenix Kiula [EMAIL PROTECTED] wrote: On 8/26/08, Tomasz Ostrowski [EMAIL PROTECTED] wrote: I think nobody would guide you step by step. Either read documentation and do it yourself or hire an expert: Thanks. I suppose that spirit is quite evident in the

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Chris Browne
[EMAIL PROTECTED] (Phoenix Kiula) writes: See, this is where I get confused. I want to upgrade from 8.2.3 to 8.3.3. The recommendation is to try Slony. So I download Slony and try to configure it. The configure command gives me this: checking for correct version of PostgreSQL... error

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Scott Marlowe
On Tue, Aug 26, 2008 at 12:10 AM, Phoenix Kiula [EMAIL PROTECTED] wrote: On 8/26/08, Scott Marlowe [EMAIL PROTECTED] wrote: Slony replication lets postgresql accomplish this, which is really quite impressive. We just upgraded from an 8.1 server to an 8.3 server via slony, and it went

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Chris Browne
[EMAIL PROTECTED] (Phoenix Kiula) writes: On 8/26/08, Tomasz Ostrowski [EMAIL PROTECTED] wrote: I think nobody would guide you step by step. Either read documentation and do it yourself or hire an expert: Thanks. I suppose that spirit is quite evident in the documentation. Why make it

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-26 Thread Robert Gobeille
On Aug 26, 2008, at 10:22 AM, Scott Marlowe wrote: On Tue, Aug 26, 2008 at 12:10 AM, Phoenix Kiula [EMAIL PROTECTED] wrote: On 8/26/08, Scott Marlowe [EMAIL PROTECTED] wrote: Slony replication lets postgresql accomplish this, which is really quite impressive. We just upgraded from an 8.1

[GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-25 Thread Phoenix Kiula
Hi. I have googled and googled for good, simple instructions to upgrade from 8.2.3 to 8.3.3 (latest stable at this time?) I am on a Cpanel interface. Use Apache and PHP for most of my websites. This seems to be the most often quoted resource on forums etc:

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-25 Thread Tino Wildenhain
Hi, Phoenix Kiula wrote: Hi. I have googled and googled for good, simple instructions to upgrade from 8.2.3 to 8.3.3 (latest stable at this time?) I am on a Cpanel interface. Use Apache and PHP for most of my websites. This seems to be the most often quoted resource on forums etc:

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-25 Thread RW
Normally we don't use the packages from the distributions. They're mostly outdated and installation ov two or more versions of Postgres isn't that easy normally in this case. We've a directory structure which allows us to install and startup two or more versions in parallel. I haven't tried

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-25 Thread Andrew Sullivan
On Mon, Aug 25, 2008 at 11:34:00AM +0200, Tino Wildenhain wrote: (e.g. pg_dump | pg_restore to avoid wasting space 2 times) then run slony to permanently update the last bits If you're going to run slony, then the pg_dump|pg_restore step is completely wasted. Slony will restore all the data

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-25 Thread Tino Wildenhain
Andrew Sullivan wrote: On Mon, Aug 25, 2008 at 11:34:00AM +0200, Tino Wildenhain wrote: (e.g. pg_dump | pg_restore to avoid wasting space 2 times) then run slony to permanently update the last bits If you're going to run slony, then the pg_dump|pg_restore step is completely wasted. Slony

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-25 Thread Phoenix Kiula
If you're going to run slony, then the pg_dump|pg_restore step is completely wasted. Slony will restore all the data again. You do need to run pg_dump -s, of course. Thanks to everyone who replied. We have no experience with this Slony. Any simple instructions on installing it and

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-25 Thread Joshua Drake
On Tue, 26 Aug 2008 09:25:09 +0800 Phoenix Kiula [EMAIL PROTECTED] wrote: Slony. Any simple instructions on installing it and getting it working? Why is PG so complex! It's a such a lovely database. If only at least the installation and upgrade could be made more humane.. Well the

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

2008-08-25 Thread Scott Marlowe
On Mon, Aug 25, 2008 at 7:25 PM, Phoenix Kiula [EMAIL PROTECTED] wrote: If you're going to run slony, then the pg_dump|pg_restore step is completely wasted. Slony will restore all the data again. You do need to run pg_dump -s, of course. Thanks to everyone who replied. We have no