Thread: [Fwd: postgres 7.3.1 init script error]

[Fwd: postgres 7.3.1 init script error]

From
Justin Clift
Date:
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@home-box.ods.org>
To: justin@postgresql.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


Re: [Fwd: postgres 7.3.1 init script error]

From
Robert Treat
Date:
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@home-box.ods.org>
> To: justin@postgresql.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


Re: [Fwd: postgres 7.3.1 init script error]

From
Justin Clift
Date:
Robert Treat wrote:

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

Hi Robert,

Should be in the /scripts/ subdirectory of the techdocs site.  Full path
info is:

http://techdocs.postgresql.org/scripts/732solaris8-startup

:-)

Regards and best wishes,

Justin Clift


--
Executive Director
Digital Distribution Global Training Services Pty. Ltd.
Premier OpenOffice.org and StarOffice Online Training providers
http://www.digitaldistribution.com

Re: [Fwd: postgres 7.3.1 init script error]

From
Robert Treat
Date:
On Mon, 2004-03-15 at 10:43, Justin Clift wrote:
> Robert Treat wrote:
>
> > I can put it on my TODO list... out of curiosity, is this script in the
> > servers CVS ?
> >
> > Robert Treat
>
> Hi Robert,
>
> Should be in the /scripts/ subdirectory of the techdocs site.  Full path
> info is:
>
> http://techdocs.postgresql.org/scripts/732solaris8-startup
>

No... I meant the CVS of PostgreSQL proper... we have scripts for linux,
mac osx , etc... wondered if this one is distributed with the actual
application code.

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


Re: [Fwd: postgres 7.3.1 init script error]

From
Tom Lane
Date:
Robert Treat <xzilla@users.sourceforge.net> writes:
> No... I meant the CVS of PostgreSQL proper... we have scripts for linux,
> mac osx , etc... wondered if this one is distributed with the actual
> application code.

No, not to my knowledge.  Possibly it should go into contrib/start-scripts,
but it's not there now.

            regards, tom lane

Re: [Fwd: postgres 7.3.1 init script error]

From
Justin Clift
Date:
Tom Lane wrote:

> Robert Treat <xzilla@users.sourceforge.net> writes:
>
>>No... I meant the CVS of PostgreSQL proper... we have scripts for linux,
>>mac osx , etc... wondered if this one is distributed with the actual
>>application code.
>
> No, not to my knowledge.  Possibly it should go into contrib/start-scripts,
> but it's not there now.

Good point.  Don't seem to have ever gotten around to it, though it
probably would have been good to.  :(

Regards and best wishes,

Justin Clift

>             regards, tom lane


--
Executive Director
Digital Distribution Global Training Services Pty. Ltd.
Premier OpenOffice.org and StarOffice Online Training providers
http://www.digitaldistribution.com