Re:

Adrian Klaver <adrian.klaver@xxxxxxxxxxx> · Fri, 13 Nov 2015 06:05:00 -0800

On 11/12/2015 09:38 PM, Alex Luya 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

Please show the pg_backup script that created icare-test.tar

Also in the database you are dumping from, in psql, what is the output from:

\l
\dn

          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;

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

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