permissions prevent server from starting

Bug #452268 reported by eurythmia
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
postgresql-8.3 (Ubuntu)
New
Undecided
Unassigned

Bug Description

Binary package hint: postgresql-8.3

user@host:~$ lsb_release -rd
Description: Ubuntu 9.04
Release: 9.04
user@host:~$ apt-cache policy postgresql-8.3
postgresql-8.3:
  Installed: 8.3.8-0ubuntu9.04
  Candidate: 8.3.8-0ubuntu9.04
  Version table:
 *** 8.3.8-0ubuntu9.04 0
        500 ftp://ftp.cs.mun.ca jaunty-updates/main Packages
        500 ftp://ftp.cs.mun.ca jaunty-security/main Packages
        100 /var/lib/dpkg/status
     8.3.7-1 0
        500 ftp://ftp.cs.mun.ca jaunty/main Packages

directory /var/lib/postgresql belongs to root:root
This is an issue because postgresql does not want to be started by root, so the default postgresql user is used in the "sudo /etc/init.d/postgresql8.3 start" command.
I was able to fix this issue on my machine by running:
"sudo chown postgres:postgres /var/lib/postgres -R"
The permissions should be set correctly upon package installation so that the server can be started without any workarounds.

Tags: packaging
eurythmia (acripps)
tags: removed: database
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.