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
