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@svana.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@svana.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.