| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Geoffrey Hoffman <geoffrey(dot)hoffman(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Ensure extension exists |
| Date: | 2018-02-02 19:38:45 |
| Message-ID: | 67cf532f-f608-a94e-757e-8a1ba928d0bd@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | geoff hoffman | 2018-02-02 19:40:53 | Re: Ensure extension exists |
| Previous Message | Peter Eisentraut | 2018-02-02 19:36:25 | Re: Unexpected ErrorMessage reply to SSLRequest |