Re: Online backup

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 04:43:49
Message-ID: 20021023044349.GC13710@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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.

In response to

  • Online backup at 2002-10-23 02:55:18 from Paulo Henrique Baptista de Oliveira

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Garo Hussenjian 2002-10-23 06:38:33 Alter table syntax
Previous Message Ron Harter 2002-10-23 04:30:27 Re: Problem compiling on HP/Compaq Tru64 UNIX