Re: Duplicate user in pg_shadow

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: CHEWTC(at)ap(dot)nec(dot)com(dot)sg
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Duplicate user in pg_shadow
Date: 2003-10-30 04:37:41
Message-ID: 3FA09595.5020905@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-10-30 04:56:35 Re: Postgresql vs OS compatibility matrix
Previous Message Christopher Browne 2003-10-30 04:33:21 Re: Postgresql vs OS compatibility matrix