Synchronous replication: status of standby side
Hi,
will there be a possibility to retrieve the standby situation in case of
synchronous replication ?
We would need a command or similar to report the current state and state
changes
(like: syncing, in-sync, replication broken, ..).
Observing and scaning the logfile would not be appropriate.
Are there plans for such an interface ?
Best regards
Harald Kolb
Kolb, Harald (NSN - DE/Munich) wrote:
Hi,
will there be a possibility to retrieve the standby situation in case of
synchronous replication ?
We would need a command or similar to report the current state and state
changes
(like: syncing, in-sync, replication broken, ..).
Observing and scaning the logfile would not be appropriate.
Are there plans for such an interface ?
Not sure; we have not written all the synchonous replication code yet.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Hi,
On Thu, Jun 4, 2009 at 12:28 AM, Kolb, Harald (NSN - DE/Munich)
<harald.kolb@nsn.com> wrote:
Hi,
will there be a possibility to retrieve the standby situation in case of
synchronous replication ?
We would need a command or similar to report the current state and state
changes
(like: syncing, in-sync, replication broken, ..).
Observing and scaning the logfile would not be appropriate.
Are there plans for such an interface ?
No, not yet. You think that this feature is a high-priority TODO item?
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
Hi,
-----Original Message-----
From: ext Fujii Masao [mailto:masao.fujii@gmail.com]
Sent: Thursday, June 04, 2009 6:25 AM
To: Kolb, Harald (NSN - DE/Munich)
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Synchronous replication: status of standby sideHi,
On Thu, Jun 4, 2009 at 12:28 AM, Kolb, Harald (NSN - DE/Munich)
<harald.kolb@nsn.com> wrote:Hi,
will there be a possibility to retrieve the standby
situation in case of
synchronous replication ?
We would need a command or similar to report the currentstate and state
changes
(like: syncing, in-sync, replication broken, ..).
Observing and scaning the logfile would not be appropriate.
Are there plans for such an interface ?No, not yet. You think that this feature is a high-priority TODO item?
We are planning to use the HotStandby feature too.
That would require to have the correct state information since we have
to
control the DB clients when and how they can connect or reconnect.
But also in general, from our platform POV it's an important feature to
have the right view on the system at any point of time (e.g. in case of
update avoid switchover if standby is out of sync, ...).
In addition, can we expect that a replication break will be logged as an
important event ?
Regards, Harald.
Where can I find a more recent version of syncrep patch. The last one
that I've here is synch_rep_0428 and I'm getting segfault with it ":(.
In Wiki [1]http://wiki.postgresql.org/wiki/NTT%27s_Development_Projects the last is syncrep_0305
[1]: http://wiki.postgresql.org/wiki/NTT%27s_Development_Projects
[]s
--
Dickson S. Guedes
mail/xmpp: guedes@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
http://www.rnp.br/keyserver/pks/lookup?search=0x8F3E3C06D428D10A
Hi,
2009/6/5 Dickson S. Guedes <listas@guedesoft.net>:
Where can I find a more recent version of syncrep patch. The last one
that I've here is synch_rep_0428 and I'm getting segfault with it ":(.
In Wiki [1] the last is syncrep_0305[1] http://wiki.postgresql.org/wiki/NTT%27s_Development_Projects
Attached is the latest version (but WIP) of synch rep patch. And,
I uploaded it into wiki. You can set up synch rep according to
the following page.
http://wiki.postgresql.org/wiki/NTT%27s_Development_Projects#How_to_set_up_Synch_Rep
Please feel free to try it!
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
Attachments:
synch_rep_0605.tgzapplication/x-gzip; name=synch_rep_0605.tgzDownload
� s(J �\{s�8����O�I�&�M�z�����me�+��I�:[uU*��$�)�!H������� _;�d'[���� @?��"]s9
�?�������S�O��R��f�[^�j�Z���5��Z�Z��`��2��O$C0���d����������������\��c���rO��iu:����;-x���`}O~������sV�+��:��y4���p����N�mG0W�_�tpp���^�Z����r�����z����$���j��r����&�.W[�V=��N�-�M�~l4Z�n�����{����J�����������7�oB���"��,;����^9��_��T���~f���`~��-����q&=��w/��y���pp>>e��7����cq�v�3���"({@��(�N��\/{7S�������^��R0�4fyB��C`�����c����<|-a~4�����B���� S�v\
����~er�\3
��p�.�i�0����#��q���O_/�'
?�8>c��4��G�,��/ K��[���]���h\�������n�V5��n�����CQ�]K<��}����zp���wt ��P�H��k��`�� � m�E����9��<0��=
��L�|�c��KM�Fp��q����Up8vp�m��f�ZN#)�k��?�E/��3C�^���/����K)� ��-�p�0)���t%B�����X~0|,��q<f|��'�~��?���~��CV;Uf�y�
�{�R�0�`��^�� LqlSw���_���LXc�6�0����#���\��>k������k��8iuO�/1�Bj_n��N�hwRC
,��,��A������m���i��!���0�����@Ku��������bx��tpi0���>\]�&}��BT�OQ;��['���"���TB-F���-����A4���G�al���*4=�[�s�x� �g�y��u���*��Y�{�:.R�g(�gh�j6�D-_��?��6���A��d�����wo[�i�<��8D ��h��gHp��>"�{�
������Kc�j��KQI�����_����e���h�t<�� � 3��GA�-�Bn��0�����0���}D|�GN2/M�]X�E�B����8���C�T��5�kJI��p�m�,7��'�%��a9���p .jp}�nz���h����H4��R��.��=NW���s�M�Sd���$��_����@�[�n�0]�^�J���Zh
�R��"