[Pgpool-hackers] Enhancing show pool_nodes
Jehan-Guillaume (ioguix) de Rorthais
jgdr at dalibo.com
Fri Oct 7 08:04:31 UTC 2011
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 06/10/2011 03:10, Tatsuo Ishii wrote:
> Currently show pool_nodes SQL command shows:
>
> id | hostname | port | status | lb_weight
>
> I would like to add info whether the node is primary, master or
> standby because there's no way to know from exisiting pgpool-II UI.
> The new column name would be "class" (plese say no, if you have better
> idea about naming).
"situation" ? "level" ?
> The value will as follows:
>
> Raw mode:
> "master" or ""
>
> Native replication mode:
> "master" or "slave"
>
> Streaming replication mode:
> "primary" or "standby"
>
> Master slave mode with slony:
> "master" or "slave"
I share the same coment thant Guillaume Lelarge about the names.
> Comments or opinions?
Don't forget the pgpool_adm extension when patching (pcp_node_info). I
guess it shouldn't break it as you will probably add this filed in the
BackendInfo structure, but make sure to ping me so I can update the
function as soon as your patch is commited.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
- --
Jehan-Guillaume (ioguix) de Rorthais
http://www.dalibo.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAk6Oso4ACgkQXu9L1HbaT6LUigCfWsE+/9KNVmMYT4ilbFAjNjSs
ZDkAoK2xB11bxPaUsQjZHwZof6TYZpjJ
=S+1s
-----END PGP SIGNATURE-----
More information about the Pgpool-hackers
mailing list