Re: pg_dump ERROR, usename "postgres" duplicated

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(at)allytech(dot)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
>
>