Warning of .partial wal file in PITR and Replication Environment - Mailing list pgsql-general

Hello,

We have a windows setup for PostgreSQL(Version 9.6).

We have setup replication and PITR on this PostgreSQL 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 we have observed in the log that said

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"

Due to this it has stopped to take backup of PITR

So we like to know how to clean up the “.partial” file from pg_xlog and run PITR  backup smoothly

Also like to know is there any database consistency related issue ?

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.