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.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
