| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Paulo Henrique Baptista de Oliveira <baptista(at)linuxsolutions(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Online backup |
| Date: | 2002-10-23 12:22:49 |
| Message-ID: | 20021023122249.GA19401@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Oct 23, 2002 at 09:10:51AM -0200, Paulo Henrique Baptista de Oliveira wrote:
> Hi Martijn,
> pg_dump cares of changes in data while it is dumping?
> TIA, Paulo Henrique
> Quoting Martijn van Oosterhout (kleptog(at)svana(dot)org):
> > On Wed, Oct 23, 2002 at 12:55:18AM -0200, Paulo Henrique Baptista de Oliveira wrote:
> > > Hi all,
> > > I want to do an online backup.
> > > All that I see in lists are about cp $PGDATA and pg_dump.
> > > What about tables that are being updated at the same time the backup is
> > > running? The data will be consistent?
> >
> > Don't copy direct, use pg_dump
Pg_dump will produce a consistant dump. Basically a snapsnot of the database
at the moment you started the dump.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2002-10-23 13:39:00 | Re: Alter table syntax |
| Previous Message | Richard Huxton | 2002-10-23 11:26:39 | Re: Matching unique primary keys |