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
]
<[EMAIL PROTECTED]cc: [EMAIL PROTECTED]
lth.com.au> Subject: Re: [PERFORM] Duplicate user
in pg_
[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
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
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.