simon007_个人页

德哥，谢谢你的回复。我shop库的owner也是postgres。 [postgres@node1 backup]$ psqlpsql (9.4.1)Type 'help' for help. postgres=# setAUTOCOMMIT = 'on'PROMPT1 = '%/%R%# 'PROMPT2 = '%/%R%# 'PROMPT3 = '>> 'VERBOSITY = 'default'VERSION = 'PostgreSQL 9.4.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit'DBNAME = 'postgres'USER = 'postgres'PORT = '5432'ENCODING = 'LATIN1'postgres=# l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges contrib_regression postgres UTF8 C C movies postgres UTF8 C C postgres postgres UTF8 C C re_bookstore postgres UTF8 C C shop postgres UTF8 C C supermarket postgres UTF8 C C template0 postgres UTF8 C C =c/postgres + postgres=CTc/postgres template1 postgres UTF8 C C postgres=CTc/postgres+ 我用pg_dump备份postrges库，依然出现同样的错误。 [postgres@node1 backup]$ pg_dump -Fc postgres > postgres.dumppg_dump: [archiver (db)] query failed: ERROR: schema 'pgs_distribution_metadata' does not existpg_dump: [archiver (db)] query was: COPY public.customer_reviews (customer_id, review_date, review_rating, review_votes, review_helpful_votes, product_id, product_title, product_sales_rank, product_group, product_category, product_subcategory, similar_product_ids) TO stdout; 麻烦你帮助详细解释一下该问题的发生原因及解决方案，谢谢！