From: Peter Eisentraut <peter_e@gmx.net>
To: Bhujbal, Santosh <sbhujbal@starentnetworks.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: postgres block_size problem
Date: Tue, 30 Dec 2008 15:55:43 +0200
Message-ID: <495A285F.5080000@gmx.net> (raw)
In-Reply-To: <3BD53621E5C8E54594130AF5459379EE08D80D41@exchindia4.starentnetworks.com>
References: <3BD53621E5C8E54594130AF5459379EE08D80D41@exchindia4.starentnetworks.com>
Bhujbal, Santosh wrote:
> 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 to 16k
> and recompiled the postgres library. The problem at hand was resolved
> with the new postgres library and we were now able to populate data for
> the mentioned query successfully. However, this experiment fails when we
> tried to run the new postgres on data directory generated with 8k block
> size which is likely to occur during an upgrade with postgres log
> showing the following error:
>
>
>
> 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.
>
>
>
> What could be the possible solution to this?
If you want to migrate data from an 8k block size data directory to a
16k block size data directory, you need to do a dump and restore, just
like on a major version upgrade.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peter_e@gmx.net, sbhujbal@starentnetworks.com
Subject: Re: postgres block_size problem
In-Reply-To: <495A285F.5080000@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox