How non-superuser can restore database containing procedures

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: How non-superuser can restore database containing procedures
Date: 2006-12-17 12:04:31
Message-ID: em3c6r$1s4k$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brendan Jurd 2006-12-17 13:15:34 Re: Functions on tables
Previous Message Yonatan Ben-Nes 2006-12-17 09:36:04 PDOStatement:closeCursor