Re: Postgresql backups

From: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
To: Guy Corbaz <guy(dot)corbaz(at)swissmail(dot)com>
Cc: Novice PGSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postgresql backups
Date: 2000-12-14 10:17:48
Message-ID: 3A389E4C.46576781@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)catalyst(dot)net(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2000-12-14 13:02:22 Re: passwords
Previous Message Nabil Sayegh 2000-12-14 09:41:53 Re: Postgresql backups