[pgpool-general: 2975] Re: Force connection by node number

[Tatsuo Ishii]

What would happen if the target node was down and pgpol-II has already
disconnected the node?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Hey,
> 
> I would want to use this in a situation where a third party clustering
> solution is being used. By doing health checks through Pgpool a better
> level of monitoring could be achieved.
> 
> Cheers,
> James
> 
> On Wednesday, 25 June 2014, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> Asuming you are going to use streaming replication mode.
>>
>> You could use /*NO LOAD BALANCE*/ comment to force particular query to
>> primary node.  However there's no way to force a query route to
>> standby node except that you set load balance weight of the primary to
>> 0.
>>
>> BTW, why do you want to send queries via pgpool? It seems you can
>> achieve your goal by connecting directly to pgpool.
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>> > Looking into this more, ideally this would take the form of an extra port
>> > per Postgres node for non load balanced access.
>> >
>> > I think this is probably a feature request! Anyone have any comments on
>> the
>> > idea?
>> >
>> > Cheers
>> > James Sewell
>> >
>> > On Wednesday, 25 June 2014, James Sewell <james.sewell at lisasoft.com
>> <javascript:;>> wrote:
>> >
>> >> Hey All,
>> >>
>> >> Is it possible to force a connection to a specific server somehow with
>> >> pgpool? For example run a SQL statement on node 0, then run it on node
>> 1.
>> >>
>> >> I would like to do this so I can do real world SQL testing of each
>> server
>> >> through pgpool.
>> >>
>> >> Cheers,
>> >>
>> >> James Sewell,
>> >> PostgreSQL Team Lead / Solutions Architect
>> >> ______________________________________
>> >>
>> >>
>> >>  Level 2, 50 Queen St, Melbourne VIC 3000
>> >>
>> >> *P *(+61) 3 8370 8000  *W* www.lisasoft.com  *F *(+61) 3 8370 8099
>> >>
>> >>
>> >
>> >
>> > --
>> >
>> > James Sewell,
>> > PostgreSQL Team Lead / Solutions Architect
>> > ______________________________________
>> >
>> >
>> >  Level 2, 50 Queen St, Melbourne VIC 3000
>> >
>> > *P *(+61) 3 8370 8000  *W* www.lisasoft.com  *F *(+61) 3 8370 8099
>> >
>> > --
>> >
>> >
>> > ------------------------------
>> > The contents of this email are confidential and may be subject to legal
>> or
>> > professional privilege and copyright. No representation is made that this
>> > email is free of viruses or other defects. If you have received this
>> > communication in error, you may not copy or distribute any part of it or
>> > otherwise disclose its contents to anyone. Please advise the sender of
>> your
>> > incorrect receipt of this correspondence.
>>
> 
> 
> -- 
> 
> James Sewell,
> PostgreSQL Team Lead / Solutions Architect
> ______________________________________
> 
> 
>  Level 2, 50 Queen St, Melbourne VIC 3000
> 
> *P *(+61) 3 8370 8000  *W* www.lisasoft.com  *F *(+61) 3 8370 8099
> 
> -- 
> 
> 
> ------------------------------
> The contents of this email are confidential and may be subject to legal or 
> professional privilege and copyright. No representation is made that this 
> email is free of viruses or other defects. If you have received this 
> communication in error, you may not copy or distribute any part of it or 
> otherwise disclose its contents to anyone. Please advise the sender of your 
> incorrect receipt of this correspondence.