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?

Hp proliant Xeon G5
32 GB RAM
OS SLES 10 + logs --> raid 6
data-->raid 6

thanks!

On Thu, Sep 20, 2012 at 12:53 PM, Sergio Gabriel Rodriguez <
sgrodrig...@gmail.com> wrote:

> On Thu, Sep 20, 2012 at 11:35 AM, Tom Lane <t...@sss.pgh.pa.us> 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.
>
>

Reply via email to