Download the .pem file endpoint

PostgreSQL
1

Hi! I was wondering if there is an endpoint for the ca.pem file to download for a postgres database. I know there is a button, but I want to include this endpoint in a deployment pipeline.

2

Hi! You can fetch the ca cert programmatically via API or Aiven Cli, more info for the Api call here Aiven API Documentation

3

Hi! I tried and I am getting this error:

{
    "errors": [
        {
            "message": "No such service CA named 'ca.pem'",
            "status": 404
        }
    ],
    "message": "No such service CA named 'ca.pem'"
}

I have no idea what the certificate is named since there is no name set to it and no instructions on how should I get it.

4

Indeed, I’ll flag this issue internally. In the meantime you can download the ca.pem content via the project CA call

curl --request GET \
    --url https://api.aiven.io/v1/project/<PROJECT_NAME>/kms/ca \
    --header 'Authorization: Bearer <AUTH_TOKEN>'

As mentioned in Aiven API Documentation