Re: [GENERAL] postgres block_size problem

2008-12-31 Thread Craig Ringer
Bhujbal, Santosh wrote: > 2008-12-30 14:57:33 IST DETAIL: The database cluster was initialized > with BLCKSZ 8192, but the server was compiled with BLCKSZ 16384. > > 2008-12-30 14:57:33 IST HINT: It looks like you need to recompile or > initdb. This error message tells you the answer. You ca

[GENERAL] postgres block_size problem

2008-12-30 Thread Bhujbal, Santosh
Hi All, We were getting the following error on executing a COPY command on postgres8.2.0. SQL execution failed, Internal error. SQL Statement: (COPY command failed with error: ERROR: row is too big: size 8200, maximum size 8136) So, in order to fix the error we tried increasing the block size t