after roughly 6 hours of constant updates and inserts...
I have absolutely no clue as to how many transactions or how many
updates or inserts.
 
see below.
 
Regards,
 
John (applejack)
 
Mar  8 06:25:10 fred postgres[614]: [2-1] ERROR:  could not write block
2333 of relation 17142/21672885: Cannot allocate memory
Mar  8 06:25:10 fred postgres[614]: [2-2] CONTEXT:  writing block 2333
of relation 17142/21672885
Mar  8 06:25:25 fred postgres[598]: [2-1] LOG:  bgwriter process (PID
614) was terminated by signal 9
Mar  8 06:25:25 fred postgres[598]: [3-1] LOG:  terminating any other
active server processes
Mar  8 06:25:35 fred postgres[27526]: [4-1] WARNING:  terminating
connection because of crash of another server process
Mar  8 06:25:35 fred postgres[27526]: [4-2] DETAIL:  The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server
Mar  8 06:25:35 fred postgres[27526]: [4-3]  process exited abnormally
and possibly corrupted shared memory.
Mar  8 06:25:35 fred postgres[27526]: [4-4] HINT:  In a moment you
should be able to reconnect to the database and repeat your command.
Mar  8 06:25:35 fred postgres[27526]: [5-1] ERROR:  could not send data
to client: Broken pipe
Mar  8 06:25:35 fred postgres[27527]: [4-1] WARNING:  terminating
connection because of crash of another server process
Mar  8 06:25:35 fred postgres[27527]: [4-2] DETAIL:  The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server
Mar  8 06:25:35 fred postgres[27527]: [4-3]  process exited abnormally
and possibly corrupted shared memory.
Mar  8 06:25:35 fred postgres[27527]: [4-4] HINT:  In a moment you
should be able to reconnect to the database and repeat your command.
Mar  8 06:25:35 fred postgres[27527]: [5-1] ERROR:  could not send data
to client: Broken pipe
Mar  8 06:25:36 fred postgres[27592]: [4-1] WARNING:  terminating
connection because of crash of another server process
Mar  8 06:25:36 fred postgres[27592]: [4-2] DETAIL:  The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server
Mar  8 06:25:36 fred postgres[27592]: [4-3]  process exited abnormally
and possibly corrupted shared memory.
Mar  8 06:25:36 fred postgres[27592]: [4-4] HINT:  In a moment you
should be able to reconnect to the database and repeat your command.
Mar  8 06:25:36 fred postgres[27526]: [6-1] WARNING:  AbortTransaction
and not in in-progress state
Mar  8 06:25:36 fred postgres[27526]: [7-1] LOG:  unexpected EOF on
client connection
Mar  8 06:25:36 fred postgres[27527]: [6-1] WARNING:  AbortTransaction
and not in in-progress state
Mar  8 06:25:36 fred postgres[27527]: [7-1] LOG:  unexpected EOF on
client connection
Mar  8 06:25:38 fred postgres[598]: [4-1] LOG:  all server processes
terminated; reinitializing
Mar  8 06:25:38 fred postgres[27663]: [5-1] LOG:  database system was
interrupted at 2004-03-08 06:24:01 EST
Mar  8 06:25:38 fred postgres[27663]: [6-1] LOG:  checkpoint record is
at 18/61431A88
Mar  8 06:25:38 fred postgres[27663]: [7-1] LOG:  redo record is at
18/61431A88; undo record is at 0/0; shutdown FALSE
Mar  8 06:25:38 fred postgres[27663]: [8-1] LOG:  next transaction ID:
51079855; next OID: 32618747
Mar  8 06:25:38 fred postgres[27663]: [9-1] LOG:  database system was
not properly shut down; automatic recovery in progress
Mar  8 06:25:39 fred postgres[27663]: [10-1] LOG:  redo starts at
18/61431AC8
Mar  8 06:25:56 fred postgres[27663]: [11-1] LOG:  record with zero
length at 18/620FE3F8
Mar  8 06:25:56 fred postgres[27663]: [12-1] LOG:  redo done at
18/620FE3D4
Mar  8 06:26:01 fred postgres[27663]: [13-1] LOG:  recycled transaction
log file "000000180000005E"
Mar  8 06:26:01 fred postgres[27663]: [14-1] LOG:  recycled transaction
log file "000000180000005F"
Mar  8 06:26:01 fred postgres[27663]: [15-1] LOG:  recycled transaction
log file "0000001800000060"
Mar  8 06:26:01 fred postgres[27663]: [16-1] LOG:  database system is
ready






after roughly 6 
hours of constant updates and inserts...
I have absolutely no 
clue as to how many transactions or how many updates or 
inserts.
 
see 
below.
 
Regards,
 
John 
(applejack)
 
