Maybe you could delete one of the users from the pg_shadow table, do the
dump and then after the dump is restored, recreate the dropped user (and
it will get a new sysid)
Chris
CHEWTC@ap.nec.com.sg wrote:
> Hi
>
> When I do a SELECT * FROM pg_shadow, I can have more than one user with the same id. This caused the pg_dump to
> fail.
>
> I read that it happened in v7.1.2 and I am currently using v7.3.2 on Redhat v9.0
>
> What can be the causes and how do we rectify it?
>
>
>
>
> Thank you,
> REgards.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
