Re: [PERFORM] Duplicate user in pg_shadow
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://www.postgresql.org/docs/7.3/static/sql-reindex.html Chris ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [PERFORM] Duplicate user in pg_shadow
Hi 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? Thank you, REgards. Christopher Kings-Lynne To: [EMAIL PROTECTED] <[EMAIL PROTECTED]cc: [EMAIL PROTECTED] lth.com.au> Subject: Re: [PERFORM] Duplicate user in pg_shadow 30/10/2003 12:24 PM 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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] Duplicate user in pg_shadow
[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 pg_shadow.usesysid. Are you certain the server isn't 7.1 or older? regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [PERFORM] 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 [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])