|
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 conf file: fsync =
on
# turns forced synchronization on or off wal_sync_method =
fsync # the default is the
first option
# supported by the operating system:
# open_datasync
# fdatasync
# fsync
# fsync_writethrough
# open_sync #full_page_writes =
on
# recover from partial page writes #wal_buffers = 8
# min 4, 8KB each #commit_delay =
0
# range 0-100000, in microseconds #commit_siblings =
5
# range 1-1000 # - Checkpoints - checkpoint_segments =
1 # in logfile segments, min 1,
16MB each checkpoint_timeout =
30 # range 30-3600, in
second checkpoint_warning =
5 # in seconds, 0 is off # - Archiving - archive_command = 'touch /var/lib/pgsql/bkp/myfile' Here is my log entry for the duration of the test: FATAL: terminating connection due to administrator
command LOG: shutting down LOG: database system is shut down LOG: database system was shut down at 2007-06-19
07:48:03 EDT LOG: checkpoint record is at 0/899E68 LOG: redo record is at 0/899E68; undo record is at
0/0; shutdown TRUE LOG: next transaction ID: 2445; next OID: 16399 LOG: next MultiXactId: 1; next MultiXactOffset: 0 LOG: database system is ready LOG: transaction ID wrap limit is 2147484146, limited
by database "postgres" Thanks in advance, ~george |
