Thread: postgres 8 upgrade problem

Hi,

I have just upgraded my (thank God test) database server to Postgres to 8.0.1 from 7.4.7. I do a stand dump, shutdown, upgrade, restore procedure.

On the server i have 5 databases. All of them work fine except one where I can "select" fine but an not insert, update or delete!!!

I get errors like this...

=# insert into dynaconfig (name, value) values ('a', 'g');
ERROR:  invalid memory alloc request size 13077039904


Postgresql log file has entries like....

LOG:  server process (PID 24472) was terminated by signal 11
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2005-04-12 14:31:17 BST
LOG:  checkpoint record is at 1/45B00648
LOG:  redo record is at 1/45B00648; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 4827; next OID: 28627425
LOG:  database system was not properly shut down; automatic recovery in progressLOG:  record with zero length at 1/45B00690
LOG:  redo is not required
LOG:  database system is ready

I can dump the database fine and I can reload it again without errors. All other databases on the server work fine.

Any ideas?

Regards,

Abdul-Wahid