- Mailing list pgsql-general

From Alex Luya
Subject
Date
Msg-id CAL6j_s9fdAXP9iLnNiHSeHnJvc1To6xOArDJK+S8HjBvoTVbKg@mail.gmail.com
Whole thread Raw
Responses Re:
Re:
Re:
Re:
List 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;

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_restore tells schema “test” already exists but it isn't actually
Next
From: Albe Laurenz
Date:
Subject: Re: Does PostgreSQL ever create indexes on its own?