Re: [ADMIN] archive_command does not execute

2007-06-19 Thread Simon Riggs
On Tue, 2007-06-19 at 08:17 -0400, George Wilk wrote: > archive_command = 'touch /var/lib/pgsql/bkp/myfile' Presumably you understand that an archive_command like the above is not ever going to do any archiving? set log_min_messages = DEBUG1 if you want to see the archive messages. B

Re: [ADMIN] archive_command does not execute

2007-06-19 Thread Kevin Grittner
>>> 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

Re: [ADMIN] archive_command does not execute

2007-06-19 Thread Tom Arthurs
George Wilk wrote: Hi, I am attempting to use the WAL archiving on a Solaris machine, running PostgreSQL 8.1.4. The archive_command specified in the postgresql.conf file does not get executed, nor do I see any log entries showing errors etc. What am I doing wrong here? Here is the

[ADMIN] archive_command does not execute

2007-06-19 Thread George Wilk
Hi, I am attempting to use the WAL archiving on a Solaris machine, running PostgreSQL 8.1.4. The archive_command specified in the postgresql.conf file does not get executed, nor do I see any log entries showing errors etc. What am I doing wrong here? Here is the relevant fragment of my c