/usr/pgsql-9.4/bin/pg_restore -C -d reports reports-20160209.custom
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
...
pg_restore: [archiver (db)] could not execute query: ERROR: role "pg_admin" does not exist
Command was: REVOKE ALL ON SEQUENCE reports_report_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE reports_report_id_seq FROM pg_admin;
GRANT ...
pg_restore: [archiver (db)] Error from TOC entry 45072; 0 0 ACL time_windows_ pg_admin
pg_restore: [archiver (db)] could not execute query: ERROR: relation "time_windows_" does not exist
Command was: REVOKE ALL ON TABLE time_windows_ FROM PUBLIC;
REVOKE ALL ON TABLE time_windows_ FROM pg_admin;
GRANT ALL ON TABLE time_wind...
pg_restore: [archiver (db)] Error from TOC entry 45073; 0 0 ACL time_windows pg_admin
pg_restore: [archiver (db)] could not execute query: ERROR: relation "time_windows" does not exist
Command was: REVOKE ALL ON TABLE time_windows FROM PUBLIC;
REVOKE ALL ON TABLE time_windows FROM pg_admin;
GRANT ALL ON TABLE time_window...
pg_restore: [archiver (db)] Error from TOC entry 45074; 0 0 ACL tmp_normalized_times pg_admin
pg_restore: [archiver (db)] could not execute query: ERROR: role "pg_admin" does not exist
Command was: REVOKE ALL ON TABLE tmp_normalized_times FROM PUBLIC;
REVOKE ALL ON TABLE tmp_normalized_times FROM pg_admin;
GRANT ALL ON T...
pg_restore: [archiver (db)] Error from TOC entry 45075; 0 0 ACL v_sch pg_admin
pg_restore: [archiver (db)] could not execute query: ERROR: role "pg_admin" does not exist
Command was: REVOKE ALL ON TABLE v_sch FROM PUBLIC;
REVOKE ALL ON TABLE v_sch FROM pg_admin;
GRANT ALL ON TABLE v_sch TO pg_admin;
GRANT ...
pg_restore: [archiver (db)] Error from TOC entry 45076; 0 0 ACL views pg_admin
pg_restore: [archiver (db)] could not execute query: ERROR: relation "views" does not exist
Command was: REVOKE ALL ON TABLE views FROM PUBLIC;
REVOKE ALL ON TABLE views FROM pg_admin;
GRANT ALL ON TABLE views TO pg_admin;
GRANT ...
pg_restore: [archiver (db)] Error from TOC entry 45078; 0 0 ACL views_view_id_seq pg_admin
pg_restore: [archiver (db)] could not execute query: ERROR: role "pg_admin" does not exist
Command was: REVOKE ALL ON SEQUENCE views_view_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE views_view_id_seq FROM pg_admin;
GRANT ALL ON S...
WARNING: errors ignored on restore: 12919
Что за проблемы и как их решить?