Re: Replication mode - Mailing list pgsql-admin

From Ramesh naik
Subject Re: Replication mode
Date
Msg-id CAH=dj08jOcMt+UuGOtSya4uBtaCM+65Oyj4mu12bNp=Tx0Vr7A@mail.gmail.com
Whole thread Raw
In response to Re: Replication mode  (Azimuddin Mohammed <azimeiu@gmail.com>)
Responses Re: Replication mode
List pgsql-admin
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..


On Thu, 11 Jan 2018 at 9:11 AM, Azimuddin Mohammed <azimeiu@gmail.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.kirkwood@catalyst.net.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


pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Replication mode
Next
From: Jerry Sievers
Date:
Subject: pg_receivexlog only captures WAL data, not *.backup?