Re: BUG #4127: pg_dumpall -c unable to be restored without error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4127: pg_dumpall -c unable to be restored without error
Дата
Msg-id 585.1209055454@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #4127: pg_dumpall -c unable to be restored without error  ("Jacob Champlin" <jacobc@rentec.com>)
Ответы Re: BUG #4127: pg_dumpall -c unable to be restored without error  (Jacob Champlin <jacobc@rentec.com>)
Список pgsql-bugs
"Jacob Champlin" <jacobc@rentec.com> writes:
> psql -f restore.sql

> results in:

> psql:/var/lib/pgsql/backups/restore.sql:11: ERROR:  current user cannot be
> dropped
> psql:/var/lib/pgsql/backups/restore.sql:12: ERROR:  role "postgres" already
> exists
> psql:/var/lib/pgsql/backups/restore.sql:17: ERROR:  role "webapp" cannot be
> dropped because some objects depend on it
> DETAIL:  access to database rief
> 113 objects in database rief
> psql:/var/lib/pgsql/backups/restore.sql:18: ERROR:  role "webapp" already
> exists

And?  The restore would've proceeded anyway.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Jacob Champlin"
Дата:
Сообщение: BUG #4127: pg_dumpall -c unable to be restored without error
Следующее
От: Jacob Champlin
Дата:
Сообщение: Re: BUG #4127: pg_dumpall -c unable to be restored without error