Re: Cannot use a standalone backend to VACUUM in "postgres""

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot use a standalone backend to VACUUM in "postgres""
Date: 2008-04-09 02:24:31
Message-ID: m3skxvwysg.fsf@conexa.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:

> Manuel Sugawara wrote:
>
>> A friend is doing the queries right now but it takes time :-(, mean
>> time I was wondering if it will be safe to apply the following patch
>> just to get the database up and be able to run pg_dumpall:
>
> Yes, it is safe. Just make sure to get a copy of the database out in
> 500k transactions ...

Ok, will do that. Thanks a lot Alvaro. Want me to send more details to
debug the problem?.

Regards,
Manuel.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mljv 2008-04-09 07:29:24 Re: Problem after VACUUM ANALYZE
Previous Message Alvaro Herrera 2008-04-09 01:01:08 Re: Cannot use a standalone backend to VACUUM in "postgres""