On Aug 15, 2012, at 3:50 AM, Alex Lourie wrote: > Hi Ian > > You're right in that superuser privileges are required to make this work. But > it would rarely happen that remote DB admin would give you a user with super > privileges. The solution we've come up with is this: > > 1. Use (or tell remote DB admin to do so) the psql command to load the > extension functions to template1 DB on remote DB server: > psql -U postgres -d template1 -f /usr/share/pgsql/contrib/uuid-ossp.sql > 2. Now, all newly created databases will include extension functions. > > template1 is a special DB in postgres. In fact, when you create a new DB, it > is actually copied from template1 with a new name. > > This way, we can still work with the user that has no superuser privileges in > the remote DB server.
Thanks for your reply. Though, to be fair, a DB admin might also object to including the uuid-ossp extension functions by default on the template DB. That said, it's certainly preferred over full superuser privs :) Cheers, Ian _______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
