On Feb 2, 2018, at 12:38 PM, Peter Eisentraut <peter.eisentraut@xxxxxxxxxxxxxxx> 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 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. > Yep, ok thanks for confirming!