postgres 8 upgrade problem

Started by Abdul-Wahid Patersonalmost 21 years ago1 messagesgeneral
Jump to latest
#1Abdul-Wahid Paterson
abdulwahid@gmail.com

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