Steve Brett <SBrett@e-mis.com> writes:
> is there any way to restore pg_log and is this file a file we should
> consider backing up ?
> currently i have a cron job that does a pg_dump every 4 hours and the files
> are then copied to a remote windoze box that backs up to tape.
pg_log is not very useful by itself. I think your existing backup
strategy is fine, assuming you can afford loss of up to 4 hours of data.
There is work going on to support incremental backup approaches, but
it's not available yet.
regards, tom lane