Обсуждение: High Availability

Поиск
Список
Период
Сортировка

High Availability

От
dangal
Дата:
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

От
Adrian Klaver
Дата:
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

От
Tatsuo Ishii
Дата:
> 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