[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] writes:
My database has shutdown several times in the last couple days. I have
no
idea why. I am running centos and I have not rebooted the server or
made
any configuration changes.
So in particular, you didn't disable memory overcommit?
LOG: serv
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] writes:
My database has shutdown several times in the last couple days. I have
no
idea why. I am running centos and I have not rebooted the server or
made
any configuration changes.
Oh, I forgot. You do have plenty of swap space compared to RAM, yes
> [EMAIL PROTECTED] writes:
>> My database has shutdown several times in the last couple days. I have
>> no
>> idea why. I am running centos and I have not rebooted the server or
>> made
>> any configuration changes.
>
> So in particular, you didn't disable memory overcommit?
>
>> LOG: server pr
On 6/18/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
My database has shutdown several times in the last couple days. I have no
idea why.
[...]
LOG: server process (PID 501) was terminated by signal 9
If this is Linux, check the kernel log (typically /var/log/kern.log,
or run dmesg) and
[EMAIL PROTECTED] writes:
> My database has shutdown several times in the last couple days. I have no
> idea why. I am running centos and I have not rebooted the server or made
> any configuration changes.
So in particular, you didn't disable memory overcommit?
> LOG: server process (PID 501)
[EMAIL PROTECTED] writes:
could do logging wise on the postgres side to get a better indication of
what is happening?
You can increase the levels of loggin and redirect std_error to a file.
Something along the lines of
log_destination = 'stderr'
log_filename = 'postgresql-%Y-%m-%d.log'
log_er
> <[EMAIL PROTECTED]> writes:
>
>> My database has shutdown several times in the last couple days. I have
>> no
>> idea why. I am running centos and I have not rebooted the server or
>> made
>> any configuration changes. I am running postgres 8.2 and it has been
>> stable since I installed it ab
<[EMAIL PROTECTED]> writes:
> My database has shutdown several times in the last couple days. I have no
> idea why. I am running centos and I have not rebooted the server or made
> any configuration changes. I am running postgres 8.2 and it has been
> stable since I installed it about 5 months
On 6/18/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
My database has shutdown several times in the last couple days. I have no
idea why. I am running centos and I have not rebooted the server or made
any configuration changes. I am running postgres 8.2 and it has been
stable since I insta
