Reuven M. Lerner wrote:
> I'm running a medium-traffic Web site that has been running for a few
> years, and which uses about four PostgreSQL databases on a regular
> basis. I'm currently running 8.2, although I'm planning to upgrade to
> 8.3 in the coming week or two, in part because of the problems that
> I'm having. The databases consume a combined total of 35 GB. Like a
> good boy, I've been backing the system up overnight, when we have less
> traffic, since the site began to run. I use pg_dump to back up,
> saving both schemas and data for a full restore in case of failure.
> pg_dump typically executes from another machine on a local network; if
> it would help to run pg_dump locally, then I'm certainly open to doing
> that.
>
One point to note with continuous archiving, if your four databases are
in the same cluster, then restoring the archive will restore all your
databases to the same point in time. So you cannot, as far as I am
aware, restore just one of the four databases.
Howard.