Re: [GENERAL] pg_dump ERROR, usename "postgres" duplicated

[Gastón]

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?= <gast...@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