| 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: | Whole Thread | Raw Message | 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;
| 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 |