Re: PG_DUMP and table locking in PG7.4 - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: PG_DUMP and table locking in PG7.4
Date
Msg-id 1132151511.15204.33.camel@home
Whole thread Raw
In response to Re: PG_DUMP and table locking in PG7.4  (Yann Michel <yann-postgresql@spline.de>)
List 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.

-- 



pgsql-hackers by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: question about count(b) where b is a custom type
Next
From: Tom Lane
Date:
Subject: Re: MERGE vs REPLACE