help

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

Responses

  • Re: help at 2007-12-26 17:13:19 from Tom Lane

Browse pgsql-bugs by date

  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/