Гость
Целевая тема:
Создать новую тему:
Автор:
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / pg_restore problems / 2 сообщений из 2, страница 1 из 1
10.02.2016, 17:28
    #39167855
Бока
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
pg_restore problems
/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
10.02.2016, 23:35
    #39168123
li_malina
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
pg_restore problems
Бока,
нужно сначала на исходной базе выполнить
pg_dumpall --globals-only (роли и user)
восстановить их на новой базе
а потом выполнять восстановление на новую базу
...
Рейтинг: 0 / 0
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / pg_restore problems / 2 сообщений из 2, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


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