Re: any body using Solaris8 with postgresql 7.3.3

From: Weiping He <laser(at)zhengmai(dot)com(dot)cn>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: any body using Solaris8 with postgresql 7.3.3
Date: 2003-07-04 14:36:21
Message-ID: 3F0590E5.2060209@zhengmai.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

>Weiping He <laser(at)zhengmai(dot)com(dot)cn> 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 (look in /usr/include/signal.h
>to make sure, but that's pretty standard), this would indicate that
>something is sending SIGINT to the postmaster. The postmaster will
>interpret that as a fast shutdown request. So the problem is not with
>the postmaster, but with whatever is sending the signal.
>
>I suspect this isn't a platform problem so much as a setup mistake.
>How are you launching the postmaster? Is it possible it's still
>connected to a controlling terminal? (If so, the shell would probably
>SIGINT the postmaster anytime you typed control-C.)
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
emm, I'll check that. My first start method is:
pg_ctl start -l ~/pgrun.log

(I've export PGDATA=/pgsqldata)

but it reports:
pg_ctl: test: argument expected

I'm using ksh I think, which I've also test in 7.4-devl version, the
same result,
ISTM a little bug in pg_ctl script, but still didn't dig into it to see
if I can
found the problem.

Later I use:
pg_ctl start >pgrun.log 2>&1

to start the program, and it runs ok. but, then the pmdie 2...

Thanks

Laser

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rod Taylor 2003-07-04 14:49:01 Re: PostgreSQL vs. MySQL
Previous Message Tom Lane 2003-07-04 14:35:54 Re: PostgreSQL vs. MySQL