Re: pg_dump problem

From: Andrew Gould <andrewgould(at)yahoo(dot)com>
To: Mathieu Arnold <arn_mat(at)club-internet(dot)fr>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump problem
Date: 2001-06-06 14:49:27
Message-ID: 20010606144927.73825.qmail@web13408.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You can dump individual databases, even individual
tables, separately. Would this help?

Andrew

--- Mathieu Arnold <arn_mat(at)club-internet(dot)fr> wrote:
>
>
> Andrew Gould wrote:
> >
> > What's the status of the server? Is the file size
> > still increasing?
> >
> > Did you vacuum the databases prior to dumping?
>
> feeling stupid, was running out of ram
>
> pg 3314 5.3 76.7 702304 197816 ttyp1 S
> 16:00 0:43
> | \_ /opt/pg/bin/pg_dump -c -N -D -Fp
> backup
> pg_dump is taking 700M of ram...
> I won't say that's a good thing, but i found out
> where the problem was.
> I don't know how i'm gonna resolve it though.
>
> --
> Mathieu Arnold
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-06 14:53:26 Re: 7.1.2 vs. INT8 indexes
Previous Message Tom Lane 2001-06-06 14:49:26 Re: pg_dump problem