Обсуждение: Duplicate user in pg_shadow

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.

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

CHEWTC@ap.nec.com.sg 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 pg_shadow.usesysid.  Are you certain the server isn't 7.1 or
older?

            regards, tom lane

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
                
                      <chriskl@familyhea        cc:       pgsql-performance@postgresql.org
                
                      lth.com.au>               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

> 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