Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Josh BerkusDate: 2003-10-30 04:56:35
Subject: Re: Postgresql vs OS compatibility matrix
Previous:From: Christopher BrowneDate: 2003-10-30 04:33:21
Subject: Re: Postgresql vs OS compatibility matrix

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group