Re: PG_DUMP and table locking in PG7.4

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Yann Michel <yann-postgresql(at)spline(dot)de>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PG_DUMP and table locking in PG7.4
Date: 2005-11-16 14:31:51
Message-ID: 1132151511.15204.33.camel@home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I'm asking, because we have a bigger datawarehouse and dump the data for
> a backup every night. Unfortunately, the backup now takes realy long.

You may want to consider upgrading and using PITR backups instead. They
can be much faster to both backup and to restore if something goes
wrong.

--

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-11-16 14:49:28 Re: MERGE vs REPLACE
Previous Message Tino Wildenhain 2005-11-16 14:14:42 Re: question about count(b) where b is a custom type