i read about the replication possibilities with postgresql. If i just need
some replication ( without failover stuff ) to 1 standby server, what
would be the best option to go with. Slony i presume, although schema
chanages are not propagated.
thanks
jef peeraer
--
Sent via pgsql-general
On 05/08/2008 08:21, Jef Peeraer wrote:
would be the best option to go with. Slony i presume, although schema
chanages are not propagated.
Schema changes *are* propagated in Slony, using the EXECUTE SCRIPT
statement:
http://www.slony.info/documentation/stmtddlscript.html
Ray.
In response to Jef Peeraer [EMAIL PROTECTED]:
i read about the replication possibilities with postgresql. If i just need
some replication ( without failover stuff ) to 1 standby server, what
would be the best option to go with.
Your description of you requirements is very lacking, so much
On Tue, 5 Aug 2008, Bill Moran wrote:
In response to Jef Peeraer [EMAIL PROTECTED]:
i read about the replication possibilities with postgresql. If i just need
some replication ( without failover stuff ) to 1 standby server, what
would be the best option to go with.
Your
In response to Jef Peeraer [EMAIL PROTECTED]:
On Tue, 5 Aug 2008, Bill Moran wrote:
In response to Jef Peeraer [EMAIL PROTECTED]:
i read about the replication possibilities with postgresql. If i just
need
some replication ( without failover stuff ) to 1 standby server, what
On Tue, August 5, 2008 9:21 am, Jef Peeraer wrote:
i read about the replication possibilities with postgresql. If i just need
some replication ( without failover stuff ) to 1 standby server, what
would be the best option to go with. Slony i presume, although schema
chanages are not
On Tue, Aug 5, 2008 at 7:34 AM, Bill Moran
[EMAIL PROTECTED] wrote:
In response to Jef Peeraer [EMAIL PROTECTED]:
You'd probably be best with Slony, just don't replicate that 1 table
that you'll need to write to.
That's one of my favorite things about slony.
--
Sent via pgsql-general
On Tue, Aug 05, 2008 at 06:03:19AM +0200, Henry wrote:
just much simpler to use -- not as flexible and as powerful as Slony, but
if all you need to do is replicate some tables with minimum fuss and
without having to learn a new language, then Skytools (based on my
personal experience with a