i’m using timescaledb single HA helm chart to deploy on self hosted Kubernetes 3 node cluster:
I have configured backups to s3 bucket.
all is working
restore inside the cluster is working
I was trying to restore outside of the cluster using PGBackRest with the correct configurations from the same S3 bucket (poddb stanza)
for outside cluster I use the following docker image to deploy my Timescale DB via docker compose:
timescale/timescaledb:2.9.1-pg14
before restore I have turned down the timescale db server and cleared the db data directory
the pgbackrest restore is working, and I can see the backup files are now inside the db data directory
once I restart the timescale db service i get the following error:
FATAL: could not load server certificate file “/etc/certificate/tls.crt”: SSL error code 2147483650
this is the full log:
C:\nms_git\enc\modules\gnss\docker>docker compose -f docker-compose-db.yml up
docker-fnm_sync_pm_timescaledb-1 | PostgreSQL Database directory appears to contain a database; Skipping initialization
docker-fnm_sync_pm_timescaledb-1 |
docker-fnm_sync_pm_timescaledb-1 | 2023-06-29 10:28:12.018 GMT [1] LOG: skipping missing configuration file “/var/run/postgresql/timescaledb.conf”
docker-fnm_sync_pm_timescaledb-1 | 2023-06-29 10:28:12.019 GMT [1] LOG: skipping missing configuration file “/var/run/postgresql/timescaledb.conf”
docker-fnm_sync_pm_timescaledb-1 | 2023-06-29 10:28:12 UTC [1]: [649d5cbc.1-3] @,app= [F0000] FATAL: could not load server certificate file “/etc/certificate/tls.crt”: SSL error code 2147483650
docker-fnm_sync_pm_timescaledb-1 | 2023-06-29 10:28:12 UTC [1]: [649d5cbc.1-4] @,app= [00000] LOG: database system is shut down
docker-fnm_sync_pm_timescaledb-1 exited with code 1
Can you please help to find out the problem?
thanks,
Ziv