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.  ("Shoaib Mir" <shoaibmir@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: [HACKERS] Autovacuum Improvements
Следующее
От: "Shoaib Mir"
Дата:
Сообщение: Re: Who is Slony Master/Slave + general questions.