Postgres Pro
Downloads
Home   >   mailing lists

Thread: Online backup

Online backup

From
Paulo Henrique Baptista de Oliveira
Date:
    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?
    Thanks,        Paulo Henrique

Re: Online backup

From
Martijn van Oosterhout
Date:
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.

Re: Online backup

From
Paulo Henrique Baptista de Oliveira
Date:
    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.

Re: Online backup

From
Martijn van Oosterhout
Date:
On Wed, Oct 23, 2002 at 09:10:51AM -0200, Paulo Henrique Baptista de Oliveira wrote:
>     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

Pg_dump will produce a consistant dump. Basically a snapsnot of the database
at the moment you started the 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.