pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Questions
3+ messages / 3 participants
[nested] [flat]

* Questions
@ 2018-09-12 09:51 Pierre Ochsenbein <pierreochsenbein@gmail.com>
  2018-09-12 10:13 ` Re: Questions Shreeyansh Dba <shreeyansh2014@gmail.com>
  2018-09-12 12:47 ` Re: Questions Laurenz Albe <laurenz.albe@cybertec.at>
  0 siblings, 2 replies; 3+ messages in thread

From: Pierre Ochsenbein @ 2018-09-12 09:51 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

Hi,

For it to be sure but I think the answer is Yes:
It’s possible to implement PostgreSQL HA Database with extension PostGIS?

Which best tool I can use for the load balancing and auto Failover for the HA? Pgpool? Repmgr?

Thanks a lot



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Questions
  2018-09-12 09:51 Questions Pierre Ochsenbein <pierreochsenbein@gmail.com>
@ 2018-09-12 10:13 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Shreeyansh Dba @ 2018-09-12 10:13 UTC (permalink / raw)
  To: Pierre Ochsenbein <pierreochsenbein@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org

Hi Pierre,

You can use pgpool  for the load balancing and auto Failover.


<http://www.shreeyansh.com;


On Wed, Sep 12, 2018 at 3:22 PM Pierre Ochsenbein <
pierreochsenbein@gmail.com> wrote:

> Hi,
>
> For it to be sure but I think the answer is Yes:
> It’s possible to implement PostgreSQL HA Database with extension PostGIS?
>
> Which best tool I can use for the load balancing and auto Failover for the
> HA? Pgpool? Repmgr?
>
> Thanks a lot
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Questions
  2018-09-12 09:51 Questions Pierre Ochsenbein <pierreochsenbein@gmail.com>
@ 2018-09-12 12:47 ` Laurenz Albe <laurenz.albe@cybertec.at>
  1 sibling, 0 replies; 3+ messages in thread

From: Laurenz Albe @ 2018-09-12 12:47 UTC (permalink / raw)
  To: Pierre Ochsenbein <pierreochsenbein@gmail.com>; pgsql-admin@lists.postgresql.org

Pierre Ochsenbein wrote:
> For it to be sure but I think the answer is Yes:
> It’s possible to implement PostgreSQL HA Database with extension PostGIS?
> 
> Which best tool I can use for the load balancing and auto Failover for the HA? Pgpool? Repmgr?

Yes, and Patroni, though opinions on the second will certainly differ.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com





^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2018-09-12 12:47 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-09-12 09:51 Questions Pierre Ochsenbein <pierreochsenbein@gmail.com>
2018-09-12 10:13 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2018-09-12 12:47 ` Laurenz Albe <laurenz.albe@cybertec.at>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox