Postgres Pro
Downloads
Home   >   mailing lists

How non-superuser can restore database containing procedures - Mailing list pgsql-general

From Andrus
Subject How non-superuser can restore database containing procedures
Date
Msg-id em3c6r$1s4k$1@news.hub.org
Whole thread Raw
Responses Re: How non-superuser can restore database containing procedures  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
I need to allow non-superusers to create and restore databases containing
plpgsql language procedures.
template0 and template1 do not have any languages installed.

During restore they receive error:

pg_restore: [archiver (db)] could not execute query: ERROR:  must be
superuser to create procedural language
    Command was: CREATE PROCEDURAL LANGUAGE plpgsql;

How to allow non-superusres to create database with language ?

Andrus.

pgsql-general by date:

Previous
From: Steve Castellotti
Date:
Subject: determining which table to lookup depending on data values
Next
From: Bob Pawley
Date:
Subject: Creating an Application