Re:

On 11/13/2015 05:19 AM, Melvin Davidson wrote:
> It is very simple. If you have already created database icare then
> DO NOT use the -create flag!

You can do that, you just cannot do that when the database you are
connecting to, --dbname=icare, is the one you want to create. I use
--dbname=postgres to connect to the system database postgres and have
pg_restore then clean/create the intended database from there. In this
case the database does not seem to be the issue. The problem is when
pg_restore starts trying to create SCHEMA in the database.

>
> http://www.postgresql.org/docs/9.2/interactive/app-pgrestore.html
>
> And as requested before, please provide the O/S and PostgreSQL version.
>
> On Fri, Nov 13, 2015 at 12:38 AM, Alex Luya <alexander.luya@gmail.com
> <mailto:alexander.luya@gmail.com>> wrote:
>
>     Hello,
>             I created a new database by
>
>             create database icare;
>
>             then quit off psql and  run:
>              pg_restore --clean --create --exit-on-error --dbname=icare
>     icare-test.tar
>
>               it complains:
>
>                pg_restore: [archiver (db)] Error while PROCESSING TOC:
>                pg_restore: [archiver (db)] Error from TOC entry 21; 2615
>     80924 SCHEMA icare icare
>                pg_restore: [archiver (db)] could not execute query:
>     ERROR:  permission denied for database icare
>                 Command was: CREATE SCHEMA icare;
>
>
>
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize.  Whether or not you
> wish to share my fantasy is entirely up to you.


--
Adrian Klaver
adrian.klaver@aklaver.com