Search Postgresql Archives

Re: Error when building new db using pg_restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Jun 21, 2017 at 1:10 PM, Jim Longwill <JLongwill@xxxxxxxxx> 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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux