Backup manager install script throws error "Certificate verification failed"

English Forum Questions
1

Hello, I am trying to follow the instructions below for Postgres:
https://docs.nocobase.com/handbook/backups#installation

However, when I check the logs I get an error about an unknown certificate. Any idea how to fix this?

| Running /app/nocobase/storage/scripts/install-database-client.sh
app-1 | pg_dump is not installed, starting PostgreSQL client installation…
app-1 | Hit:1 Index of /debian bookworm InRelease
app-1 | Hit:2 Index of /debian bookworm-updates InRelease
app-1 | Hit:3 Index of /debian-security bookworm-security InRelease
app-1 | Ign:4 Index of /pub/repos/apt/ bookworm-pgdg InRelease
app-1 | Ign:4 Index of /pub/repos/apt/ bookworm-pgdg InRelease
app-1 | Ign:4 Index of /pub/repos/apt/ bookworm-pgdg InRelease
app-1 | Err:4 Index of /pub/repos/apt/ bookworm-pgdg InRelease
app-1 | Certificate verification failed: The certificate is NOT trusted. The certificate issuer is unknown. Could not handshake: Error in the certificate verification. [IP: 146.75.39.52 443]

2

Hi, The error is caused by missing trusted root certificates in the Docker container, which prevents it from verifying the PostgreSQL package source.

To fix this, please enter your container and run the following command to install the CA certificates:

apt-get update && apt-get install -y ca-certificates

After that, try running the installation script again. It should work without certificate errors.

3

Great that worked, thank you!