indeed i did.
the database had run from 18 months with zero downtime and i (stupidly)
mistook pg_log for the log file and truncated it.
after the initial panic and frantic phonecals around the company we decided
to upgrade to 7.2 and restore from a backup (thankfully we only lost 30 mins
of data and it was around lunchtime so we were ok).
anyways, the question is thus.
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.
also, is there a way to restore or rebuild pg_log ?
many thanks,
Steve Brett