-rw------- 1 postgres staff 234 2007-02-16 10:12
000000010000000000000003
-rw------- 1 postgres staff 234 2007-02-16 10:12
000000010000000000000004
-rw------- 1 postgres staff 234 2007-02-16 10:12
000000010000000000000005.0024FD70.backup
Are these files 234 bytes long? Also, where is the 05 logfile? Can you post your archive_command?
LOG: could not read from log file 0, segment 5 at
offset 2416640: No such file or directory
This is because your archived logs are partial, it is expecting to read XLOG_BLCKSZ and it had a partial read. Clearly you are doing something wrong, but there just isn't enough information.
I wrote an article about performing a hot backup with a Perl script that I wrote called pg_hotbackup (available on pgfoundry), you can look at it here:
http://www.postgresqlforums.com/wiki/Backup_%26_Recovery
But you must follow the PostgreSQL documentation for setting up the archive_command, which is more or less this:
archive_command = 'cp -i %p /var/lib/pgsql/backups/%f </dev/null'
Also documented on that page is the recovery procedure. It is all based on the PostgreSQL documentation and has worked fine in my testing.
--
Chad
http://www.postgresqlforums.com/
