Re: [GENERAL] Recovering a messed-up database

2007-05-14 Thread Tom Lane
"Reuven M. Lerner" <[EMAIL PROTECTED]> writes: > To make a long story short, I thought that the site administrator was > making regular backups, and that I was running pg_dump every night. > Unfortunately, neither assumption was quite right. The administrator > was using rsync to back things u

[GENERAL] Recovering a messed-up database

2007-05-14 Thread Reuven M. Lerner
I'm running a PostgreSQL 8.2.0 system on RHEL WS (update 5). The machine is administered by someone else. To make a long story short, I thought that the site administrator was making regular backups, and that I was running pg_dump every night. Unfortunately, neither assumption was quite righ