Mar  8 06:25:10 fred postgres[614]: [2-1] 
ERROR:  could not write block 2333 of relation 17142/21672885: Cannot 
allocate memoryMar  8 06:25:10 fred postgres[614]: [2-2] CONTEXT:  
writing block 2333 of relation 17142/21672885Mar  8 06:25:25 fred 
postgres[598]: [2-1] LOG:  bgwriter process (PID 614) was terminated by 
signal 9Mar  8 06:25:25 fred postgres[598]: [3-1] LOG:  
terminating any other active server processesMar  8 06:25:35 fred 
postgres[27526]: [4-1] WARNING:  terminating connection because of crash of 
another server processMar  8 06:25:35 fred postgres[27526]: [4-2] 
DETAIL:  The postmaster has commanded this server process to roll back the 
current transaction and exit, because another serverMar  8 06:25:35 
fred postgres[27526]: [4-3]  process exited abnormally and possibly 
corrupted shared memory.Mar  8 06:25:35 fred postgres[27526]: [4-4] 
HINT:  In a moment you should be able to reconnect to the database and 
repeat your command.Mar  8 06:25:35 fred postgres[27526]: [5-1] 
ERROR:  could not send data to client: Broken pipeMar  8 06:25:35 
fred postgres[27527]: [4-1] WARNING:  terminating connection because of 
crash of another server processMar  8 06:25:35 fred postgres[27527]: 
[4-2] DETAIL:  The postmaster has commanded this server process to roll 
back the current transaction and exit, because another serverMar  8 
06:25:35 fred postgres[27527]: [4-3]  process exited abnormally and 
possibly corrupted shared memory.Mar  8 06:25:35 fred postgres[27527]: 
[4-4] HINT:  In a moment you should be able to reconnect to the database 
and repeat your command.Mar  8 06:25:35 fred postgres[27527]: [5-1] 
ERROR:  could not send data to client: Broken pipeMar  8 06:25:36 
fred postgres[27592]: [4-1] WARNING:  terminating connection because of 
crash of another server processMar  8 06:25:36 fred postgres[27592]: 
[4-2] DETAIL:  The postmaster has commanded this server process to roll 
back the current transaction and exit, because another serverMar  8 
06:25:36 fred postgres[27592]: [4-3]  process exited abnormally and 
possibly corrupted shared memory.Mar  8 06:25:36 fred postgres[27592]: 
[4-4] HINT:  In a moment you should be able to reconnect to the database 
and repeat your command.Mar  8 06:25:36 fred postgres[27526]: [6-1] 
WARNING:  AbortTransaction and not in in-progress stateMar  8 
06:25:36 fred postgres[27526]: [7-1] LOG:  unexpected EOF on client 
connectionMar  8 06:25:36 fred postgres[27527]: [6-1] WARNING:  
AbortTransaction and not in in-progress stateMar  8 06:25:36 fred 
postgres[27527]: [7-1] LOG:  unexpected EOF on client 
connectionMar  8 06:25:38 fred postgres[598]: [4-1] LOG:  all 
server processes terminated; reinitializingMar  8 06:25:38 fred 
postgres[27663]: [5-1] LOG:  database system was interrupted at 2004-03-08 
06:24:01 ESTMar  8 06:25:38 fred postgres[27663]: [6-1] LOG:  
checkpoint record is at 18/61431A88Mar  8 06:25:38 fred 
postgres[27663]: [7-1] LOG:  redo record is at 18/61431A88; undo record is 
at 0/0; shutdown FALSEMar  8 06:25:38 fred postgres[27663]: [8-1] 
LOG:  next transaction ID: 51079855; next OID: 32618747Mar  8 
06:25:38 fred postgres[27663]: [9-1] LOG:  database system was not properly 
shut down; automatic recovery in progressMar  8 06:25:39 fred 
postgres[27663]: [10-1] LOG:  redo starts at 18/61431AC8Mar  8 
06:25:56 fred postgres[27663]: [11-1] LOG:  record with zero length at 
18/620FE3F8Mar  8 06:25:56 fred postgres[27663]: [12-1] LOG:  redo 
done at 18/620FE3D4Mar  8 06:26:01 fred postgres[27663]: [13-1] 
LOG:  recycled transaction log file "000000180000005E"Mar  8 
06:26:01 fred postgres[27663]: [14-1] LOG:  recycled transaction log file 
"000000180000005F"Mar  8 06:26:01 fred postgres[27663]: [15-1] 
LOG:  recycled transaction log file "0000001800000060"Mar  8 
06:26:01 fred postgres[27663]: [16-1] LOG:  database system is 
ready
Mon, 8 Mar 2004 13:33:20 +1100
"John Hansen" <john@geeknet.com.au>
bgwriter bails out