Re: deleted logs when I shouldn't have...

Stephanie Brail <zhaanlives(at)yahoo(dot)com> writes:
> I did something really stupid. Our server was out of
> disk space and I deleted the files in the pg_xlog
> directory (or whatever the heck it's called). Now I
> can't start Postgres. Help!

If you shut down the postmaster cleanly before you zapped pg_xlog, then
I think it will work safely to run contrib/pg_resetxlog and start the
postmaster.

If you zapped pg_xlog in a running system or after a crash, you can
still do the resetxlog, but there's no guarantee that your last few
transactions will have applied cleanly --- you may find that some or
all of the effects of "committed" xacts are missing.

> Also, how to deal with these logs, that grow and grow
> and take up space?

7.1.3 is better about that.

regards, tom lane