Thread: High Availability

High Availability

From
dangal
Date:
Dear , I have a question for them , in our work we have an environment with
streaming replication and everything works in the best way , we are trying
to implement high availability and for that we try to use pgpool and we
could not get it to work with md5 authentication
The area of systems my company consulted us that we viability of using DRBD
The truth is that looking at your site only see old references to that
product , without being pgpool recommending us to make high availability?
Thank you very much



--
View this message in context: http://postgresql.nabble.com/High-Availability-tp5912759.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


Re: High Availability

From
Adrian Klaver
Date:
On 07/20/2016 11:53 AM, dangal wrote:
>
> Dear , I have a question for them , in our work we have an environment with
> streaming replication and everything works in the best way , we are trying
> to implement high availability and for that we try to use pgpool and we
> could not get it to work with md5 authentication

The errors/problems where?

> The area of systems my company consulted us that we viability of using DRBD
> The truth is that looking at your site only see old references to that
> product , without being pgpool recommending us to make high availability?

With out more information this is throwing darts at a board, so:

What version(s) of Postgres?

What version(s) of pgpool?

What is your setup, number of masters/slaves and layout?

What is your definition of high availability?



> Thank you very much
>
>
>
> --
> View this message in context: http://postgresql.nabble.com/High-Availability-tp5912759.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


Re: High Availability

From
Tatsuo Ishii
Date:
> On 07/20/2016 11:53 AM, dangal wrote:
>>
>> Dear , I have a question for them , in our work we have an environment
>> with
>> streaming replication and everything works in the best way , we are
>> trying
>> to implement high availability and for that we try to use pgpool and
>> we
>> could not get it to work with md5 authentication
>
> The errors/problems where?
>
>> The area of systems my company consulted us that we viability of using
>> DRBD
>> The truth is that looking at your site only see old references to that
>> product , without being pgpool recommending us to make high
>> availability?
>
> With out more information this is throwing darts at a board, so:
>
> What version(s) of Postgres?
>
> What version(s) of pgpool?
>
> What is your setup, number of masters/slaves and layout?
>
> What is your definition of high availability?

Also the original poster might want to take a look at FAQ:

http://pgpool.net/mediawiki/index.php/FAQ

Especially this:


http://pgpool.net/mediawiki/index.php/FAQ#I_created_pool_hba.conf_and_pool_passwd_to_enable_md5_authentication_through_pgpool-II_but_it_does_not_work._Why.3F

and this:

http://pgpool.net/mediawiki/index.php/FAQ#md5_authentication_does_not_work._Please_help

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