Re: [ADMIN] WAL files required to make base backup consistent

2013-05-28 Thread Sergey Konoplev
Do you use archive_command or pg_receivexlog to archive your WAL files? If you use archive_command, then, as Jarry has already stated, you will have *.backup files in your WAL archive, the latest of which points to the beginning of the WAL files set needed for the latest base backup. If you use p

Re: [ADMIN] WAL files required to make base backup consistent

2013-05-28 Thread Jerry Sievers
Virupaksha Kanjilal writes: > Hi > > I perform a pg_basebackup with tar option and do not bring in the WAL > segments created during the backup. Now I want > to make the backup a consistent copy and for that I need the WAL segments. > How can I know which all WAL segments to > apply to bring th

Re: [ADMIN] WAL files required to make base backup consistent

2013-05-22 Thread Amit Langote
On Thu, May 23, 2013 at 6:30 AM, Virupaksha Kanjilal wrote: > Hi > > I perform a pg_basebackup with tar option and do not bring in the WAL > segments created during the backup. Now I want to make the backup a > consistent copy and for that I need the WAL segments. How can I know which > all WAL se

[ADMIN] WAL files required to make base backup consistent

2013-05-22 Thread Virupaksha Kanjilal
Hi I perform a pg_basebackup with tar option and do not bring in the WAL segments created during the backup. Now I want to make the backup a consistent copy and for that I need the WAL segments. How can I know which all WAL segments to apply to bring the backup to a consistent state? Thanks Viru