Re: pg_dump ERROR, usename "postgres" duplicated - Mailing list pgsql-general

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:

Gastón Quiroga <gastonq@allytech.com> 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