Comment 14 for bug 391119

Revision history for this message
Don Bessinger (dbessinger) wrote :

I just updated my system again, and of course, the Postgresql failed. Now that you've shown me where to look, I dug around and see that none of the files in the /etc/postgresql/8.3/main are owned by postgres or are in the postgres group. that would certainly explain the failure to configure Postgresql during updates. Here's the directory listing:

:~$ ls -la /etc/postgresql/8.3/main
total 44
drwxr-xr-x 2 root root 4096 2009-02-22 14:33 .
drwxr-xr-x 3 root root 4096 2009-01-18 10:52 ..
-rw-r--r-- 1 root root 316 2009-01-18 10:52 environment
-rw-r----- 1 ntp ntp 3621 2009-01-18 10:52 pg_hba.conf
-rw-r----- 1 ntp ntp 1460 2009-01-18 10:52 pg_ident.conf
-rw-r--r-- 1 ntp ntp 16681 2009-02-22 14:28 postgresql.conf
-rw-r--r-- 1 root root 378 2009-01-18 10:52 start.conf

The update fails on trying to open the pg_hba.conf file. I'm attaching a .zip file with the directory listing output, the postgresql logs, and the update manager's term.log file. Thanks, and hope this helps.