Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cz25S-0002hM-Dw for pgsql-admin@arkaria.postgresql.org; Fri, 14 Apr 2017 14:20:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cz25Q-00035C-Lo for pgsql-admin@arkaria.postgresql.org; Fri, 14 Apr 2017 14:20:32 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cz25P-00034z-0E for pgsql-admin@postgresql.org; Fri, 14 Apr 2017 14:20:31 +0000 Received: from mx0b-00204f01.pphosted.com ([148.163.152.15]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cz25G-00031P-8g for pgsql-admin@postgresql.org; Fri, 14 Apr 2017 14:20:28 +0000 Received: from pps.filterd (m0092829.ppops.net [127.0.0.1]) by mx0b-00204f01.pphosted.com (8.16.0.21/8.16.0.21) with SMTP id v3EEG29k027153; Fri, 14 Apr 2017 10:20:13 -0400 Received: from colmailedgp02.limitedbrands.com ([198.245.145.123]) by mx0b-00204f01.pphosted.com with ESMTP id 29tp5pvepa-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=NOT); Fri, 14 Apr 2017 10:20:13 -0400 From: "Gone, Sajan" To: Samed YILDIRIM , "pgsql-admin@postgresql.org" Subject: Re: Postgres replication Thread-Topic: [ADMIN] Postgres replication Thread-Index: AQHStIthP7YOhXZQlkaLTNH8yrmAc6HEArEAgADoq4A= Date: Fri, 14 Apr 2017 14:20:12 +0000 Message-ID: References: <416081492115246@web3m.yandex.ru> In-Reply-To: <416081492115246@web3m.yandex.ru> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.237.24.34] Content-Type: multipart/alternative; boundary="_000_D51651DB6518sgonelbcom_" MIME-Version: 1.0 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:,, definitions=2017-04-14_09:,, signatures=0 X-Proofpoint-Spam-Details: rule=outbound_policy_notspam policy=outbound_policy score=0 priorityscore=1501 malwarescore=0 suspectscore=0 phishscore=0 bulkscore=0 spamscore=0 clxscore=1011 lowpriorityscore=0 impostorscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1702020001 definitions=main-1704140124 X-Pg-Spam-Score: 0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_D51651DB6518sgonelbcom_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Samed, Thanks for sending out the weblink. I was able to successfully set the re= plication 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 loo= k 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 replic= ation status). Thank You, Sajan Gone. From: Samed YILDIRIM > Date: Thursday, April 13, 2017 at 4:27 PM To: Sajan Gone >, "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-postgresql-on-an-ubuntu-12-04-vps Best regards. 22:25, 13 Nisan 2017, "Gone, Sajan" >: Hello, Good afternoon everyone. This is Sajan Gone, I am trying to setup a Standard Master/Salve replicat= ion between two postgres instances. I am pretty much new to postgres and no= t 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, 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 setti= ng up Master/Slave replication on postgres. Any recommendations on good doc= umentation 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 infor= mation. If you are not the intended recipient, please notify the sender by = email, and immediately delete the message and any attachments without copyi= ng or disclosing them. LB may, for any reason, intercept, access, use, and disclose any information that is co= mmunicated by or through, or which is stored on, its networks, applications= , services, and devices. ________________________________ Notice: This communication may contain privileged and/or confidential infor= mation. If you are not the intended recipient, please notify the sender by = email, and immediately delete the message and any attachments without copyi= ng or disclosing them. LB may, for any reason, intercept, access, use, and = disclose any information that is communicated by or through, or which is st= ored on, its networks, applications, services, and devices. --_000_D51651DB6518sgonelbcom_ Content-Type: text/html; charset="iso-8859-1" Content-ID: <744CA94888D8A445A3A807572639598F@lb.com> Content-Transfer-Encoding: quoted-printable
Hi Samed,

  Thanks for sending out the web= link. 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 m= y next question would be on how to look at the replication status. Like MyS= QL  “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>
Date: Thursday, April 13, 2017 at 4= :27 PM
To: Sajan Gone <sgone@lb.com>, "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Postgres repli= cation

Hi Sajan,

You can take a look following document. It is good for a start point.


Best regards.

22:25, 13 Nisan 2017, "Gone, Sajan" <sgone@lb.com>:





Hello,


Good afternoon everyone. 




  This is Sajan Gone, I am trying= to setup a Standard Master/Salve replication between two postgres instance= s. I am pretty much new to postgres and not exactly sure how replication wo= rks and what is an architecture behind
it.  As of now I am following the standard postgres documentation @&nb= sp;https://www.postgr= esql.org/docs/current/static/warm-standby.html#PREPARING-MASTER-FOR-STANDBY= ,
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 set= ting up Master/Slave replication on postgres. Any recommendations on good d= ocumentation
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 infor= mation. If you are not the intended recipient, please notify the sender by = email, and immediately delete the message and any attachments without copyi= ng or disclosing them. LB may, for
any reason, intercept, access, use, and disclose any information that is co= mmunicated by or through, or which is stored on, its networks, applications= , services, and devices.






Notice: This communication may contain privileged and/or confidential infor= mation. If you are not the intended recipient, please notify the sender by = email, and immediately delete the message and any attachments without copyi= ng or disclosing them. LB may, for any reason, intercept, access, use, and disclose any information that is c= ommunicated by or through, or which is stored on, its networks, application= s, services, and devices.
 --_000_D51651DB6518sgonelbcom_--