Re: Online backup

From: Paulo Henrique Baptista de Oliveira <baptista(at)linuxsolutions(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Online backup
Date: 2002-10-23 11:10:51
Message-ID: 20021023091051.A5630@linuxsolutions.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Martijn,
pg_dump cares of changes in data while it is dumping?
TIA, Paulo Henrique
Quoting Martijn van Oosterhout (kleptog(at)svana(dot)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(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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2002-10-23 11:26:39 Re: Matching unique primary keys
Previous Message Leif Jensen 2002-10-23 09:36:15 Re: Linking 2 or more databases.