From: Przemysław Nogaj <pn@tey.pl>
To: pgsql-admin@postgresql.org
Subject: pg_dumpall problem - duplicated users
Date: Thu, 25 Aug 2005 10:52:11 +0200
Message-ID: <430D86BB.90806@tey.pl> (raw)
Hi,
few days ago we made vacuum of all databases on our server. After that
we canot dump databases:
# pg_dumpall -i -U postgres > test.sql
pg_dump: query to obtain list of schemas failed: ERROR: More than one
tuple returned by a subselect used as an expression.
pg_dumpall: pg_dump failed on database "alibi", exiting
There are duplicated system users, pg_catalogs, pg_temp1, pg_toast and
public...
template1=> select * from pg_catalog.pg_shadow where usesysid = 1;
usename | usesysid | usecreatedb | usesuper | usecatupd
| passwd | valuntil | useconfig
----------+----------+-------------+----------+-----------+-------------------------------------+----------+-----------
postgres | 1 | t | t | t
| | |
postgres | 1 | t | t | t |
md5c084502ed11efa9d3d96d29717a5e555 | |
(2 rows)
Any suggestions how to solve the problem? There are many databases on
the server we can't loose. Applications can connect to databases - all
works fine, hoewer we must make dumps...
Thanks for any help,
Greetings
Przemek
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: pn@tey.pl
Subject: Re: pg_dumpall problem - duplicated users
In-Reply-To: <430D86BB.90806@tey.pl>
References: <430D86BB.90806@tey.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox