Re: [GENERAL] Who is Slony Master/Slave + general questions.

2007-01-24 Thread Bernd Helmle
On Sat, 20 Jan 2007 11:07:57 +0500, "Shoaib Mir" <[EMAIL PROTECTED]> wrote: > I dont have the replication setup on my machine right now but I guess as > far > as I remember you can surely check for the master and slave nodes from a > Slony schema table. > I think the notion of "master and slave

Re: [GENERAL] Who is Slony Master/Slave + general questions.

2007-01-22 Thread Shoaib Mir
I dont have the replication setup on my machine right now but I guess as far as I remember you can surely check for the master and slave nodes from a Slony schema table. Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 19 Jan 2007 08:25:23 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED

Re: [GENERAL] Who is Slony Master/Slave + general questions.

2007-01-21 Thread Chris Browne
[EMAIL PROTECTED] writes: > Take a scenario: you configure 2 servers as master and slave. You walk > for a period of time during which a number failovers occur. You come > back. Can I query a sl_ table to determine which server is the > current master and which one is the current slave? In

Re: [GENERAL] Who is Slony Master/Slave + general questions.

2007-01-19 Thread sjarosz
I am using LinuxHA to manage the failover and Slony as part of to failover to move to the healthy node. But my question was more along the lines, if a user has access to both databases (master and slave) but does not know which one is which, how can you tell? Take a scenario: you configure 2 serv

Re: [GENERAL] Who is Slony Master/Slave + general questions.

2007-01-19 Thread Shoaib Mir
As written in documentation "Slony-I does not provide any automatic detection for failed systems. " First of all, you may want to upgrade to the latest stable slony1 version. But if you have a combination of Slony + Linux HA you can make use of Slony failover to do an automatic failover when the

Re: [GENERAL] Who is Slony Master/Slave + general questions.

2007-01-19 Thread Stéphane Schildknecht
Hello, You should ask directly to the slony1 mailing list. [EMAIL PROTECTED] a écrit : > (...) The Slony version I'm using is 1.1.2. The current version of Slony1 is slony1-1.2.6. > Take a scenario that > you want to check the state of the system without prior knowledge of > the node setup, how w

[GENERAL] Who is Slony Master/Slave + general questions.

2007-01-18 Thread sjarosz
Hello, I'm starting to use slony as a redundancy solution for the project I'm currently working on. Running SuSE Linux 9 where one machine contains the prime database and the second machine contains the backup database. The Slony version I'm using is 1.1.2. If some of the issues have been add