PostgreSQL stalling at boot
Russell Davie
rjrd at exemail.com.au
Tue May 30 08:36:59 UTC 2006
Hi All
I'm getting a error when PostgreSQL starts.
as root:
XXX at XXXX:~$ sudo /etc/init.d/postgresql-7.4 start
* Starting PostgreSQL 7.4 database server:main
pg_ctl: cannot be run as root
Please log in (using, e.g., "su") as the (unprivileged) user that will
own the server process. [fail]
and as the postgres user:
postgres at nutz:~$ /etc/init.d/postgresql-7.4 start
chmod: changing permissions of `/var/run/postgresql': Operation not
permitted
* Starting PostgreSQL 7.4 database server:main
Error: Could not change user id [fail]
This error message is in the start-up script /usr/share/postgresql-common/PgCommon.pm and its seems to be checking for group membership of "shadow" group.
The user "postgres" is a member of the shadow group and still the error occurs.
What can be done to correct this?
TIA
Russell
More information about the ubuntu-users
mailing list