Re: Duplicate user in pg_shadow

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