postgresql certificate files are in unexpected place

Bug #588970 reported by Jeffrey Baker on 2010-06-02
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
postgresql-8.4 (Ubuntu)
Undecided
Unassigned

Bug Description

Binary package hint: postgresql-8.4

postgresql-8.4 8.4.3-0ubuntu9.10.1 on Karmic amd64.

The certificate files are in /var/lib/postgresql/8.4/main/ however the config files are in /etc/postgresql/8.4/main. In the mainstream postgresql documentation seen at [1] and [2]

1: http://www.postgresql.org/docs/8.2/interactive/config-setting.html
2: http://www.postgresql.org/docs/8.2/interactive/ssl-tcp.html

... the upstream developers claim that both the config files and the SSL data is stored in "the data directory". Therefore a user familiar with postgresql operations would expect them to both be in the same place. This departure from upstream practice seems maddening, and in fact I just wasted half a day trying to figure out why the server wasn't using my certificates in /etc/postgresql/8.4/main.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers