Re: two cents

George Johnson writes:

> Reading the 20 or so Re's to NFS issues as well as the last few months of
> list watching, as well as my own crash experience etc, what is the current
> direction/state of things regarding backup, replication etc with postgresql?
> Do you foresee pg_dump being used in the long term?  It is sounding like
> people are screaming for an automated, reliable way/state for shifting data
> out of the database.  Or a "hot copy" function.

Backup will probably stay pg_dump's domain indefinitely.  It has a "hot
copy"/snapshot/consistent dump capability, it can be automated, and we'd
like to think that 7.1's incarnation is a lot more reliable, too.

Eventually, maybe even in the 7.2 release, WAL based backups will be
available as well.

Replication is available at www.erserver.com.  A stripped
down/introductory version (so I understand) is in contrib/rserv in 7.1.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/