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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
