Skip site navigation (1) Skip section navigation (2)

Re: Tuple is too big

From: j6m(at)cvni(dot)net
To: vinicius caldo <vinicius(at)sordido(dot)com(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Tuple is too big
Date: 2004-04-23 21:34:11
Message-ID: 1082756051.40898bd39c40b@ (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Bom Dia,

I ran into that trouble too. But as I used Postgresql since 7.0.2, I returned to
the traditional way of doing things as I thought it was due to a wrong
understanding from my part of this issue).

(I presume your PGDATA directory is in /var/lib/pgsl/data and it is run by a
user named 'postgres')

1 - dump all your databases with pg_dumpall
    (e.g. pg_dumpall -v -U postgres | bzip2 > dumpall.dump.bz2)

2 - save *.conf files found in /var/lib/pgsql/data

3 - do a pg_config --configure and save the output

4 - shut running server down

5 - expand the source tree somewhere 

5 - edit the file and alter BLCKSZ from 8192 to 16384

6 - run configure with the 'pg_config --configure' output as arguments
    (so that your new Postgres will be exactly the same as your old)

7 - make, make check

8 - make install as root if above step is satisfactory

9 - save the /var/lib/pgsql/data content, then 'rm -rf' on it

10 - run /etc/rc.d/rc3.d/S??postgresql start (if it includes an initdb,
otherwise set PGDATA to /var/lib/pgsql/data and do it manually under the
identity of the user the postgres process should run under)

11 - restore your previously saved conf files and restart postgres

12 - restore your data
     (e.g. bzip2 -d < dumpall.dump.bz2 | psql -U postgres template1)

It is not the most elegant solution but as it works, I am fairly happy with it.

Remember to have always fresh data backups should you use some distribution
provided online facilities. Should an upgrade of Postgres be set, it is more
than likely it will come with the BLCKSZ parameter back to default value of
8192, which is incompatible with your settings)

Quoting vinicius caldo <vinicius(at)sordido(dot)com(dot)br>:

> Hi,
> I´m using PostgreSql version 7.3.6 and I get the following error:
> java.sql.SQLException: ERROR:  Tuple is too big: size 8152, max size 8136
> I searched in the Internet and found out that bug was fixed in version 7.2,
> but I still get this error.

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-04-24 02:37:43
Subject: Re: ipcclean broken on OSX
Previous:From: Neil ConwayDate: 2004-04-23 20:28:07
Subject: ipcclean broken on OSX

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group