Skip site navigation (1) Skip section navigation (2)

Re: HELP pls

From: "spol(at)mail(dot)ru" <spol(at)mail(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: HELP pls
Date: 2008-04-24 11:19:42
Message-ID: 48106CCE.7030701@mail.ru (view raw or flat)
Thread:
Lists: pgsql-bugs
how to dump it ???
pg_dump is not working :
pg_dump: query to obtain list of schemas failed: ERROR:  more than one 
row returned by a subquery used as an expression

Tom Lane пишет:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>   
>> spol(at)mail(dot)ru wrote:
>>     
>>> I don't know how, but i got 2 postgres users.
>>>       
>
>   
>> You've got transaction wraparound problems.  Start here:
>>     
>
> Vacuuming isn't gonna help though.  The tuple at (0,2) has been frozen,
> which means that vacuum has certainly been run on the table since the
> update; so he's wrapped around so far that vacuum doesn't think it can
> remove the (0,1) tuple.
>
> I assume the OP is just trying to dump this database so he can upgrade
> to something remotely modern.  It might work to change the second
> tuple's usesysid to something else (eg, 2) so that pg_dump doesn't
> see multiple rows matching other objects' owner fields.
>
> 			regards, tom lane
>
>
>   


In response to

pgsql-bugs by date

Next:From: Jacob ChamplinDate: 2008-04-24 16:37:10
Subject: BUG #4127: pg_dumpall -c unable to be restored without error
Previous:From: Kris JurkaDate: 2008-04-24 10:28:18
Subject: Re: Re: BUG #4123: Statement.setQueryTimeout does not work with Postgres Java Driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group