>>> On Tue, Jun 19, 2007 at 11:16 AM, in message <46780175.3040207@xxxxxxxxxxxx>, Tom Arthurs <tarthurs@xxxxxxxxxxxx> wrote: > > Looks like you are expecting the archive command to run when you shut > down the data base. It won't. It only runs when the xlog gets full and > the system needs to recycle to a new logfile. If you need to force a WAL file to test your backup process, try running something like: select pg_switch_xlog(); http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-BACKUP-TABLE -Kevin
