Re: WAL files backup

On 2/18/07, pedro noticioso <cucnews@yahoo.com> wrote:
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/