Re: Remove duplicated row in pg_largeobject_metadata

From: Tobias Meyer <t9m(at)qad(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Remove duplicated row in pg_largeobject_metadata
Date: 2021-09-23 10:49:54
Message-ID: CAAEpUZnsp=PZMESAJ-qq+yvrLDVo3fS9ggQZNOCsqFdps03GvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
>
> Interesting. Can you nail down the software versions that were in
> use here? That'd be the old PG server version upgraded from, the
> new server version upgraded to, the versions of pg_upgrade and
> pg_dump (these probably should match the new server version, but
> I'm not certain we enforce that), and the pg_upgradecluster
> script version?
>

Well, it was an upgrade from 9.5 to 10. Unfortunately I can't pin down any
other or more exact versions any longer.
The command we used was "pg_upgradecluster 9.5 main -m upgrade -k -v 10"

Regards, Tobias

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ryan Booz 2021-09-23 12:34:54 Re: Faster distinct query?
Previous Message hubert depesz lubaczewski 2021-09-23 07:04:35 Re: Faster distinct query?