Re: [ADMIN] Online Backup

On Fri, 3 Jul 1998, Jeremy G Byrne wrote:

> Dear All--
>
> I'm investigating PostgreSQL for a web-based dB project, and have been
> unable to find any documentation about its abilities to perform backups
> while online.
>
> The Features Comparison table on the postgresql.org site lists this as a
> feature of 6.2.1, but that's about the only reference to the procedure I
> can find.
>
> How easy is it to back up a (running/online) PostgreSQL dabatase? Is it as
> simple as copy/tar, or is there some inbuilt database replication system?

    pg_dump dumps the data to a text file while the system is live,
and is about the cleanest that I'm aware of...

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org