Re: Postgres replication

On Fri, Apr 14, 2017 at 10:20 AM, Gone, Sajan <SGone(at)lb(dot)com> wrote:

> Hi Samed,
>
> Thanks for sending out the weblink. I was able to successfully set the
> replication up (Master/Slave, Hot stand by).
>
> I really appreciate your help on this.
>
> My background is mostly on MySQL so my next question would be on how to
> look at the replication status. Like MySQL “Show slave status \G” command
> is there any command on postgres to look at the slave current status(or
> replication status).
>
> Thank You,
> Sajan Gone.
>

I discuss several of the most common here

https://www.keithf4.com/monitoring_streaming_slave_lag/

> From: Samed YILDIRIM <samed(at)reddoc(dot)net>
> Date: Thursday, April 13, 2017 at 4:27 PM
> To: Sajan Gone <sgone(at)lb(dot)com>, "pgsql-admin(at)postgresql(dot)org" <
> pgsql-admin(at)postgresql(dot)org>
> Subject: Re: [ADMIN] Postgres replication
>
> Hi Sajan,
>
> You can take a look following document. It is good for a start point.
>
> https://www.digitalocean.com/community/tutorials/how-to-
> set-up-master-slave-replication-on-postgresql-on-an-ubuntu-12-04-vps
>
> Best regards.
>
> 22:25, 13 Nisan 2017, "Gone, Sajan" <sgone(at)lb(dot)com>:
>
>
>
>
>
>
> Hello,
>
>
> Good afternoon everyone.
>
>
>
>
> This is Sajan Gone, I am trying to setup a Standard Master/Salve
> replication between two postgres instances. I am pretty much new to
> postgres and not exactly sure how replication works and what is an
> architecture behind
> it. As of now I am following the standard postgres documentation @
> https://www.postgresql.org/docs/current/static/warm-
> standby.html#PREPARING-MASTER-FOR-STANDBY
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.postgresql.org_docs_current_static_warm-2Dstandby.html-23PREPARING-2DMASTER-2DFOR-2DSTANDBY&d=DwMGaQ&c=spYp1tZ3AQD6dfuI6rqaeg&r=7n1bLwXDzepgjKSNziw-ng&m=Vi2JxqEOxr992ibCDezMAd_sbdja65aRxMh4oM6WYpo&s=Qb_JJynxAr1X-KEpv8g-FVJ4Ac4wuqLr6fR3IfEVNpo&e=>
> ,
> however it is slightly difficult for me to understand.
>
>
>
>
> It would be very helpful if any one could guide me in a proper way on
> setting up Master/Slave replication on postgres. Any recommendations on
> good documentation
> or study materials on postgres replication would be highly appreciated.
>
>
>
>
> Many Thanks in advance.
>
>
>
>
>
> Thank You,
>
> Sajan Gone
>
>
>
>
>
>
>
> ------------------------------
>
>
>
> Notice: This communication may contain privileged and/or confidential
> information. If you are not the intended recipient, please notify the
> sender by email, and immediately delete the message and any attachments
> without copying or disclosing them. LB may, for
> any reason, intercept, access, use, and disclose any information that is
> communicated by or through, or which is stored on, its networks,
> applications, services, and devices.
>
>
>
>
>
> ------------------------------
>
> Notice: This communication may contain privileged and/or confidential
> information. If you are not the intended recipient, please notify the
> sender by email, and immediately delete the message and any attachments
> without copying or disclosing them. LB may, for any reason, intercept,
> access, use, and disclose any information that is communicated by or
> through, or which is stored on, its networks, applications, services, and
> devices.
>