Warning of .partial wal file in PITR and Replication Environment

[Quipment Logo]

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@<mailto:%20amee(dot)sankhesara(at)quipment(dot)in> / www.quipment.in<http://www.quipment.in>

QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
mail@<mailto:mail(at)quipment(dot)nl> / www.quipment.nl<http://www.quipment.nl>

Hoofdkantoor Nijmegen
Kerkenbos 1236 C
6546 BE Nijmegen
Tel.

+31 (0)24 372 47 00

Fax.

+31 (0)24 372 47 07

Quipment India
903-904 Landmark,
Beside Titanium City Centre,
Anandnagar Road, 100ft Ring Road,
Ahmedabad
Gujarat - 380015 - India
Tel. +91 (0) 79 4009 7847

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.