Re: problems with large objects dump

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 <sgrodriguez@gmail.com> wrote:

On Thu, Sep 20, 2012 at 11:35 AM, Tom Lane <tgl@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.