From: | Gastón <tango(at)allytech(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump ERROR, usename "postgres" duplicated |
Date: | 2009-12-28 21:21:48 |
Message-ID: | 4B39216C.60700@allytech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi:
I cannot dump any database from my server. When I try to do it i
receive this error
pg_dump: The command was: SELECT tableoid, oid, nspname, (select usename
from pg_user where nspowner = usesysid) as usename, nspacl FROM pg_namespace
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 |
******** | |
user1 | 101 | t | t | t |
******** | |
user2 | 102 | f | f | f |
******** | |
Anyone can tell me from where should I start?. This is an old
production server (version 8.0.8).
Regards.
--
Gastón Quiroga
Allytech S.A.
From | Date | Subject | |
---|---|---|---|
Next Message | matt | 2009-12-28 21:32:07 | parse tree in XML format |
Previous Message | John R Pierce | 2009-12-28 21:20:14 | Re: Java Postgres drivers. |