On Tue, 2012-01-10 at 11:33 -0800, Tripura wrote: > I have a Postgresql database with 3 Schemas (2 user defined and 1 public). > > I have script that takes backup of the user defined schema's and then drops > the schema's. > > Now after doing some operations I want to restore the user defined schemas > from the schema backup(schema_backup.out). > > When I execute > cat schema_backup.out | psql xx_db_name_xx > > I am getting the following error message > ERROR: permission denied for database xx_db_name_xx > ERROR: schema "aaaa" does not exist > ERROR: permission denied for database xx_db_name_xx > ERROR: schema "bbbb" does not exist > ERROR: must be owner of database xx_db_name_xx > > When I execute the same command as Admin user its executing just fine. But, > when I execute as a 'xxxxxx' user its failing. > > Can someone guide me, what permissions/rights should be added to 'xxxxxx' to > restore the schema? >
He needs CREATE permission on the database. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
