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