>>> On Tue, Jun 19, 2007 at 11:16 AM, in message <[EMAIL PROTECTED]>,
Tom Arthurs <[EMAIL PROTECTED]> 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
 



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to