Thread: Ensure extension exists

I want to use the pgcrypto extension with a particular database. Does it exist permanently and survive a server reboot?
Orif not, how do you ensure it runs when the server restarts? 

I ask because in my Docker development environment I have to run it every time I restart the container, and just want
tobe prepared for production in AWS Aurora. 

Thanks,
Geoff

On 2/1/18 19:47, Geoffrey Hoffman wrote:
> I want to use the pgcrypto extension with a particular database. Does it exist permanently and survive a server
reboot?Or if not, how do you ensure it runs when the server restarts?
 

Once an extension is installed, it stays installed, just like any other
permanent database object such as tables and functions.

> I ask because in my Docker development environment I have to run it every time I restart the container, and just want
tobe prepared for production in AWS Aurora.
 

Maybe you have your development environment set up in a way that it
blows away your database on each run.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

On Feb 2, 2018, at 12:38 PM, Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote:
>
> On 2/1/18 19:47, Geoffrey Hoffman wrote:
>> I want to use the pgcrypto extension with a particular database. Does it exist permanently and survive a server
reboot?Or if not, how do you ensure it runs when the server restarts? 
>
> Once an extension is installed, it stays installed, just like any other
> permanent database object such as tables and functions.
>
>> I ask because in my Docker development environment I have to run it every time I restart the container, and just
wantto be prepared for production in AWS Aurora. 
>
> Maybe you have your development environment set up in a way that it
> blows away your database on each run.
>

Yep, ok thanks for confirming!