Re: Server Shutting Down

The PostgreSQL Server log. I don't know about Windows but in *nix you
need to edit the "ERROR REPORTING AND LOGGING" section of
postgresql.conf, wherever that is located in your install (we still have
no idea what OS, OS release/version, and PG version we are trying to
help you with). If you are on 8.3, see the manual:
http://www.postgresql.org/docs/8.3/interactive/runtime-config-logging.html

Cheers,
Steve

Bob Pawley wrote:
> What log should I get and how do I get it??
>
> Bob
>
>
> ----- Original Message ----- From: "Adrian Klaver" <aklaver(at)comcast(dot)net>
> To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
> Cc: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>; "Steve Crawford"
> <scrawford(at)pinpointresearch(dot)com>
> Sent: Wednesday, March 11, 2009 10:21 AM
> Subject: Re: [GENERAL] Server Shutting Down
>
>
>>
>> ----- "Bob Pawley" <rjpawley(at)shaw(dot)ca> wrote:
>>
>>> 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
>>
>> Without some log information this is going nowhere:)
>>
>> Adrian Klaver
>> aklaver(at)comcast(dot)net
>>
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>
>