Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Tom Lane
Andrew Sullivan <[EMAIL PROTECTED]> writes: >> On Fri, Jul 04, 2003 at 02:52:41PM +0800, Weiping He wrote: >>> pmdie 2 >> >> Just a hunch, but could this have anything to do with power >> management? That's controlled by a program called pm. Nah, it's coming from the postmaster's signal-catching

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Andrew Sullivan
On Fri, Jul 04, 2003 at 03:45:04PM -0400, Andrew Sullivan wrote: > On Fri, Jul 04, 2003 at 02:52:41PM +0800, Weiping He wrote: > > > >pmdie 2 > > Just a hunch, but could this have anything to do with power > management? That's controlled by a program called pm. Hmm. Not a program, after al

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Andrew Sullivan
On Fri, Jul 04, 2003 at 02:52:41PM +0800, Weiping He wrote: > >pmdie 2 Just a hunch, but could this have anything to do with power management? That's controlled by a program called pm. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Jonathan Bartlett
I would add a nohup. In addition, are you using the Solaris performance/process monitoring tools? I forget which one, maybe pfiles, would occasionally send wierd signals to processes. Check your cron listings to see if you're running anything like that. Jon ---(end of

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Weiping He
Tom Lane wrote: Weiping He <[EMAIL PROTECTED]> writes: Later I use: pg_ctl start >pgrun.log 2>&1 to start the program, and it runs ok. but, then the pmdie 2... Hm. My first thought was that you needed a We should check the theory though. After you start the postmaster using the above co

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Tom Lane
Weiping He <[EMAIL PROTECTED]> writes: > Later I use: > pg_ctl start >pgrun.log 2>&1 > to start the program, and it runs ok. but, then the pmdie 2... Hm. My first thought was that you needed a

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Weiping He
Tom Lane wrote: Weiping He <[EMAIL PROTECTED]> writes: I've met a wierd problem on a Solaris 8/sparc box with postgresql 7.3.3: the server would automatically shutdown after a period of time of not operating. The log show something like this: pmdie 2 Assuming signal 2 is SIGINT

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Tom Lane
Weiping He <[EMAIL PROTECTED]> writes: > I've met a wierd problem on a Solaris 8/sparc box with postgresql 7.3.3: > the server would automatically shutdown after a period of time of not > operating. The log show something like this: > pmdie 2 Assuming signal 2 is SIGINT on Solaris

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Weiping He
Martin Marques wrote: On Vie 04 Jul 2003 03:52, Weiping He wrote: Hi, all, I've met a wierd problem on a Solaris 8/sparc box with postgresql 7.3.3: the server would automatically shutdown after a period of time of not operating. The log show something like this: pmdie 2 anybody us

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Martin Marques
On Vie 04 Jul 2003 03:52, Weiping He wrote: > Hi, all, > > I've met a wierd problem on a Solaris 8/sparc box with postgresql > 7.3.3: > > the server would automatically shutdown after a period of time of > not operating. The log show something like this: > > pmdie 2 > > anybody usin