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 can't run PostgreSQL with a data directory that was initialized with a different block size. You will need to dump and reload the database. You really shouldn't be hitting the 8k row size limit anyway. PostgreSQL uses out-of-line TOAST storage for large values, so the only way you're likely to be hitting it is by having absurd numbers of small fields in your tables (or maybe a custom data type for which you've not implemented TOAST support?). If you have that many fields in your tables it might be time to look at your schema design. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
