From: | "spol(at)mail(dot)ru" <spol(at)mail(dot)ru> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | help |
Date: | 2007-12-26 15:02:56 |
Message-ID: | 47726D20.6010806@mail.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-12-26 17:13:19 | Re: help |
Previous Message | Andrey | 2007-12-26 09:20:05 | BUG #3840: Termination of postgresql/ |