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