Virupaksha Kanjilal <v.kanji...@gmail.com> 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 the backup to a consistent state?
Look in your WAL repository for files named *.backup. The prefix part will match the name of a regular WALf file from when the backup was started and the .backup file itself will contain some human readable text indicating the last WAL segment that you'll need for a consistent recovery. HTH > Thanks > Viru > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
