Re: Online backup - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Online backup
Date
Msg-id 20021023044349.GC13710@svana.org
Whole thread Raw
In response to Online backup  (Paulo Henrique Baptista de Oliveira <baptista@linuxsolutions.com.br>)
Responses Re: Online backup  (Paulo Henrique Baptista de Oliveira <baptista@linuxsolutions.com.br>)
List pgsql-general
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: Paulo Henrique Baptista de Oliveira
Date:
Subject: Online backup
Next
From: Garo Hussenjian
Date:
Subject: Alter table syntax