Re: [PERFORM] Duplicate user in pg_shadow

[Christopher Kings-Lynne]

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

[EMAIL PROTECTED] 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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])