Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Oliver ElphickDate: 2000-12-14 13:02:22
Subject: Re: passwords
Previous:From: Nabil SayeghDate: 2000-12-14 09:41:53
Subject: Re: Postgresql backups

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group