Comment 6 for bug 225125

Hello

 Am trying to install openbravoERP (it needs postgresql) on Kubuntu 8.4.
Through adept manager, I installed postgresql 8.3.

Initially it would not recognise postgres as a user - following tips on the internet
I had to change the following line in the folder /etc/postgres/8.3/main
and in file pg_hba.conf - replaced
the line 'local all all ident sameuser' with 'local all all md5'

 Though the K Menu ->SystemServices->Advanced->SystemServices I notice
that though postgres is part of the init.d script to start automatically on boot, it is not running.

When I try to restart it, I get the following message:
 * Starting PostgreSQL 8.3 database server
 * The PostgreSQL server failed to start. Please check the log output:
2008-06-09 18:39:40 IST FATAL: could not access private key file "server.key": Permission denied
   ...fail!

I googled on the above and searched postgresforum to come across your post here ... and followed some
instructions on changing the permissions on the server.key file under /etc/ssl_cert/private. However
it did not work for me.

Here is a clip of my window:
======================
root@Ananda:/var/lib/postgresql/8.3/main# chmod 740 server.key
root@Ananda:/var/lib/postgresql/8.3/main# ls -l
total 40
drwx------ 5 postgres postgres 4096 2008-06-07 18:21 base
drwx------ 2 postgres postgres 4096 2008-06-09 15:56 global
drwx------ 2 postgres postgres 4096 2008-06-07 18:21 pg_clog
drwx------ 4 postgres postgres 4096 2008-06-07 18:21 pg_multixact
drwx------ 2 postgres postgres 4096 2008-06-07 18:21 pg_subtrans
drwx------ 2 postgres postgres 4096 2008-06-07 18:21 pg_tblspc
drwx------ 2 postgres postgres 4096 2008-06-07 18:21 pg_twophase
-rw------- 1 postgres postgres 4 2008-06-07 18:21 PG_VERSION
drwx------ 3 postgres postgres 4096 2008-06-07 18:21 pg_xlog
-rw------- 1 postgres postgres 125 2008-06-09 15:15 postmaster.opts
lrwxrwxrwx 1 root root 31 2008-06-07 18:21 root.crt -> /etc/postgresql-common/root.crt
lrwxrwxrwx 1 root root 36 2008-06-07 18:21 server.crt -> /etc/ssl/certs/ssl-cert-snakeoil.pem
lrwxrwxrwx 1 root root 38 2008-06-07 18:21 server.key -> /etc/ssl/private/ssl-cert-snakeoil.key
root@Ananda:/var/lib/postgresql/8.3/main# ls -l /etc/ssl/private/ssl-cert-snakeoil.key
-rwxr----- 1 root ssl-cert 891 2008-05-28 16:19 /etc/ssl/private/ssl-cert-snakeoil.key
root@Ananda:/var/lib/postgresql/8.3/main# /etc/init.d/postgresql-8.3 start
 * Starting PostgreSQL 8.3 database server * The PostgreSQL server failed to start. Please check the log output:
2008-06-09 18:34:12 IST FATAL: could not access private key file "server.key": Permission denied

==================

what should I do to get postgresql 8.3 running on my system?

Thanks
Ddrake

PS: Hardware config (Acer aspire 4710 - core2duo, 2GB RAM, 160 GB hd)