Postgres Pro
Downloads
Home   >   mailing lists

Thread: Online Backup

Online Backup

From
Jeremy G Byrne
Date:
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?

I'm hoping to be able to use PostgreSQL because I believe very strongly in
open code development projects, but I have to convince my management that
it makes strategic sense and issues like backup/recovery are naturally
critical to that. Thanks very much for any information you're able to provide.

CYa,
JEREMY

Re: [ADMIN] Online Backup

From
The Hermit Hacker
Date:
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