Обсуждение: [ADMIN] Postgres replication
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, 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.
Hi Sajan,
22:25, 13 Nisan 2017, "Gone, Sajan" <sgone@lb.com>:
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@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,
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.
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>
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
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,
22:25, 13 Nisan 2017, "Gone, Sajan" <sgone@lb.com>:
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 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,
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.
On Fri, Apr 14, 2017 at 10:20 AM, Gone, Sajan <SGone@lb.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.
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 replicationHi 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 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,
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.
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 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>
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 replicationHi 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 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,
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.
Thanks Samed. That sure works.
I have followed the documentation that you have provided at https://www.digitalocean.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 assuming 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 documentation that I can follow to setup 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 replication
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 replication
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 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>
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 replicationHi 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 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,
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.
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.
Hi Sajan,
What is meaning of Active/Active setup for you? Postgres provides 1 master (read/write) server and multiple synchronous/asynchronous (read-only) slave server with streaming replication build-in. If you want multiple master (read/write) PostgreSQL server, you should use an additional tool like BDR (Bi-Directional Replication), EDB Replication Server etc. Also Postgres-XC may be taken your interest.
Best regards.
Samed YILDIRIM
17.04.2017, 15:52, "Gone, Sajan" <sgone@lb.com>:
Thanks Samed. That sure works.I have followed the documentation that you have provided at https://www.digitalocean.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 assuming 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 documentation that I can follow to setup Active/Active replication ?Thank You.Thank You,Sajan GoneFrom: 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 replicationHi Sajan,You can use following query.select * from pg_stat_replication;Best regards.Samed YILDIRIM14.04.2017, 17:20, "Gone, Sajan" <sgone@lb.com>: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>
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 replicationHi 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 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,
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.
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.
Thanks Samed. I exactly mean Master/Master replication setup.
Appreciate your comments. I will look into those tools and products..
Thank You,
Sajan Gone
From: Samed YILDIRIM <samed@reddoc.net>
Date: Monday, April 17, 2017 at 10:12 AM
To: Sajan Gone <sgone@lb.com>, "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Postgres replication
Date: Monday, April 17, 2017 at 10:12 AM
To: Sajan Gone <sgone@lb.com>, "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Postgres replication
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.