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
