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. > >