Обсуждение: [Fwd: postgres 7.3.1 init script error]
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
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
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
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
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
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