From: Alex Luya <alexander(dot)luya(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject:
Date: 2015-11-13 05:38:19
Message-ID: CAL6j_s9fdAXP9iLnNiHSeHnJvc1To6xOArDJK+S8HjBvoTVbKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

Responses

  • Re: at 2015-11-13 13:00:45 from James Keener
  • Re: at 2015-11-13 13:19:00 from Melvin Davidson
  • Re: at 2015-11-13 14:05:00 from Adrian Klaver
  • Re: at 2015-11-13 14:52:10 from Giuseppe Sacco

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2015-11-13 10:23:04 Re: Does PostgreSQL ever create indexes on its own?
Previous Message Adrian Klaver 2015-11-13 05:10:49 Re: pg_restore tells schema “test” already exists but it isn't actually