powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / pg_restore problems
2 сообщений из 2, страница 1 из 1
pg_restore problems
    #39167855
Бока
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
/usr/pgsql-9.4/bin/pg_restore -C -d reports reports-20160209.custom
Код: plsql
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



Что за проблемы и как их решить?
...
Рейтинг: 0 / 0
pg_restore problems
    #39168123
li_malina
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Бока,
нужно сначала на исходной базе выполнить
pg_dumpall --globals-only (роли и user)
восстановить их на новой базе
а потом выполнять восстановление на новую базу
...
Рейтинг: 0 / 0
2 сообщений из 2, страница 1 из 1
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / pg_restore problems
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]