[Users] New engine install on remote DB fails "uuid-ossp extension is not loaded"

[Ian Levesque]

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