postgres 8 upgrade problem

From: Abdul-Wahid Paterson <abdulwahid(at)gmail(dot)com>
To: PgSql General <pgsql-general(at)postgresql(dot)org>
Subject: postgres 8 upgrade problem
Date: 2005-04-12 13:35:10
Message-ID: 995fcdb005041206352137429a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2005-04-12 13:45:26 Re: What are the consequences of a bad database design (never seen that before !)
Previous Message Robert Treat 2005-04-12 13:15:52 Re: PostgreSQL 8.0.2 Now Available