Re: Recover anything from dropped database?

> I have a backup as of last night, but I'd like to recover something
> more recent if I can.  If I'm stuck with the backup, I can just
> stop the postmaster, drop the whole PG directory into place from
> the backup, and restart, yes?

I presume from the near-deafening silence there's nothing else I can
do, which is no surprise, but I'd still like confirmation about how
to restore the backup.

(It turns out I can recover the changes since the backup annother
way, since they all happened through interaction with CGI scripts,
luckily GET rather than POST - I can "replay" the relevant URLs
grepped from the web server log.)

Still, I'm trying to figure out how to avoid my screw-up in the
future.  I'm not that familiar with the permissions stuff - is there
any way to take away "drop DB privileges" from a user, or even all
users?  Again, this is PG 7.4.

Thanks.

- John Burger
   MITRE