Re: Online backup

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.