Forum OpenACS Q&A: Re: database recovery: how does postgres unix work?

Collapse
Posted by Janine Ohmer on
The simple form is what we always use, but I'd be interested to hear if anyone thinks there is a better way.

Just FYI, now that it works you don't actually have to do a dump and restore. Just shut it down, move that data directory to where you want it's final resting place to be, and adjust PGDATA accordingly. Voila. Of course you need the dump command anyway so you can start doing nightly backups, but there's no need to go through a restore cycle unless you just want to.