Forum OpenACS Q&A: Re: PostgreSQL data disappeared

Posted by Jarkko Laine on

There is three subdirs in base directory, of which, I think, two first are template0 and 1 and the last one the only real database left. So it seems that two databases are totally lost from the data directory. Fortunately they were just test servers.

What's more unfortunate, dumping the only database gives just the database creation phase, so it seems to have forgotten that there's been any new data after that.

I'll get into the OS and hardware stuff later, now I have to clean my room and fly back home for Xmas.

I was so pissed of for all of this that I hacked the nightly PostgreSQL backup script to use scp instead of ftp. It seems you have to first lose three months worth of blog entries before you really get the important things done. I'll share the script on Next Steps page as soon as I can see it working.