Skip site navigation (1) Skip section navigation (2)

WAL files during a backup

From: windsurferdrew-pg(at)yahoo(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: WAL files during a backup
Date: 2008-08-27 14:07:17
Message-ID: 749976.10730.qm@web36902.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
I have a question regarding the WAL files that are moved during a backup to the "archive directory".

I have setup the postgresql.conf file to have the following archive command:

archive_command = 'cp -i %p /var/lib/pgsql/backups/%f </dev/null'

Environment: 
PG Version 8.1.4
OS: Linux 2.6.18-8.el5

After I have run the pg_hotbackup script, the backups directory contains only 2 files:
1. The gzipped tar file pg_hotbackup_<timestamp>.tar.gz, and
2. a WAL file ".backup" file, (for example 00000001000000000000223387.0089ED8C.backup)

The actual WAL file did not get copied to the backups directory. From the example above, I would have expected at least 1  WAL file named 00000001000000000000223387 to be in the backups directory.

My questions are:
1. Is this normal behavior? (perhaps no activity in the DB to cause a WAL file write during the backup?)
2. If I try to restore the DB without this WAL file, will the restore fail?

Thanks in advance

Drew 


Responses

pgsql-admin by date

Next:From: Phoenix KiulaDate: 2008-08-27 14:12:57
Subject: Re: Dumping/Restoring with constraints?
Previous:From: Lennin CaroDate: 2008-08-27 13:58:33
Subject: Re: [GENERAL] PITR - base backup question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group