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/>
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 |