Well done Martin, your command worked! I'm not using anything like LDAP, I'm a home user and mine is the only user account, so I don't know why postgres wasn't in the ssl-cert group.
I can now start the database and run psql from the Applications, Other menu. Thanks very much for your efforts; I'll try not to pester you in future, but I can't guarantee it. Best regards, Ian --- On Sat, 13/6/09, Martin Pitt <[email protected]> wrote: From: Martin Pitt <[email protected]> Subject: [Bug 382584] Re: The PostgreSQL server failed to start: postgres not in ssl-cert group To: [email protected] Date: Saturday, 13 June, 2009, 2:54 PM Hah, that confirmed my suspicion: the postgres user isn't in the ssl- cert group. This is the default, though; are you using any LDAP/AD/other user management system or do you have any idea how postgres was thrown out of the ssl-cert group? To fix it locally, you can do sudo adduser postgres ssl-cert ** Summary changed: - The PostgreSQL server failed to start: server.key: Permission denied + The PostgreSQL server failed to start: postgres not in ssl-cert group -- The PostgreSQL server failed to start: postgres not in ssl-cert group 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: postgres not in ssl-cert group 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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
