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
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 |