Re:

[Melvin Davidson <melvin6925@xxxxxxxxx>]

It is very simple. If you have already created database icare then

DO NOT use the -create flag!

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@xxxxxxxxx> 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.