Re: [PERFORM] Duplicate user in pg_shadow

2003-10-29 Thread Christopher Kings-Lynne
I tried to delete the user from the pg_user but couldnt. This username is being duplicated so we have the same 2 records. What is the cause ? Is it due to memory or wrong configuration? Maybe it's an index corruption issue. Try reindexing the pg_shadow table, based on the instructions here: http

Re: [PERFORM] Duplicate user in pg_shadow

2003-10-29 Thread CHEWTC
] <[EMAIL PROTECTED]cc: [EMAIL PROTECTED] lth.com.au> Subject: Re: [PERFORM] Duplicate user in pg_

Re: [PERFORM] Duplicate user in pg_shadow

2003-10-29 Thread Tom Lane
[EMAIL PROTECTED] writes: > 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 This is *real* hard to believe. Versions 7.2 and later have a unique index on

Re: [PERFORM] Duplicate user in pg_shadow

2003-10-29 Thread 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

[PERFORM] Duplicate user in pg_shadow

2003-10-29 Thread CHEWTC
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.