Online backup
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
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/
Show quoted text
There are 10 kinds of people in the world, those that can do binary
arithmetic and those that can't.
Hi Martijn,
pg_dump cares of changes in data while it is dumping?
TIA, Paulo Henrique
Quoting Martijn van Oosterhout (kleptog@svana.org):
Show quoted text
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.
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/
Show quoted text
There are 10 kinds of people in the world, those that can do binary
arithmetic and those that can't.