Re: [GENERAL] Error when building new db using pg_restore

Поиск
Список
Период
Сортировка
Искать
От
David G. Johnston
Тема
Re: [GENERAL] Error when building new db using pg_restore
Дата
Msg-id
CAKFQuwardaaHVbZLX5yreYLJUZkF6VQAVhQ_Z-GD_8xAx-ptYg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
[GENERAL] Error when building new db using pg_restore Jim Longwill <JLongwill@psmfc.org>
Re: [GENERAL] Error when building new db using pg_restore Jerry Sievers <gsievers19@comcast.net>
Re: [GENERAL] Error when building new db using pg_restore Jim Longwill <JLongwill@psmfc.org>
Re: [GENERAL] Error when building new db using pg_restore "David G. Johnston" <david.g.johnston@gmail.com>
Re: [GENERAL] Error when building new db using pg_restore "David G. Johnston" <david.g.johnston@gmail.com>
Re: [GENERAL] Error when building new db using pg_restore Jim Longwill <JLongwill@psmfc.org>
Re: [GENERAL] Error when building new db using pg_restore Adrian Klaver <adrian.klaver@aklaver.com>
Re: [GENERAL] Error when building new db using pg_restore Jim Longwill <JLongwill@psmfc.org>
Re: [GENERAL] Error when building new db using pg_restore Adrian Klaver <adrian.klaver@aklaver.com>
On Wed, Jun 21, 2017 at 1:10 PM, Jim Longwill  wrote:

> Given this, I wonder how we can avoid this 'error' situation .. short of
> giving SUPERUSER
>     role to rradmin?  I tried just removing the '-v' flag from pg_restore,
> but the error is
>     still put in the log file (but nothing else is).

I believe the easiest solution, if you can at least get access to
superuser once, is to drop the comment from the source database
altogether.  That way it won't be dumped in the first place.  I'm not
sure the exact command you need to issue though - just recalling what
I've previously read on the topic.

David J.

В списке pgsql-general по дате отправления
От: Jim Longwill
Дата:
От: David G. Johnston
Дата:
FAQ