Hot Standby vs slony

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Hot Standby vs slony
Date: 2018-02-08 21:09:21
Message-ID: CADyzmyzohWhskaR4k47xzaBF1AEULYSAdi3EnkNPvA8p0DPy=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good afternoon,

We currently run postgres 9.4 We currently run the following:

----------------------------------------------|
---------------- |--> slony (reporting, hi-availabilty) |
production | ----->| ---------------------------------------------
|
---------------- |
|--------------------------------------|
|-> hot standby (dr) |
---------------------------------------|

We would like to replace slony with another instance of hot standby as
follows:

----------------------------------------------|
---------------- |--> hot standby1 (reporting, ha) |
production | ----->| --------------------------------------------|
|
---------------- |
|--------------------------------------|
|-> hot standby2 (dr) |
---------------------------------------|

Is this possible? I see in the documentation it is possible for warm
standby but don't
see a confirmation in the section on hot standby.

Thank you,

--

*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

--
<https://www.drivedominion.com/transform-your-vue/>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message bricklen 2018-02-08 22:29:52 Re: Hot Standby vs slony
Previous Message Stephen Frost 2018-02-08 20:03:57 Re: incomplete startup packet