Re: Starting postmaster at boot - Mailing list pgsql-general

From Alfred Perlstein
Subject Re: Starting postmaster at boot
Date
Msg-id 20000914132520.V12231@fw.wintelcom.net
Whole thread Raw
In response to Re: Starting postmaster at boot  ("Adam Lang" <aalang@rutgersinsurance.com>)
List pgsql-general
* Adam Lang <aalang@rutgersinsurance.com> [000914 13:21] wrote:
> I didn't directly use your method, but you nonetheless solved my problem.
> >From the beginning everyone was telling me to put this into my rc.local:
> su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i
> /usr/local/pgsql/postgres.log 2>&1 &"
>
> It was never working.  I noticed you had a tag "-l" in yours for su.  I
> looked up the reason for it and gave it a try.  So the script:
> su -l postgres -c "/usr/local/pgsql/bin/postmaster -D
> /usr/local/pgsql/data -i /home/postgres/postgres.log 2>1 &"
> does work.
>
> I still don't understand the point of the 1's and 2's in the command though.

It tells the shell to hook the child's stderr to stdout so that all
output should go to /home/postgres/postgres.log.

> Why is everyone else's script working without the -l and mine wasn't?

Check su's manpage.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

pgsql-general by date:

Previous
From: Dale Walker
Date:
Subject: vacuum taking long time
Next
From: Dale Walker
Date:
Subject: Re: Starting postmaster at boot