Guess this shows my level of ignorance... $ id postgres uid=112(postgres) gid=115(postgres) groups=115(postgres)
Regards Ian --- On Sat, 13/6/09, Martin Pitt <martin.p...@ubuntu.com> wrote: From: Martin Pitt <martin.p...@ubuntu.com> Subject: Re: [Bug 382584] Re: The PostgreSQL server failed to start. To: ian.dav...@yahoo.com Date: Saturday, 13 June, 2009, 9:55 AM daviesi123 [2009-06-11 19:08 -0000]: > $ sudo ls -l /var/lib/postgresql/8.3/main/ id postgres Sorry, these are actually two lines. Can you please give me the output of id postgres ? > lrwxrwxrwx 1 root root 31 2009-05-01 10:08 root.crt -> > /etc/postgresql-common/root.crt > lrwxrwxrwx 1 root root 36 2009-05-01 10:08 server.crt -> > /etc/ssl/certs/ssl-cert-snakeoil.pem > lrwxrwxrwx 1 root root 38 2009-05-01 10:08 server.key -> > /etc/ssl/private/ssl-cert-snakeoil.key This looks alright, so it does use the snakeoil ssl certificate, which has correct permissions. Thanks, Martin -- Martin Pitt | http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- The PostgreSQL server failed to start: server.key: Permission denied https://bugs.launchpad.net/bugs/382584 You received this bug notification because you are a direct subscriber of the bug. Status in “postgresql-8.3” source package in Ubuntu: Incomplete Bug description: Binary package hint: postgresql-8.3 2009-06-01 23:19:56 BST FATAL: could not access private key file "server.key": Permission denied [fail] invoke-rc.d: initscript postgresql-8.3, action "start" failed. dpkg: error processing postgresql-8.3 (--configure): subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of postgresql: postgresql depends on postgresql-8.3; however: Package postgresql-8.3 is not configured yet. dpkg: error processing postgresql (--configure): dependency problems - leaving unconfigured Setting up python-zeroc-ice (3.3.0-14ubuntu1) ... No apport report written because the error message indicates its a followup error from a previous failure. ~$ lsb_release -rd Description: Ubuntu 9.04 Release: 9.04 $ apt-cache policy postgresql postgresql: Installed: 8.3.7-1 Candidate: 8.3.7-1 Version table: *** 8.3.7-1 0 500 http://gb.archive.ubuntu.com jaunty/main Packages 100 /var/lib/dpkg/status ProblemType: Package Architecture: i386 DistroRelease: Ubuntu 9.04 ErrorMessage: subprocess post-installation script returned error exit status 1 NonfreeKernelModules: nvidia Package: postgresql-8.3 8.3.7-1 SourcePackage: postgresql-8.3 Title: package postgresql-8.3 8.3.7-1 failed to install/upgrade: subprocess post-installation script returned error exit status 1 Uname: Linux 2.6.28-11-generic i686 -- The PostgreSQL server failed to start: server.key: Permission denied https://bugs.launchpad.net/bugs/382584 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
