[pgpool-general: 5213] Re: forcing select to go to master with /*nobalance*/

[Avi Weinberg]

Hi all,

Thanks for the reply.

Can we make it configurable and have a key in pgpool.cof to indicate which string in the comment indicates that it should go to master.  If the key is empty it will mean all comments.  This way we can be backward compatible, but can still use it with Hibernate.  Can it be added?

Thanks
Avi

-----Original Message-----
From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp]
Sent: Wednesday, January 04, 2017 4:55 AM
To: Avi Weinberg <AviW at gilat.com>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 5209] forcing select to go to master with /*nobalance*/

> Hi all,
>
> I'm using hibernate and wanted to use /*nobalance*/ to force some
> selects to go to master.  However, when I enabled hibernate to pass
> comments to the database it added its own comments to each and every
> query.  As a result all my selects go to master.  It seems like pgpool
> does not care what the comment is as long as there is a comment it
> sends it to master.

Yes, currently Pgpool-II does not care about the actual contents of the comment.

> How can I tell pgpool to send it to the master only if the comment is
> /*nobalance*/

Sorry there's no way to do that.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.