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
Ответ на
Re: [GENERAL] Error when building new db using pg_restore (Jim Longwill)
Список
Дерево обсуждения
[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
Дата: