pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL V13 Replication Issue
3+ messages / 3 participants
[nested] [flat]
* PostgreSQL V13 Replication Issue
@ 2021-06-16 16:25 Haseeb Khan <khanhaseeb92@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Haseeb Khan @ 2021-06-16 16:25 UTC (permalink / raw)
To: pgsql-performance@lists.postgresql.org
Hello Everyone,
Apologies in advance I don't know where to get knowledge regarding this
issue that's why I posted here, Highly appreciated if someone could help on
this regard
We have installed and configured PostgreSQL V13 Master- Slave streaming
replication on Windows server 2016 but replication is not working. I don't
know where the error is because we are not facing any error regarding
replication and replication also not working.
Below are the Configuration steps performed on Master and Slave Server
*Master Server postgresql.conf file changes made*
listen_addresses = '*'
wal_level = replica
wal_writer_delay = 500ms
archive_mode = on
archive_command ='copy %p \\server IP\wal_archive\%f"'
archive_timeout = 3600
max_wal_senders = 6
max_replication_slots = 6
*pg_hba Master Server File*
host replication username slave_ip/32 md5
host replication username master_ip/32 md5
*Below are the Configuration steps performed on Slave Server*
*Note:* I have copied Data directory from master server and paste it on
Slave server
*Slave Server postgresql.conf file changes made*
listen_addresses = '*'
wal_level = replica
wal_writer_delay = 500ms
#archive_mode = off
max_wal_senders = 6
hot_standby = on
*Slave pg_hba.conf file*
host replication username slave_ip/32 md5
host replication username master_ip/32 md5
*recovery.conf file*
standby_mode = 'on'
restore_command= 'copy "C:\wal_archive\%f" %p'
<primary_conninfo> = 'host=<MasterIP> port=5432 user=replicator
password=*****'
After all these changes made when I restart the master and slave server and
run the following command on master server to check whether replication is
working or not the below mention query return 0 row
*Master Server* select * from pg_stat_replication" (return 0 row)
Would be highly appreciated, if someone could tell me what exactly the
issue is or what I am missing in the configuration on both the servers
(master- slave).Why replication is not working?
*BR,*
Haseeb Ahmad
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PostgreSQL V13 Replication Issue
@ 2021-06-16 16:30 Dean Gibson (DB Administrator) <postgresql@mailpen.com>
parent: Haseeb Khan <khanhaseeb92@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Dean Gibson (DB Administrator) @ 2021-06-16 16:30 UTC (permalink / raw)
To: pgsql-performance@lists.postgresql.org
I'm no expert, but it looks like you are reading v9.6 documentation for
a v13 installation.
On 2021-06-16 09:25, Haseeb Khan wrote:
>
> ...
>
> hot_standby = on
>
> ...
>
> *recovery.conf file*
>
> standby_mode = 'on'
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PostgreSQL V13 Replication Issue
@ 2021-06-17 01:02 Michael Paquier <michael@paquier.xyz>
parent: Haseeb Khan <khanhaseeb92@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Michael Paquier @ 2021-06-17 01:02 UTC (permalink / raw)
To: Haseeb Khan <khanhaseeb92@gmail.com>; +Cc: pgsql-performance@lists.postgresql.org
On Wed, Jun 16, 2021 at 09:25:37PM +0500, Haseeb Khan wrote:
> Would be highly appreciated, if someone could tell me what exactly the
> issue is or what I am missing in the configuration on both the servers
> (master- slave).Why replication is not working?
Your issue is partially here, as recovery.conf is not supported in 13:
> *recovery.conf file*
I would recommend to read this area of the documentation first:
https://www.postgresql.org/docs/13/warm-standby.html#STANDBY-SERVER-SETUP
All the recovery parameters have been moved to postgresql.conf, and
setting up a standby requires an extra file called standby.signal
created at the root of the data folder.
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../../YMqfPKMWhfTx7Kaq@paquier.xyz/2-signature.asc)
download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-06-17 01:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-06-16 16:25 PostgreSQL V13 Replication Issue Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-16 16:30 ` Dean Gibson (DB Administrator) <postgresql@mailpen.com>
2021-06-17 01:02 ` Michael Paquier <michael@paquier.xyz>
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