Skip site navigation (1) Skip section navigation (2)

Slony and local machine slave..(supernewbie question)

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Slony and local machine slave..(supernewbie question)
Date: 2009-07-30 11:47:15
Message-ID: e373d31e0907300447s3d8ea1f0xf046007e53896195@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
I use a Mac OSX at work. And finally have a running PG install.

So I'm thinking: can I use some mechanism to have my local PG server
(in our premises) as a slave mirror of the main live website server
(at our data center).

Would Slony be the solution to look at? Is this a dumb thought to
begin with or can this be done with no to minimal loss of the live DB,
by just using some small part of the sys resources on the live server
to keep sending some updates back to our local server.

Locally, we can then use the server for testing against almost the
real DB (including testing future versions of PG), then when we need
to upgrade on the server, use this as a master and live one as a
slave, etc? Also serves as a nice backup.

Or am I dreaming?

The reason I feel this may be possible, presuming Slony allows
something like this, is that I have 24/7 broadband connectivity at
about 100 mbps. And I hardly ever shutdown my OSX, just shut down the
monitor or let the system "sleep".

Thanks for any thoughts.

Responses

pgsql-general by date

Next:From: Sachin SrivastavaDate: 2009-07-30 11:55:30
Subject: Re: How do I run PG Tuning Wizard on Linux?
Previous:From: Csaba NagyDate: 2009-07-30 11:46:34
Subject: Re: Clients disconnect but query still runs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group