Ubuntu 14.04 64bit + postgresql 9.4 are used here; What I have done are:
1,Sign In ubuntu by user alex 2,then:sudo -i -u postgres 3,then:psql jump into command client 4,then: create database icare; 5,then: \q jump out command client 6,then run: exit jump out psql 7,then pg_restore --clean --create --exit-on-error --dbname=icare icare-test.tar On Fri, Nov 13, 2015 at 10:52 PM, Giuseppe Sacco < giuse...@eppesuigoccas.homedns.org> wrote: > Hello, > > Il giorno ven, 13/11/2015 alle 13.38 +0800, Alex Luya ha scritto: > > 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 what I understand, it means that the postgresql user that is > restoring the dump cannot create a schema on "icare" database. So, is > that user the same that issued che "create database" earlier? If it's > not, then you should grant all required priviledges to that user. > > Bye, > Giuseppe > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
