On 10/11/2012 05:46 PM, Sergio Gabriel
Rodriguez wrote:
Hi,
I tried with Postgresql 9.2 and the process used to take
almost a day and a half, was significantly reduced to 6 hours,
before failing even used to take four hours. My question now is,
how long should it take the backup for a 200GB database with 80%
of large objects?
Regards, Sergio.
That´s depends of several things.
Hp
proliant Xeon G5
32
GB RAM
OS
SLES 10 + logs --> raid 6
data-->raid
6
Can you share your postgresql.conf here?
Which filesystem are you using for your data directory?
What options are you using to do the backup?
thanks!
On Thu, Sep 20, 2012 at 12:53 PM, Sergio
Gabriel Rodriguez <sgrodriguez@xxxxxxxxx>
wrote:
On Thu, Sep 20, 2012 at 11:35 AM, Tom Lane <tgl@xxxxxxxxxxxxx>
wrote:
You wouldn't happen to be
trying to use a 9.0 or later pg_dump would you? Exactly
what 8.4.x
release is this, anyway?
Tom, thanks for replying, yes, we tried it with
postgres postgres 9.1 and 9.2 and the behavior is exactly
the same. The production version is 8.4.9
Greetings,
sergio.
![]()
|
