agora inbox for pgsql-general@postgresql.org  
help / color / mirror / Atom feed
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-general@lists.postgresql.org
Subject: Re: Error Creating pgcrypto Extension
Date: Fri, 18 Sep 2026 16:43:38 +0200
Message-ID: <aq1OGrfSA2gYBH40@hermes.hilbert.loc> (raw)
In-Reply-To: <PH0PR05MB9987163C3B636557679E714DEC81872@PH0PR05MB998716.namprd05.prod.outlook.com>
References: <BYAPR05MB6632AA793C3F51F016FE752EEEB82@BYAPR05MB6632.namprd05.prod.outlook.com>
	<CAKFQuwaCnT854sPzRJGnO83ReCtKoi9DcFxj0cxBe617uZbxaA@mail.gmail.com>
	<947662.1789689902@sss.pgh.pa.us>
	<BE670ABC-CF65-4811-9E23-61031609D160@yesql.se>
	<PH0PR05MB9987163C3B636557679E714DEC81872@PH0PR05MB998716.namprd05.prod.outlook.com>

Am Fri, Sep 18, 2026 at 02:33:33PM +0000 schrieb Phil Rau:

> The question now becomes:  Is there a way to set up an instance such that any new databases created underneath it automatically get a given extension (in this case pgcrypto)?  What is the best practice to do this?

Isn't the canonical way for that to install it into a
template database from which new databases get created
eventually ?

Karsten
-- 
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B





view thread (9+ messages)  latest in thread

Message-ID: <aq1OGrfSA2gYBH40@hermes.hilbert.loc>
Permalink:  ../aq1OGrfSA2gYBH40@hermes.hilbert.loc/
Also on:    postgresql.org/message-id/aq1OGrfSA2gYBH40@hermes.hilbert.loc

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: Karsten.Hilbert@gmx.net, pgsql-general@lists.postgresql.org
  Subject: Re: Error Creating pgcrypto Extension
  In-Reply-To: <aq1OGrfSA2gYBH40@hermes.hilbert.loc>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox