From: | "Bob Pawley" <rjpawley(at)shaw(dot)ca> |
---|---|
To: | "Steve Crawford" <scrawford(at)pinpointresearch(dot)com> |
Cc: | "PostgreSQL" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Server Shutting Down |
Date: | 2009-03-11 17:13:17 |
Message-ID: | 005c01c9a26c$abb8ea40$6401a8c0@owner |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Other than shutting down unexpectedly the server works fine.
I now have the server running as a remote host on my computer. I have been
running it on localhost.
It was shutting down when I was attempting to connect with my application. I
didn't think too much about it figuring I would find the problem in my app.
However when PG Admin force the server to close I began to think it was
something else.
I simply clicked 'connect' in PG Admin and got the error.
There are 6 databases and I make a single connection to one of them (still
in development stage).
I can't be sure wheter PG Admin forced a shutdown when I was on localhost
although my application attempting to conect did force a shutdown.
A simple 'stop' then 'start' resolves the immediate problem.
Bob
----- Original Message -----
From: "Steve Crawford" <scrawford(at)pinpointresearch(dot)com>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, March 11, 2009 8:43 AM
Subject: Re: [GENERAL] Server Shutting Down
> Bob Pawley wrote:
>> Hi
>>
>> I've had the server shut itself down when attempting to connect, even
>> with PG Admin.
>>
>> Is there anything I can do to ensure that the pg server continues to run
>> during a connection?
>>
>> Bob
>>
> We're going to need a bit more to go on.
>
> Is it the whole server or just your backend? Did it used to work? What
> changed? If you revert changes does it work again? Is the server otherwise
> healthy? Are you exceeding something (number of connections, open file
> limits or anything else you can think of) so that PG or the OS is killing
> the backend? Is the server on the same machine that you are connecting
> from? What OS? What do the PostgreSQL server logs say (increase logging
> verbosity if necessary)?
>
> Cheers,
> Steve
From | Date | Subject | |
---|---|---|---|
Next Message | John Wang | 2009-03-11 17:21:20 | Question about \copy |
Previous Message | Tom Lane | 2009-03-11 17:09:20 | Re: Suggestions for blocking user inserts during admin bulk loading. |