Re: [GENERAL] btree index on a char(8) field (fwd)

1999-10-08 Thread Gene Selkov, Jr.
Frank Mandarino wrote: > Thanks for your response. > > I knew from the programming documentation that the opclass was optional. > I'm pretty sure, although I will check again tonight, that I tried > creating the index without specifying the opclass, but I found that the > index was still not use

Re: [GENERAL] Again: How the hell do I restart immediately

1999-10-08 Thread Gene Selkov, Jr.
> > When the postmaster dies, init will automatically > > respawn it, much the same as getty, or xdm, etc. > > Now, since init will be starting the postmaster, > > the /etc/rc.d/init.d script should be removed and > > the links to it in /etc/rc.d/rc[whatever].d should > > also be removed (or yo

Re: [GENERAL] Again: How the hell do I restart immediately

1999-10-08 Thread Simon Drabble
On Fri, 8 Oct 1999, Doran L. Barton wrote: > Not long ago, Ted Nolan SRI Augusta GA proclaimed... > > Hmm, perhaps I'm missing something, but since the postmaster doesnt go > > into the background by default, couldn't you just run a script > > with a loop creating postmasters as they die? Someth

Re: [GENERAL] Again: How the hell do I restart immediately

1999-10-08 Thread Doran L. Barton
Not long ago, Mike Mascari proclaimed... > According to the INSTALL document which came with > the distribution (possibly the following remark has > been removed in recent versions?), for RedHat Linux: > > > In RedHat Linux edit file /etc/initt

Re: [GENERAL] Again: How the hell do I restart immediately

1999-10-08 Thread Mike Mascari
--- Michael Simms <[EMAIL PROTECTED]> wrote: > > > > I posted this question before and got no good > responses. I'm posting it > > again out of pure desperation. > > > > I've got a Postgres 6.5.1 server running on a > RedHat (i386) 5.2 box. > > PostgreSQL was compiled from source with no > speci

Re: [GENERAL] Again: How the hell do I restart immediately

1999-10-08 Thread Doran L. Barton
Not long ago, Ted Nolan SRI Augusta GA proclaimed... > Hmm, perhaps I'm missing something, but since the postmaster doesnt go > into the background by default, couldn't you just run a script > with a loop creating postmasters as they die? Something like: > > #! /bin/sh > > while : > do >

Re: [GENERAL] Again: How the hell do I restart immediately

1999-10-08 Thread Ted Nolan SRI Augusta GA
In message <[EMAIL PROTECTED]>you write: > >Call this script postmasterangel.sh (as in guardian angel) and run it >instead of the postmaster. Change the postmaster line in here to be >your postmaster boot configuration options. > > >This runs under linux. It will probably work under most un*x >fla