# Trouble bootstrapping with RDS --- could not open certificate file

**URL:** <https://meta.discourse.org/t/trouble-bootstrapping-with-rds-could-not-open-certificate-file/289367>\
**Category:** Self-hosting\
**Created:** [December 20, 2023, 8:24pm UTC](https://meta.discourse.org/t/trouble-bootstrapping-with-rds-could-not-open-certificate-file/289367 "2023-12-20T20:24:13Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [January 16, 2024, 7:24pm UTC](https://meta.discourse.org/t/trouble-bootstrapping-with-rds-could-not-open-certificate-file/289367/2 "2024-01-16T19:24:26Z")

</div>

Turns out, you need

```plaintext
env:
  PGSSLCERT: /tmp/postgresql.crt

```

I don’t know where I figured this out, but it’s in the yml for the staging site, but not the production one. And it worked just fine until recently. It’s bizarre, because the database migrated just fine, and didn’t fail until it started trying to precompile assets.;

---

_[View the full topic](https://meta.discourse.org/t/trouble-bootstrapping-with-rds-could-not-open-certificate-file/289367)._