PostgreSQL stalling at boot

Russell Davie rjrd at exemail.com.au
Tue May 30 14:22:07 UTC 2006


On Tue, 30 May 2006 18:36:59 +1000
Russell Davie <rjrd at exemail.com.au> wrote:

> 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? 
> 

should have included running Ubuntu Breezy
PostgreSQL can't be used or backed up and, more importantly, making it difficult choice to stay with Breezy or upgrade to Dapper and trash the PostgreSQL data ..:-(
TIA
- R




More information about the ubuntu-users mailing list