X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E5BF9D1B500 for ; Thu, 30 Oct 2003 04:27:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 74931-04 for ; Thu, 30 Oct 2003 00:26:49 -0400 (AST) Received: from necsin-fw.nec.com.sg (necsin-fw.nec.com.sg [203.127.255.1]) by svr1.postgresql.org (Postfix) with ESMTP id D3B29D1B4FE for ; Thu, 30 Oct 2003 00:26:47 -0400 (AST) Received: from kato.nec.com.sg (kato.nec.com.sg [203.127.254.2]) by necsin-fw.nec.com.sg with ESMTP id h9U4Qbh0003468; Thu, 30 Oct 2003 12:26:40 +0800 (SGT) Received: from necsind1.nec.com.sg ([203.127.252.220]) by kato.nec.com.sg with ESMTP id h9U4QbJT027448; Thu, 30 Oct 2003 12:26:37 +0800 (SGT) Subject: Re: Duplicate user in pg_shadow To: Christopher Kings-Lynne Cc: pgsql-performance@postgresql.org X-Mailer: Lotus Notes Release 5.0.5 September 22, 2000 Message-ID: From: CHEWTC@ap.nec.com.sg Date: Thu, 30 Oct 2003 12:26:43 +0800 X-MIMETrack: Serialize by Router on NECSIND1/WTC/NECSIN(Release 5.0.12 |February 13, 2003) at 10/30/2003 12:26:44 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/746 X-Sequence-Number: 4494 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: CHEWTC@ap.nec.com.sg 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 CHEWTC@ap.nec.com.sg 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