From: | "George Wilk" <gwilk(at)ellacoya(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | archive_command does not execute |
Date: | 2007-06-19 12:17:32 |
Message-ID: | 002c01c7b26b$d0085400$0d7ba8c0@ellacoya.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Carol Walter | 2007-06-19 12:39:41 | Re: [pgsql-advocacy] [PERFORM] Postgres VS Oracle |
Previous Message | Aleksander Kmetec - INTERA | 2007-06-19 11:38:19 | Re: How to restore updated records |