$ sudo ls -l /var/lib/postgresql/8.3/main/ id postgres ls: cannot access id: No such file or directory ls: cannot access postgres: No such file or directory /var/lib/postgresql/8.3/main/: total 40 drwx------ 7 postgres postgres 4096 2009-05-01 12:07 base drwx------ 2 postgres postgres 4096 2009-06-01 22:57 global drwx------ 2 postgres postgres 4096 2009-05-01 10:08 pg_clog drwx------ 4 postgres postgres 4096 2009-05-01 10:08 pg_multixact drwx------ 2 postgres postgres 4096 2009-05-01 10:08 pg_subtrans drwx------ 2 postgres postgres 4096 2009-05-01 10:08 pg_tblspc drwx------ 2 postgres postgres 4096 2009-05-01 10:08 pg_twophase -rw------- 1 postgres postgres 4 2009-05-01 10:08 PG_VERSION drwx------ 3 postgres postgres 4096 2009-05-22 23:58 pg_xlog -rw------- 1 postgres postgres 133 2009-06-01 22:45 postmaster.opts 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
Not sure I've done this right, but I hope this tells you what you need to know. Ian --- On Thu, 11/6/09, Martin Pitt <martin.p...@ubuntu.com> wrote: From: Martin Pitt <martin.p...@ubuntu.com> Subject: [Bug 382584] Re: The PostgreSQL server failed to start. To: ian.dav...@yahoo.com Date: Thursday, 11 June, 2009, 12:24 PM Thanks. Can you please give me the output of sudo ls -l /var/lib/postgresql/8.3/main/ id postgres ? Thanks! ** Changed in: postgresql-8.3 (Ubuntu) Status: Invalid => Incomplete ** Summary changed: - The PostgreSQL server failed to start. + The PostgreSQL server failed to start: server.key: Permission denied -- 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
