Re: Unable to start PostgreSQL from user other than root - Mailing list pgsql-admin

From Oliver Elphick
Subject Re: Unable to start PostgreSQL from user other than root
Date
Msg-id 200103021435.f22EZqG14746@linda.lfix.co.uk
Whole thread Raw
In response to Unable to start PostgreSQL from user other than root  (Silky Mittal <silky212001@yahoo.com>)
Responses Re: Unable to start PostgreSQL from user other than root  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-admin
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.Elphick@lfix.co.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



pgsql-admin by date:

Previous
From: Silky Mittal
Date:
Subject: Unable to start PostgreSQL from user other than root
Next
From: Oliver Vecernik
Date:
Subject: PL/pgSQL