Re: Replication mode

Hi Azim,

Pgpool is not of SPOF. You can use watchdog feature in PgPool-II to achieve
HA.
I’ve used it before. I didn’t find any difficulties in configuring or
managing

FYI..
http://www.pgpool.net/docs/latest/en/html/runtime-watchdog-config.html

On Thu, 11 Jan 2018 at 9:11 AM, Azimuddin Mohammed <azimeiu(at)gmail(dot)com>
wrote:

> :-)
> Our fear is using open source tools for HA creates dependency and single
> point of failure(pgpool). Or say pacemaker which our enterprise do not
> recommend.
> We are planning to use postgres to use for our hadoop metastore which is
> presently on Oracle.
>
>
> On Jan 10, 2018 6:21 PM, "Mark Kirkwood" <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
> wrote:
>
>> On 11/01/18 13:08, Azimuddin Mohammed wrote:
>>
>> Thanks mark..
>>> That does help...
>>> Our db is not transactional ..it more of write few times read many times
>>> ..What HA do you recommend for us by not using any open source
>>> tools...and what could be the best backup startegy...
>>>
>>>
>> Wow - that 'not using any open source tools' restriction pretty much
>> rules out any options I'd come up with (was that *really* what you meant to
>> write - Postgres is after all open source too...)?
>>
>> regards
>>
>> Mark
>>
> --
Regards,
Ramesh Naik E

+65 8202 7519