Re: hot standby cascading replication

From: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
To: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: hot standby cascading replication
Date: 2018-11-06 07:28:49
Message-ID: CAGDYbUPkoZ9m9BhWnnWOvyzd5xbkc+uU0K3DGkFpOwCD6tvGAA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Mark,

Go through this link. hope this will help you.

https://www.howtoforge.com/tutorial/postgresql-replication-on-ubuntu-15-04/

<http://www.shreeyansh.com>

On Mon, Oct 29, 2018 at 9:54 PM Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
wrote:

> Good morning,
> I am attempting to set up cascading replication on a hot standby setup.
> We are running postgres 9.4 on all servers. I can ship logs from the
> master to the first standby but cannot get logs to ship from the first
> standby to the second standby. I see the cascading replication in the
> streaming replication documentation. Do I need to set up streaming
> replication in order for this to work? I have sent my postgresql.conf file
> for the first standby as reference as well as the copy statement.
>
> 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-vision/>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2018-11-06 08:37:37 Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint
Previous Message Nikhil Shetty 2018-11-06 04:41:42 Re: hot standby cascading replication