Comments on: How to Set Up Streaming Replication in PostgreSQL 12 https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/ Wed, 31 Jan 2024 22:11:30 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Antonio https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/#comment-10973011 Sun, 07 Feb 2021 12:56:10 +0000 https://www.percona.com/blog/?p=62642#comment-10973011 Hi Avinsah,

thank you, good and very useful post!

]]> By: Mead Lai https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/#comment-10972856 Wed, 25 Nov 2020 03:28:52 +0000 https://www.percona.com/blog/?p=62642#comment-10972856 Logic replication should be used in this case to synchronize tables, but not DB instance level.

]]> By: Rajesh https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/#comment-10972757 Thu, 08 Oct 2020 04:13:31 +0000 https://www.percona.com/blog/?p=62642#comment-10972757 Postgres is already running on your machine.

]]> By: Mo https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/#comment-10972743 Wed, 30 Sep 2020 04:01:17 +0000 https://www.percona.com/blog/?p=62642#comment-10972743 Hi Avinsah,

can you please let me know how to replicate only one database for example A from one primary to secondary, if i have more than 1 database in primary but just want to replicated 1 db to secondary rest can stay without replication or dr

]]> By: Benny George https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/#comment-10972253 Wed, 20 May 2020 08:51:16 +0000 https://www.percona.com/blog/?p=62642#comment-10972253 Thanks Avinash, good post

]]> By: rohithsolomonth https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/#comment-10971923 Fri, 13 Mar 2020 10:29:22 +0000 https://www.percona.com/blog/?p=62642#comment-10971923 Hi Avi:

I see the below error:

tgres@postgresql:/etc/postgresql/12/main$ pg_ctl -D /etc/postgresql/12/main/ start
waiting for server to start….postgres: could not access the server configuration file “/etc/postgresql/12/main/postgresql.conf”: No such file or directory
stopped waiting
pg_ctl: could not start server
Examine the log output.

The pg_basebackup dint copy the postgresql.conf file form the master:

pg_basebackup -h 192.168.56.7 -U replicator -p 5432 -D /etc/postgresql/12/main/ -Fp -Xs -P -R

]]> By: MURRAY Scott NEWCOMB https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/#comment-10971701 Mon, 20 Jan 2020 04:30:55 +0000 https://www.percona.com/blog/?p=62642#comment-10971701 When will PostgreSQL support Master – Master Replication. i.e. what 2ndQuadrant did with BDR-3 in place of BDR-1. 2nd Quadrant made BDR-3 NOT open source, and charges around 9,000 USD per server, at least that was the figure I was given. I looked at porting BDR-1 to PG 10.0, I figured it is around a 470+ hour job to do so, if not more, – and IF PostgreSQL 13 or 14 is going to support BDR Master/Master, that is what interests me. As it stands I am simply porting over my Application to MySQL – or rather that is my solution, verse paying 2ndQuadrant for each server. Am I barking up the wrong tree?

]]> By: chakriganap https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/#comment-10971460 Tue, 19 Nov 2019 22:30:26 +0000 https://www.percona.com/blog/?p=62642#comment-10971460 Step 6) i got error
“lock file “postmaster.pid” already exists”

]]> By: chakriganap https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/#comment-10971459 Tue, 19 Nov 2019 21:10:48 +0000 https://www.percona.com/blog/?p=62642#comment-10971459 Appreciated and Thanks for sharing good document. I am very new in this technology, after done all the steps from the above document, i restarted in postgressql in stand by server but the server can’t get back,please suggest me what wrong with in.
Thanks

]]> By: sinisha https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/#comment-10971300 Mon, 21 Oct 2019 14:48:48 +0000 https://www.percona.com/blog/?p=62642#comment-10971300 Thank you for a very good post. Could you explain also how the fail over works, promoting slave to master. And how it works with cascade replication, another slave after slave, after switching first slave to master. The second question is how to switch back to origin master.

]]>