暂无个人介绍
德哥,谢谢你的回复。
我shop库的owner也是postgres。
[postgres@node1 backup]$ psql
psql (9.4.1)
Type "help" for help.
postgres=# set
AUTOCOMMIT = '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.dump
pg_dump: [archiver (db)] query failed: ERROR: schema "pgs_distribution_metadata" does not exist
pg_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;
麻烦你帮助详细解释一下该问题的发生原因及解决方案,谢谢!