Re: Postgresql backups - Mailing list pgsql-novice

From Andrew McMillan
Subject Re: Postgresql backups
Date
Msg-id 3A389E4C.46576781@catalyst.net.nz
Whole thread Raw
In response to Postgresql backups  ("Guy Corbaz" <guy.corbaz@swissmail.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: Postgresql backups
Next
From: Sterling
Date:
Subject: Re: Creating Log file - run in background.