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:24:50
Message-ID: 3FA09292.2050906@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)ap(dot)nec(dot)com(dot)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


In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2003-10-30 04:26:06
Subject: Re: Duplicate user in pg_shadow
Previous:From: Greg StarkDate: 2003-10-30 04:19:58
Subject: Re: PostgreSQL 7.4beta5 vs MySQL 4.0.16 with RT(DBIx::SearchBuilder)

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