Re: 9.0: plpgsql eror when restoring a database as a non superuser - Mailing list pgsql-general

From stefan
Subject Re: 9.0: plpgsql eror when restoring a database as a non superuser
Date
Msg-id j7v47i$e7e$1@dough.gmane.org
Whole thread Raw
In response to Re: 9.0: plpgsql eror when restoring a database as a non superuser  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: 9.0: plpgsql eror when restoring a database as a non superuser  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
>> Therefore the only solution I see is to drop plpgsql from template1, or
>> writing a wrapper script that exploits the -l and -L options of pg_restore.
>
> Yes. Though I could see an option to create a template database without plpgsql
> in it for use by non-superuser users and leave template1 as is.
>

Adrian,

Thanks for suggesting that. I had not thought about that option and it
may just be the best.

Cheers,
Stefan.



pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Are file system level differential/incremental backups possible?
Next
From: stefan
Date:
Subject: Re: 9.0: plpgsql eror when restoring a database as a non superuser