Re: Online backup - Mailing list pgsql-general

From Paulo Henrique Baptista de Oliveira
Subject Re: Online backup
Date
Msg-id 20021023091051.A5630@linuxsolutions.com.br
Whole thread Raw
In response to Re: Online backup  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Online backup  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
    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
>
> --
> 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.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Matching unique primary keys
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Online backup