Re: pg_dump ERROR, usename "postgres" duplicated

[Gastón <tango@xxxxxxxxxxxx>]

Thanks for your reply Tom, and sorry for the duplicated e-mails.

It's Postgres version 8.0.8


Thank you

Gastón Quiroga
Allytech S.A.

Tom Lane wrote:

=?ISO-8859-1?Q?Gast=F3n_Quiroga?= <gastonq@xxxxxxxxxxxx> writes:
  

    I checked the pg_user database and I found this:
    

postgres=# select * from pg_user;
    usename    | usesysid | usecreatedb | usesuper | usecatupd |  
passwd  | valuntil | useconfig
---------------+----------+-------------+----------+-----------+----------+----------+-----------
 postgres      |        1 | t           | t        | t         | 
******** |          |
 postgres      |        1 | t           | t        | t         | 
******** |          |
 administrador |      100 | t           | t        | t         | 
******** |          |
    

What PG version is that?  (Apparently pre-8.1, but what exactly?)

It would be useful to look at the underlying table:

	select ctid,xmin,xmax,* from pg_shadow;

			regards, tom lane