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?
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public