Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d069F-0000EM-MC for pgsql-admin@arkaria.postgresql.org; Mon, 17 Apr 2017 12:52:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d069F-0005uW-7r for pgsql-admin@arkaria.postgresql.org; Mon, 17 Apr 2017 12:52:53 +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 1d069E-0005uK-FY for pgsql-admin@postgresql.org; Mon, 17 Apr 2017 12:52:52 +0000 Received: from mx0a-00204f01.pphosted.com ([148.163.148.15] helo=mx0b-00204f01.pphosted.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d069A-0006Fb-Dv for pgsql-admin@postgresql.org; Mon, 17 Apr 2017 12:52:50 +0000 Received: from pps.filterd (m0092830.ppops.net [127.0.0.1]) by mx0a-00204f01.pphosted.com (8.16.0.21/8.16.0.21) with SMTP id v3HCjcD1011599; Mon, 17 Apr 2017 08:52:40 -0400 Received: from colmailedgp02.limitedbrands.com ([198.245.145.123]) by mx0a-00204f01.pphosted.com with ESMTP id 29uf20n6kd-3 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=NOT); Mon, 17 Apr 2017 08:52:40 -0400 From: "Gone, Sajan" To: Samed YILDIRIM , "pgsql-admin@postgresql.org" Subject: Re: Postgres replication Thread-Topic: [ADMIN] Postgres replication Thread-Index: AQHStIthP7YOhXZQlkaLTNH8yrmAc6HEArEAgADoq4CAAEcmAIAEV2KA Date: Mon, 17 Apr 2017 12:52:39 +0000 Message-ID: References: <416081492115246@web3m.yandex.ru> <3891051492180490@web51g.yandex.ru> In-Reply-To: <3891051492180490@web51g.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_D51A31F166D8sgonelbcom_" MIME-Version: 1.0 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:,, definitions=2017-04-17_11:,, 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=1015 lowpriorityscore=0 impostorscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1702020001 definitions=main-1704170118 X-Pg-Spam-Score: -0.6 (/) 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_D51A31F166D8sgonelbcom_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks Samed. That sure works. I have followed the documentation that you have provided at https://www.dig= italocean.com/community/tutorials/how-to-set-up-master-slave-replication-on= -postgresql-on-an-ubuntu-12-04-vps and the replication works perfectly fine. I am a= ssuming this works perfectly fine for an Active/Passive setup, however I am= wondering on how to setup Active/Active kind of an replication setup. Is Active/Active possible with postgres database, if so is there any docum= entation that I can follow to setup Active/Active replication ? Thank You. Thank You, Sajan Gone From: Samed YILDIRIM > Date: Friday, April 14, 2017 at 10:34 AM To: Sajan Gone >, "pgsql-admin@postgresql= .org" > Subject: Re: [ADMIN] Postgres replication Hi Sajan, You can use following query. select * from pg_stat_replication; Best regards. Samed YILDIRIM 14.04.2017, 17:20, "Gone, Sajan" >: 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. ________________________________ 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_D51A31F166D8sgonelbcom_ Content-Type: text/html; charset="iso-8859-1" Content-ID: <6BDD8685F7BFD34F8B00E86D1185885F@lb.com> Content-Transfer-Encoding: quoted-printable
Thanks Samed. That sure works.=

I have followed the documentation tha= t you have provided at https://www.digita= locean.com/community/tutorials/how-to-set-up-master-slave-replication-on-po= stgresql-on-an-ubuntu-12-04-vps and the replication works perfectly fine. I am assuming this works perfectly f= ine for an Active/Passive setup, however I am wondering on how to setup Act= ive/Active kind of an replication setup.

 Is Active/Active possible with = postgres database, if so is there any documentation that I can follow to se= tup Active/Active replication ?

Thank You.

Thank You,
Sajan Gone


From: Samed YILDIRIM <samed@reddoc.net>
Date: Friday, April 14, 2017 at 10:= 34 AM
To: Sajan Gone <sgone@lb.com>, "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Postgres repli= cation

Hi Sajan,
 
You can use following query.
 
select * from pg_stat_replication;
 
Best regards.
Samed YILDIRIM
 
 
 
14.04.2017, 17:20, "Gone, Sajan" <sgone@lb.com>:
Hi Samed,
 
  Thanks for sending out the webl= ink. I was able to successfully set the replication up (Master/Slave, Hot s= tand 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 MySQ= L  “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: <= /strong>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 = replication
 
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&quo= t; <sgone@lb.com>:



 
 
Hello,=
 
 
 
Good a= fternoon everyone. 
 

 
 
 = This is Sajan Gone, I am trying to setup a Standard Master/Salve replicati= on 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 @&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 wou= ld 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 documenta= tion
or study materials on postgres replication would be highly appreciated.
 

 
 
Many T= hanks in advance.
 

 
 
 
Thank = You,
 
Sajan = Gone
 

 


 



Notice: This communication may contain privileged and/or confidential i= nformation. 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 co= mmunicated by or through, or which is stored on, its networks, applications= , services, and devices.

 

 
 

Notice: This communication m= ay contain privileged and/or confidential information. If you are not the i= ntended recipient, please notify the sender by email, and immediately delet= e 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 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_D51A31F166D8sgonelbcom_--