Re: problems with large objects dump

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(at)gmail(dot)com <mailto:sgrodriguez(at)gmail(dot)com>> wrote:
>
> On Thu, Sep 20, 2012 at 11:35 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us
> <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)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.
>
>

--

Marcos Luis Ortíz Valmaseda
about.me/marcosortiz <http://about.me/marcosortiz>
@marcosluis2186 <http://twitter.com/marcosluis2186>

10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...
CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION

http://www.uci.cu
http://www.facebook.com/universidad.uci
http://www.flickr.com/photos/universidad_uci