From: Gone, Sajan <SGone@lb.com>
To: Samed YILDIRIM <samed@reddoc.net>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Postgres replication
Date: Fri, 14 Apr 2017 14:20:12 +0000
Message-ID: <D51651DB.6518%sgone@lb.com> (raw)
In-Reply-To: <416081492115246@web3m.yandex.ru>
References: <D515485A.647C%sgone@lb.com>
<416081492115246@web3m.yandex.ru>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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.
From: Samed YILDIRIM <samed@reddoc.net<mailto:samed@reddoc.net>>
Date: Thursday, April 13, 2017 at 4:27 PM
To: Sajan Gone <sgone@lb.com<mailto:sgone@lb.com>>, "pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.org>" <pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.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-postgresq...
Best regards.
22:25, 13 Nisan 2017, "Gone, Sajan" <sgone@lb.com<mailto:sgone@lb.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<htt...;,
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: SGone@lb.com, samed@reddoc.net
Subject: Re: Postgres replication
In-Reply-To: <D51651DB.6518%sgone@lb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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