Thread: help
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
"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