Re: Starting postmaster in rc.local/during bootup - Mailing list pgsql-general

From Magnus Naeslund(f)
Subject Re: Starting postmaster in rc.local/during bootup
Date
Msg-id 0c7501c29ad0$4466ad50$f80c0a0a@mnd
Whole thread Raw
In response to Starting postmaster in rc.local/during bootup  ("Chris Boget" <chris@wild.net>)
List pgsql-general
Chris Boget <chris@wild.net> wrote:
> On the following page
>
> http://www.postgresql.org/idocs/index.php?installation.html
>
> It says that I need to su to the user postgres to start postmaster.
> In fact, when I try to start it as user root, it won't let me and that
> is somewhat understandable.  But ideally, I'd like it so that user
> postgres does not have a shell (which is what I've done for the
> mysql user I had to set up).
> When I tried to set up the command to start up postgres in the
> rc.local to run as user postgres, I'm having problems.  I know there
> has got to be a way for me to be able to do this but I'm still too
> new to *nix to know how.  I've looked throughout the PgSQL docs,
> mimiced the line I have for mysql (but making the relevant changes),
> did some searches on the web but have come up blank.
> Could someone point me to where I need to look to discover how
> to do what I want?
>
> thnx,
> Chris
>

If youre running Linux you could probably specify shell on su
commandline:

su postgresql -s /bin/sh -c "/path/command"

Magnus


pgsql-general by date:

Previous
From: Tommi Maekitalo
Date:
Subject: Re: Starting postmaster in rc.local/during bootup
Next
From: "Chris Boget"
Date:
Subject: Re: Starting postmaster in rc.local/during bootup