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:
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.
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.