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
