Issue with PostgreSQL replication and PITR - Mailing list pgsql-general

Hello,

We have a windows(2016) setup for PostgreSQL(Version 9.6.5).

We have setup replication and PITR on this PostgreSQL server and wal files for replication and PITR we are storing on the another server which is shared with primary and secondary server.

For doing some OS migration activity for the PostgreSQL database servers

We created two new replication server and promoted to new master server for the same

During that activity one .partial file is created on master server and after that wal files are not copied in shared folder from which secondary server take it and restore it. All Wal files after .partial file are stored in pg_xlog folder of master data so it is increasing size of data directory of master server.

Wal files are not copying in shared location of master and secondary server but still replication is running and on secondary server data is up to date.

In logs getting only below warning :

Warning : The failed archive command was: copy "D:\PostgreSQL\9.6\data\pg_xlog\0000000100000A88000000F8.partial" "\\10.0.0.35\Archive_Replication\0000000100000A88000000F8.partial" | copy "D:\PostgreSQL\9.6\data\pg_xlog\0000000100000A88000000F8.partial" "\\10.0.0.35\Archive_PITR\0000000100000A88000000F8.partial"

Can’t figure out that in shared folder wal files are not copied but still secondary server is running in sync with master server.

What could be reason behind this?

And how to remove this .partial file from pg_xlog safely and how to start copying wal files from pg_xlog of master server to shared location of master and secondary server ?

Thanks,

Amee Sankhesara
Database Developer

R&D .Net Department

T / +91 (0) 94295 45266
amee.sankhesara@ / www.quipment.in

Disclaimer

This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message.