From: | James Keener <jim(at)jimkeener(dot)com> |
---|---|
To: | Alex Luya <alexander(dot)luya(at)gmail(dot)com>,pgsql-general(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2015-11-13 13:00:45 |
Message-ID: | C6A2E1AF-08C1-4FF4-8BBB-E6715006D07A@jimkeener.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Who were you logged I to psql as? Does the dump switch users?
On November 13, 2015 12:38:19 AM EST, Alex Luya <alexander(dot)luya(at)gmail(dot)com> 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;
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2015-11-13 13:19:00 | Re: |
Previous Message | Albe Laurenz | 2015-11-13 11:49:09 | Re: Does PostgreSQL ever create indexes on its own? |