Warning of .partial wal file in PITR and Replication Environment

[Amee Sankhesara - Quipment India <amee.sankhesara@xxxxxxxxxxx>]

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

 

QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
mail@ / 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.