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