Search Postgresql Archives

Re: Upgrading Postgres question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Nov 5, 2008 at 2:19 PM, Tony Fernandez
<Tony.Fernandez@xxxxxxxxxxxxxx> 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 your backup slaves offline, upgrade it to 8.3,
recreate it as a slony slave, and let it run for a few days.  When all
seems well, swap the two servers.  downtime measured in seconds.

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux