help

Started by spol@mail.ruover 18 years ago2 messagesbugs
Jump to latest
#1spol@mail.ru
spol@mail.ru

Hello.

Can you help me? i don't know what to do with this message:

**********************************************************************************************
# pg_dump -U postgres catalog
Password:
pg_dump: query to obtain list of schemas failed: ERROR: more than one
row returned by a subquery used as an expression
***********************************************************************************************

And i don't know why but there are dumplicate schemas:

***********************************************************************************************
# psql -U postgres template1
Password:
Welcome to psql 7.4.17, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

template1=# \dn;
List of schemas
Name | Owner
--------------------+----------
information_schema | postgres
information_schema | postgres
pg_catalog | postgres
pg_catalog | postgres
pg_temp_1 | postgres
pg_temp_1 | postgres
pg_toast | postgres
pg_toast | postgres
public | postgres
public | postgres
(10 rows)

template1=# \q
*************************************************************************************************

How can make Backup of my database ???

thx.
Oleg

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: spol@mail.ru (#1)
Re: help

"spol@mail.ru" <spol@mail.ru> writes:

And i don't know why but there are dumplicate schemas:

Duplicate pg_shadow rows for user postgres, most likely. When did
you last vacuum pg_shadow?

regards, tom lane