[Pkg-postgresql-public] Bug#698958: /usr/bin/pg_upgradecluster: does not copy X.509 key/cert

Timo Weingärtner timo at tiwe.de
Fri Jan 25 17:57:58 UTC 2013


Package: postgresql-common
Version: 134wheezy2
Severity: normal
File: /usr/bin/pg_upgradecluster

I just upgraded a cluster from 8.4 to 9.1 using pg_upgradecluster. Connecting
to it using psql then threw the message "psql: SSL error: certificate verify
failed". Of course I have sslmode=verify-full in .pg_service.conf.

I found out that the symlinks /var/lib/postgresql/8.4/$cluster/server.* were
not copied to the new cluster, but symlinks to snakeoil stuff put there
instead.

Please just cp $old_cluster_dir/server.* $new_cluster_dir if they exist.


Greetings
Timo



More information about the Pkg-postgresql-public mailing list