On 15.4.2012 16:16, Dmitry E. Oboukhov wrote:
>>> 2012-04-15 16:46:02 MSK LOG: server process (PID 825) was terminated
>>> by signal 11: Segmentation fault
>
> ~
>>> What can I do in the situation?
>
>> Well, what happened is quite clear. One of the processes was
>> Recently I started a hard query (ALTER TABLE) and then Postgresql was
>> killed by OOM killer.
>> ...
>> 2012-04-15 16:46:02 MSK LOG: server process (PID 825) was terminated by
>> signal 11: Segmentation fault
> You sure it was an OOM kill? The OOM killer does its dirty work with
> signa
"Dmitry E. Oboukhov" writes:
> Recently I started a hard query (ALTER TABLE) and then Postgresql was
> killed by OOM killer.
> ...
> 2012-04-15 16:46:02 MSK LOG: server process (PID 825) was terminated by
> signal 11: Segmentation fault
You sure it was an OOM kill? The OOM killer does its
Thanks Alban. Perhaps I will go with the rewrite. I use the table for
storage and analysis purposes only and am the only user, so I can take the
table offline, I was wondering whether running the ALTER TABLE on the
parent table makes the change in the inherited child tables? The fact that
my initia
>> 2012-04-15 16:46:02 MSK LOG: server process (PID 825) was terminated by
>> signal 11: Segmentation fault
~
>> What can I do in the situation?
> Well, what happened is quite clear. One of the processes was terminated
> by the OOM killer. The database noticed th
On 12.4.2012 12:58, raghupradeep wrote:
> Hi ,
>
> I am basically a MySQL DBA and have little idea on PostgreSQL. In our
> environment we have an application which is using PostgreSQL as its back
> end. The application logs the status of the jobs running in it to a table in
> this database i.e whe
On 15.4.2012 14:52, Dmitry E. Oboukhov wrote:
> Recently I started a hard query (ALTER TABLE) and then Postgresql was
> killed by OOM killer.
>
> Since that clients lose their connection and Postgresql says in log:
>
> 2012-04-15 16:46:02 MSK LOG: server process (PID 825) was terminated by
Recently I started a hard query (ALTER TABLE) and then Postgresql was
killed by OOM killer.
Since that clients lose their connection and Postgresql says in log:
2012-04-15 16:46:02 MSK LOG: server process (PID 825) was terminated by
signal 11: Segmentation fault
2012-04-15 16:46:02 MSK
