Meltano

<https://meltano.slack.com/archives/CMN8HELB0/p1638816044141900>

Hi <@U06CBMH2BDZ>! I think it'll look for the certificate in the default dir, that is `~/.postgresql/root.crt` if you're on Linux/Mac. See <https://www.postgresql.org/docs/14/libpq-ssl.html>.

Google Cloud SQL <https://cloud.google.com/sql/docs/postgres/configure-ssl-instance|gives me 3 files>:
```A server certificate saved as server-ca.pem.
A client public key certificate saved as client-cert.pem.
A client private key saved as client-key.pem.```
Which one do I rename `root.crt`?

I think `server-ca.pem` is the one:
```psql "sslmode=verify-ca sslrootcert=server-ca.pem \
      sslcert=client-cert.pem sslkey=client-key.pem \
      hostaddr=INSTANCE_IP \
      user=postgres dbname=DB_NAME"```
Source: <https://cloud.google.com/sql/docs/postgres/connect-admin-ip#connect>

trying:
```server-ca.pem -&gt; root.crt
client-key.pem -&gt; postgresql.key
client-cert.pem -&gt; postgresql.crt```

didn’t work, I get this if `ssl: true`, it works otherwise if `ssl: false`
```ELT could not be completed: Cannot start extractor: Catalog discovery failed: command ['/Users/dlyons/Documents/brigit-m
eltano/plaid_transactions_2020_04_a/.meltano/extractors/production-db-brigit--plaid_transactions_2020_04_a/venv/bin/tap-
postgres', '--config', '/Users/dlyons/Documents/brigit-meltano/plaid_transactions_2020_04_a/.meltano/run/elt/2020_04_a/1
7a628e6-1e6a-48b0-be97-71efbc8db916/tap.ca41b643-642f-4c03-a6b8-1c82e89bf040.config.json', '--state', '/Users/dlyons/Doc
uments/brigit-meltano/plaid_transactions_2020_04_a/.meltano/run/elt/2020_04_a/17a628e6-1e6a-48b0-be97-71efbc8db916/state
.json', '--discover'] returned 1 ```

fixed it, somehow missed the `.` in `.postgresql` sorry about that!