Re: Who is Slony Master/Slave + general questions.
От | Stéphane Schildknecht |
---|---|
Тема | Re: Who is Slony Master/Slave + general questions. |
Дата | |
Msg-id | 45B0B6DB.50007@postgresqlfr.org обсуждение исходный текст |
Ответ на | Who is Slony Master/Slave + general questions. (sjarosz@gmail.com) |
Ответы |
Re: Who is Slony Master/Slave + general questions.
|
Список | pgsql-general |
Hello, You should ask directly to the slony1 mailing list. sjarosz@gmail.com 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
В списке pgsql-general по дате отправления: