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 Champlin||Date: 2008-04-24 16:37:10|
|Subject: BUG #4127: pg_dumpall -c unable to be restored without error|
|Previous:||From: Kris Jurka||Date: 2008-04-24 10:28:18|
|Subject: Re: Re: BUG #4123: Statement.setQueryTimeout does not work
with Postgres Java Driver|