restore database with schema: owner schema must have superuser privileges?
От
Pedro Salazar
Тема
restore database with schema: owner schema must have superuser
privileges?
Дата
Msg-id
1050915300.1050.15.camel@vitoria.intra.cet.pt
Список
Дерево обсуждения
restore database with schema: owner schema must have superuser
privileges? Pedro Salazar <pedro-b-salazar@ptinovacao.pt>
Re: restore database with schema: owner schema must have superuser privileges? Tom Lane <tgl@sss.pgh.pa.us>
Re: restore database with schema: owner schema must have Pedro Salazar <pedro-b-salazar@ptinovacao.pt>
Greetings, I have a database which has a schema owned by a user (with no superuser privileges). When restoring the dump file with my superuser database, the dump script connects with my owner user (which I created before), and tries to create the schema with that user, and of course it cannot do it, because my owner user hasn't super user privileges that permits create a schema! So, my question is, should the procedure to give temporary privileges of super user to the user that will be the owner of schema is a right procedure, or should the dump script provide to that operation be done with my super user database and only after that it would connect with the owner user? thanks, Pedro Salazar. -- PS pedro-b-salazar@ptinovacao.pt PGP:0E129E31D803BC61
В списке pgsql-admin по дате отправления