pg_dump ERROR, usename "postgres" duplicated

From: Gastón Quiroga <gastonq(at)allytech(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: pg_dump ERROR, usename "postgres" duplicated
Date: 2009-12-28 20:44:21
Message-ID: 4B3918A5.7050408@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 a production
server.

Regards.

--
Gastón Quiroga

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gastón 2009-12-28 21:03:06 pg_dump ERROR, usename "postgres" duplicated
Previous Message Raymond O'Donnell 2009-12-28 20:27:32 Re: pg_dump excluding tables content but not table schema