Re: [Fwd: postgres 7.3.1 init script error]

I can put it on my TODO list... out of curiosity, is this script in the
servers CVS ?

Robert Treat

On Mon, 2004-03-15 at 09:05, Justin Clift wrote:
> Hi guys,
>
> Does anyone feel like updating the Solaris startup script (was for PG
> 7.3.1) on the techdocs site?
>
> Regards and best wishes,
>
> Justin Clift
>
>
> -------- Original Message --------
> Subject: postgres 7.3.1 init script error
> Date: Sat, 13 Mar 2004 03:15:50 +1100
> From: Adrian Saul <asaul(at)home-box(dot)ods(dot)org>
> To: justin(at)postgresql(dot)org
>
> Justin,
> The /etc/init.d/postgresql start script under Solaris fails to start
> postgres at all because the pgrep matches the init script!
>
> The lines with "pgrep postgres" return the PID of the init script
> because pgrep under solaris without any options will return a simple
> grep of ps (effectively), thus matching postgresql of the init script.
> What you actually need is "pgrep -x postgres" which will only match
> processes with an executable exactly matching "postgres".
> I couldnt actually get the start script to work (on the default pkgadd
> install) until I made that change. Just a heads up if you want to fix it.
>
> Cheers,
> Adrian
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL