Search Postgresql Archives

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

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

 



Hello,

You should ask directly to the slony1 mailing list.

sjarosz@xxxxxxxxx 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 would you determine which machine is the prime and
> which one is the slave?
>   
Without any knowledge of replication ? That will be difficult. You
should connect to one of the DB and have a look at slony schema tables
(sl_status and sl_listen for instance)...

You may also have a look at that page :
http://linuxfinances.info/info/monitoring.html

> Also I'm having issues with the slonik script (below) that is supposed
> to handle the failover to the slave in case of master failure.  For
> some reason it hangs and I was wondering if there are known issues with
> it.  
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.


Cheers,

SAS


[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