Postgres Pro
Downloads
Home   >   mailing lists

Thread: Warning of .partial wal file in PITR and Replication Environment

Warning of .partial wal file in PITR and Replication Environment

From
Amee Sankhesara - Quipment India
Date:

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@ / 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.

 

Attachment

Re: Warning of .partial wal file in PITR and Replication Environment

From
Michael Paquier
Date:
On Mon, Mar 26, 2018 at 11:52:53AM +0000, Amee Sankhesara - Quipment India wrote:
> 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"

Am I reading that correctly or you are trying to copy twice the same
file?  Why?  Using only copy may cause corruptions if you are not
careful as a disabled write caching would cause the data to go to the OS
cache on Windows and not directly to disk.

> 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 ?

This is the last, partial WAL segment from the previous timeline.
Normally such things are able to archive correctly, so you may want to
consider a more advanced archive command able to handle duplicates.
It is impossible to give a strict answer before knowing what you are
looking for in terms of WAL archive redundancy.

You may need to use target_timeline = 'latest' in your recovery.conf
settings as well.
--
Michael
Attachment