[Pkg-postgresql-public] Bug#739923: postgresql-9.1: Upgrade failed because of missing server.key file

NOKUBI Takatsugu knok at daionet.gr.jp
Mon Feb 24 22:38:39 UTC 2014

At Mon, 24 Feb 2014 10:37:56 +0100,
Christoph Berg wrote:
> I don't think the problem is related to the upgrade, but rather a
> problem with the ssl keys used. What does the ?????? error message
> there say in English? I'd tend to this bit from
> src/backend/libpq/be-secure.c:
>         if (SSL_CTX_use_PrivateKey_file(SSL_context,
>                                         SERVER_PRIVATE_KEY_FILE,
>                                         SSL_FILETYPE_PEM) != 1)
>             ereport(FATAL,
>                     (errmsg("could not load private key file \"%s\": %s",
>                             SERVER_PRIVATE_KEY_FILE, SSLerrmessage())));
> "key values mismatch" itself is a message from openssl.

I tried to change locale as C, but the message was same as ?????,
it is the real question characters in Japanese/C locale.

> Possibly the server.crt and server.key files used have diverged since
> the PostgreSQL server was last restarted. Could you check if the files
> match?

I don't have server.* files in /etc/postgresql/9.1/main, I considered
postgresql refers the directory, is it correct?

More information about the Pkg-postgresql-public mailing list