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

From Adam Lang
Subject Re: Starting postmaster at boot
Date
Msg-id 024a01c01e8b$15498100$330a0a0a@Adam
Whole thread Raw
In response to Re: Starting postmaster at boot  (David Veatch <dveatch@sunflower.com>)
List pgsql-general
oh... so since I did a su -l, I could have just used the command,
postmaster -i >>postgres.log 2>>1 & ? Since I had the appropriate variables
in postgres's .bash_profile?

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Dale Walker" <dale@icr.com.au>
To: "Adam Lang" <aalang@rutgersinsurance.com>
Cc: "PGSQL General" <pgsql-general@postgresql.org>
Sent: Thursday, September 14, 2000 4:33 PM
Subject: Re: [GENERAL] Starting postmaster at boot


> Adam Lang 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's a method for redirecting STDERR --> STDOUT
>
> this is especially usefull in scripts
>
> normally I use [scriptname >/dev/null 2>&1] to send any unwanted output
> to /dev/null
>
> >
> > Why is everyone else's script working without the -l and mine wasn't?
> >
>
>
> '-l' uses the login profile for the su'd user... this is similar to a
> 'simuated login', without it , it was only referencing variables from
> your roo profile ... (ie. no PGDATA,etc..)
>
>
> --
> Dale Walker                                              dale@icr.com.au
> Independent Computer Retailers (ICR)               http://www.icr.com.au
> ICRnet            http://www.icr.net.au


pgsql-general by date:

Previous
From: "Adam Lang"
Date:
Subject: Fw: Starting postmaster at boot
Next
From: "Mitch Vincent"
Date:
Subject: Re: Starting postmaster at boot