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
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
