Postgres Pro
Downloads
Home   >   mailing lists

Thread: Unable to start PostgreSQL from user other than root

Unable to start PostgreSQL from user other than root

From
Silky Mittal
Date:
Dear Sir,
      We are running Linux 6.2 on our machine.
      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.
Thanking You,
Regards,
Silky.

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

Re: Unable to start PostgreSQL from user other than root

From
"Oliver Elphick"
Date:
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

RE: Unable to start PostgreSQL from user other than root

From
Michael Ansley
Date:

>> 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.
I suspect that Silky meant RH 6.2, not PG 6.2.

>>   >      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.
Although the postgres user should be used to start the postmaster, the RH init script can only be called by root.  The script su's to postgres to start, though.

Unless Silky does not have access to root, or specifically requires dev access to start and stop postgres, I would suggest leaving it as it is, and getting postgres started on boot.

Cheers...

MikeA

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
Nick West - Global Infrastructure Manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

Re: Unable to start PostgreSQL from user other than root

From
Samuel Tardieu
Date:
On  2/03, Michael Ansley wrote:

| >> 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.
| I suspect that Silky meant RH 6.2, not PG 6.2.

Doesn't that apply to RH 6.2 as well? :)

  Sam

PS/ sorry for the noise, couldn't help

Re: Unable to start PostgreSQL from user other than root

From
"Oliver Elphick"
Date:
"Oliver Elphick" wrote:
  >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.

Oh no; I read that as PostgreSQL 6.2.

But Linux 6.2 is a misnomer any way - I suppose you mean Red Hat.

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

Computer with Linux OS not shown on Computers with Windows OS

From
Silky Mittal
Date:
Dear Sir,
      Thanks for your precious advice now things have
started working but now we are facing other problem.
When we give the command "nmblookup -d 2 '*' it shows
IP address of some of the computers in the network and
not all and also when we check in network
neighbourhood of other computers having Win95 OS our
Linux computer is not shown.Looking forward for the
early response . Help will be appreciated.
Thanking You,
Regards,
Silky.
--- Oliver Elphick <olly@lfix.co.uk> wrote:
> "Oliver Elphick" wrote:
>   >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.
>
> Oh no; I read that as PostgreSQL 6.2.
>
> But Linux 6.2 is a misnomer any way - I suppose you
> mean Red Hat.
>
> --
> 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
>
>


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

Re: Computer with Linux OS not shown on Computers with Windows OS

From
Dave Millen
Date:
If you want to see your linux box in network neighbourhood, you have to
run samba on the linux box!

See: http://www.samba.org

regards,
Dave

Silky Mittal wrote:
>
> Dear Sir,
>       Thanks for your precious advice now things have
> started working but now we are facing other problem.
> When we give the command "nmblookup -d 2 '*' it shows
> IP address of some of the computers in the network and
> not all and also when we check in network
> neighbourhood of other computers having Win95 OS our
> Linux computer is not shown.Looking forward for the
> early response . Help will be appreciated.
> Thanking You,
> Regards,
> Silky.
> --- Oliver Elphick <olly@lfix.co.uk> wrote:

--
He was part of my dream, of course -- but then I was part of his dream
too.
        -- Lewis Carroll

email: dave@largesalad.co.uk
web1 : www.largesalad.co.uk
web2 : www.p21.co.uk