Re: two cents - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: two cents
Date
Msg-id Pine.LNX.4.30.0102101040440.775-100000@peter.localdomain
Whole thread Raw
In response to two cents  ("George Johnson" <gjohnson@jdsc.com>)
List pgsql-general
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/


pgsql-general by date:

Previous
From: Guy Fraser
Date:
Subject: Re: Re: Data Import
Next
From: "Kogotkov, Vyacheslav"
Date:
Subject: RE: can't run pg_dump in sh script using crontab