[GENERAL] How to repair Pg 9.1?

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

Re: [GENERAL] How to repair Pg 9.1?

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

Re: [GENERAL] Writing data to a text file based on a trigger event...

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

Re: [GENERAL] How to repair Pg 9.1?

>> 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

Re: [GENERAL] Updating pg_attribute to change field's data type from integer to bigint on very large table

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

Re: [GENERAL] How to repair Pg 9.1?

"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

Re: [GENERAL] How to repair Pg 9.1?

>> 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

Re: [GENERAL] How to repair Pg 9.1?

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