Re: Server Shutting Down
От | Bob Pawley |
---|---|
Тема | Re: Server Shutting Down |
Дата | |
Msg-id | 005c01c9a26c$abb8ea40$6401a8c0@owner обсуждение исходный текст |
Ответ на | Server Shutting Down ("Bob Pawley" <rjpawley@shaw.ca>) |
Ответы |
Re: Server Shutting Down
Re: Server Shutting Down |
Список | 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@pinpointresearch.com> To: "Bob Pawley" <rjpawley@shaw.ca> Cc: "PostgreSQL" <pgsql-general@postgresql.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
В списке pgsql-general по дате отправления: