Re: Postgresql backups

Guy Corbaz wrote:
>
> Hello,
>
> My database is getting bigger and bigger and I would like to use an
> automatic backup procedure. I'm presently using ARKEIA as a backup tool, and
> there is a possibility to launch a script before and after the backup.
>
> Is there any posibility to make backups of the database while up and running
> and when users are logged on ?

Yes, pg_dump is the utility you want.

Cheers,
                    Andrew.
--
_____________________________________________________________________
           Andrew McMillan, e-mail: Andrew@catalyst.net.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267