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 to 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.

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

Reply via email to