Re: Unable to start PostgreSQL from user other than root

Silky Mittal wrote:
>Dear Sir,
> We are running Linux 6.2 on our machine.

That is horribly old, full of bugs and sadly lacking in features.

> We are able to start postgresql on the root
>giving the command /etc/rc.d/init.d/postgresql start.
>But if we login as our own created user we are unable
>to start postgresql using the same command as above.It
>says No such file or directory.Help will be
>appreciated.

The postmaster should normally be started by the postgres administrator;
I suppose that the init.d script arranges this for you. It should not
be run by just any user. If you must do this, you probably need to add
something to the user's PATH or define some other environment variable.

If you want to find out more about what is happening, do

sh -x /etc/rc.d/init.d/postgresql start

which will trace each command in the script as it is executed.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"I will lift up mine eyes unto the hills, from whence
cometh my help. My help cometh from the LORD, which
made heaven and earth."
Psalms 121:1,2