Re: [GENERAL] How to repair Pg 9.1?

2012-04-15 Thread Dmitry E. Oboukhov
M killer does its dirty work with > signal 9 (SIGKILL), not signal 11 (SIGSEGV). OOM killer was when I did 'ALTER TABLE' (in the first time), the log was since the time for each client's connecting. Sorry, my bad English, I could not explain cleanly :) -- . ''`.

Re: [GENERAL] How to repair Pg 9.1?

2012-04-15 Thread Dmitry E. Oboukhov
parameter - it'll run longer but won't need that > much memory. > Tomas I've just upgraded my postgresql upto current wheezy version (9.1.3-2/Debian): I wanted to get backtrace so it was upgraded when I installed postgresql-dbg package. After upgrading it discont

[GENERAL] How to repair Pg 9.1?

2012-04-15 Thread Dmitry E. Oboukhov
16:46:02 MSK LOG: autovacuum launcher started 2012-04-15 16:46:02 MSK LOG: database system is ready to accept connections What can I do in the situation? Postgresql 9.1/Debian wheezy -- . ''`. Dmitry E. Oboukhov : :’ : email: un...@debian.org j

[GENERAL] aggregate arrays

2012-04-13 Thread Dmitry E. Oboukhov
ray_agg(unnest(column1)) AS column1, array_agg(column2) column2 FROM "test"; But I receive the error: ERROR: set-valued function called in context that cannot accept a set How can I aggregate arrays into one array? -- . ''`. Dmitry E.