Thread: FW: psql error

FW: psql error

From
archana shinde
Date:
Please look at below mail and help me on this.
------------------------------
From: Archana.2.Shinde
Sent: 02-04-2013 11:53
To: archii4u@gmail.com
Subject: psql error

Hi postgres team,



Please could you help me to resolve this error which I am getting, I am
using postgres  7.4.5  on solaris 9.



2013-03-28 12:03:05 LOG:  could not bind socket for statistics collector:
Cannot assign requested address

2013-03-28 12:03:05 LOG:  connection received: host=[local] port=

2013-03-28 12:03:05 FATAL:  the database system is starting up

2013-03-28 12:03:05 LOG:  connection received: host=[local] port=

2013-03-28 12:03:05 FATAL:  the database system is starting up

2013-03-28 12:03:05 LOG:  connection received: host=[local] port=

2013-03-28 12:03:05 LOG:  connection received: host=[local] port=

2013-03-28 12:03:05 FATAL:  the database system is starting up

2013-03-28 12:03:05 FATAL:  the database system is starting up

2013-03-28 12:03:05 LOG:  database system was interrupted at 2013-03-26
19:44:47 GMT

2013-03-28 12:03:05 LOG:  checkpoint record is at 338B/87AC3F68

2013-03-28 12:03:05 LOG:  redo record is at 338B/87AC3F68; undo record is
at 0/0; shutdown TRUE

2013-03-28 12:03:05 LOG:  next transaction ID: 210567474; next OID:
283025408

2013-03-28 12:03:05 LOG:  database system was not properly shut down;
automatic recovery in progress

2013-03-28 12:03:05 LOG:  record with zero length at 338B/87AC3FA8

2013-03-28 12:03:05 LOG:  redo is not required

2013-03-28 12:03:06 LOG:  connection received: host=[local] port=

2013-03-28 12:03:06 FATAL:  the database system is starting up

2013-03-28 12:03:06 LOG:  connection received: host=[local] port=

2013-03-28 12:03:06 FATAL:  the database system is starting up

2013-03-28 12:03:07 LOG:  connection received: host=[local] port=

2013-03-28 12:03:07 FATAL:  the database system is starting up

2013-03-28 12:03:07 LOG:  connection received: host=[local] port=

2013-03-28 12:03:07 FATAL:  the database system is starting up

2013-03-28 12:03:07 LOG:  connection received: host=[local] port=

2013-03-28 12:03:07 FATAL:  the database system is starting up

2013-03-28 12:03:08 LOG:  database system is ready

2013-03-28 12:03:10 LOG:  connection received: host=[local] port=

2013-03-28 12:03:10 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:10 LOG:  connection received: host=[local] port=

2013-03-28 12:03:10 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:10 LOG:  connection received: host=[local] port=

2013-03-28 12:03:10 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:10 LOG:  connection received: host=[local] port=

2013-03-28 12:03:10 LOG:  connection received: host=[local] port=

2013-03-28 12:03:10 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:10 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:12 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:12 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:12 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:12 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:12 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:15 LOG:  connection received: host=[local] port=

2013-03-28 12:03:15 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:15 LOG:  connection received: host=[local] port=

2013-03-28 12:03:15 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:15 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:15 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:15 LOG:  connection received: host=[local] port=

2013-03-28 12:03:15 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:15 LOG:  connection received: host=[local] port=

2013-03-28 12:03:15 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:15 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:15 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:16 LOG:  connection received: host=[local] port=

2013-03-28 12:03:16 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:16 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:16 LOG:  connection received: host=[local] port=

2013-03-28 12:03:16 LOG:  connection received: host=[local] port=

2013-03-28 12:03:17 2013-03-28 12:03:17 LOG:  connection received:
host=[local] port=

2013-03-28 12:03:17 2013-03-28 12:03:17 2013-03-28 12:03:17 LOG:
connection authorized: user=mcdonner database=template1

LOG:  connection authorized: user=mcdonner database=template1

LOG:  connection received: host=[local] port=

LOG:  connection received: host=[local] port=

2013-03-28 12:03:17 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:17 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:17 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:17 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:17 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:17 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:22 LOG:  connection received: host=[local] port=

2013-03-28 12:03:22 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:23 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:23 LOG:  connection received: host=[local] port=

2013-03-28 12:03:23 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:23 LOG:  connection received: host=[local] port=

2013-03-28 12:03:23 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:23 LOG:  connection received: host=[local] port=

2013-03-28 12:03:23 2013-03-28 12:03:23 ERROR:  database "backupnetwork"
does not exist

2013-03-28 12:03:23 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:23 LOG:  connection received: host=[local] port=

2013-03-28 12:03:23 LOG:  connection authorized: user=mcdonner
database=template1

LOG:  connection authorized: user=mcdonner database=template1

2013-03-28 12:03:23 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:23 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:25 LOG:  connection received: host=[local] port=

2013-03-28 12:03:25 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:25 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:25 LOG:  connection received: host=[local] port=

2013-03-28 12:03:25 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:25 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:25 LOG:  connection received: host=[local] port=

2013-03-28 12:03:25 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:25 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:25 LOG:  connection received: host=[local] port=

2013-03-28 12:03:25 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:25 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:26 LOG:  connection received: host=[local] port=

2013-03-28 12:03:26 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:26 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:27 LOG:  connection received: host=[local] port=

2013-03-28 12:03:27 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:27 LOG:  connection received: host=[local] port=

2013-03-28 12:03:27 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:27 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:27 LOG:  connection received: host=[local] port=

2013-03-28 12:03:27 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:27 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:27 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:27 LOG:  connection received: host=[local] port=

2013-03-28 12:03:27 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:27 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:33 LOG:  connection received: host=[local] port=

2013-03-28 12:03:33 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:33 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:33 LOG:  connection received: host=[local] port=

2013-03-28 12:03:33 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:33 LOG:  connection received: host=[local] port=

2013-03-28 12:03:33 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:33 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:33 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:33 LOG:  connection received: host=[local] port=

2013-03-28 12:03:33 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:33 LOG:  connection received: host=[local] port=

2013-03-28 12:03:33 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:33 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:33 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:35 LOG:  connection received: host=[local] port=

2013-03-28 12:03:35 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:35 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:35 LOG:  connection received: host=[local] port=

2013-03-28 12:03:35 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:35 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:35 LOG:  connection received: host=[local] port=

2013-03-28 12:03:35 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:35 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:35 LOG:  connection received: host=[local] port=

2013-03-28 12:03:35 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:35 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:36 LOG:  connection received: host=[local] port=

2013-03-28 12:03:36 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:36 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:37 LOG:  connection received: host=[local] port=

2013-03-28 12:03:37 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:37 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:37 LOG:  connection received: host=[local] port=

2013-03-28 12:03:37 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:37 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:37 LOG:  connection received: host=[local] port=

2013-03-28 12:03:37 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:37 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:37 LOG:  connection received: host=[local] port=

2013-03-28 12:03:37 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:37 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:43 LOG:  connection received: host=[local] port=

2013-03-28 12:03:43 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:43 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:43 LOG:  connection received: host=[local] port=

2013-03-28 12:03:43 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:43 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:43 LOG:  connection received: host=[local] port=

2013-03-28 12:03:43 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:43 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:43 LOG:  connection received: host=[local] port=

2013-03-28 12:03:43 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 12:03:43 ERROR:  database "backupnetwork" does not exist

2013-03-28 12:03:43 LOG:  connection received: host=[local] port=

2013-03-28 19:59:56 ERROR:  database "backupnetwork" does not exist

2013-03-28 19:59:56 LOG:  connection received: host=[local] port=

2013-03-28 19:59:56 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 19:59:56 ERROR:  database "backupnetwork" does not exist

2013-03-28 20:00:11 LOG:  connection received: host=[local] port=

2013-03-28 20:00:11 LOG:  connection received: host=[local] port=

2013-03-28 20:00:11 LOG:  connection received: host=[local] port=

2013-03-28 20:00:11 LOG:  connection received: host=[local] port=

2013-03-28 20:00:11 LOG:  connection received: host=[local] port=

2013-03-28 20:00:12 2013-03-28 20:00:12 LOG:  connection authorized:
user=mcdonner database=template1

LOG:  connection authorized: user=mcdonner database=template1

2013-03-28 20:00:12 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 20:00:12 LOG:  connection authorized: user=mcdonner
database=template1

2013-03-28 20:00:12 LOG:  connection authorized: user=mcdonner
database=template1

TopMemoryContextTopMemoryContext: 24576:  total in 245762 total in  blocks;
210272 blocks;  free (102722 free ( chunks); 2143

04 chunks);  used

14304CacheMemoryContext used

: CacheMemoryContext8192:  total in 81921 total in  blocks; 12864 blocks;
free (28640 free ( chunks); 05328 chunks);  used

5328pg_class_oid_index used

: pg_class_oid_index1024:  total in 10241 total in  blocks; 1640 blocks;
free (6400 free ( chunks); 0384 chunks);  used

384MdSmgr used

: MdSmgr8192:  total in 81921 total in  blocks; 16120 blocks;  free (61200
free ( chunks); 02072 chunks);  used

2072DynaHash used

: DynaHash8192:  total in 81921 total in  blocks; 14664 blocks;  free
(46640 free ( chunks); 03528 chunks);  used

3528DynaHashTable used

: DynaHashTable8192:  total in 81921 total in  blocks; 15080 blocks;  free
(50800 free ( chunks); 03112 chunks);  used

3112DynaHashTable used

: DynaHashTable8192:  total in 81921 total in  blocks; 15080 blocks;  free
(50800 free ( chunks); 03112 chunks);  used

3112DynaHashTable used

: DynaHashTable8192:  total in 81921 total in  blocks; 15080 blocks;  free
(50800 free ( chunks); 03112 chunks);  used

3112DynaHashTable used

: 0DynaHashTable total in : 00 total in  blocks; 00 blocks;  free (00 free
( chunks); 00 chunks);  used

0DynaHashTable used

: 0DynaHashTable total in : 00 total in  blocks; 00 blocks;  free (00 free
( chunks); 00 chunks);  used

0DynaHashTable used

: 0DynaHashTable total in : 00 total in  blocks; 00 blocks;  free (00 free
( chunks); 00 chunks);  used

0DynaHashTable used

: 0DynaHashTable total in : 00 total in  blocks; 00 blocks;  free (00 free
( chunks); 00 chunks);  used

0DynaHashTable used

: 0DynaHashTable total in : 00 total in  blocks; 00 blocks;  free (00 free
( chunks); 00 chunks);  used

0DynaHashTable used

: 0DynaHashTable total in : 00 total in  blocks; 00 blocks;  free (00 free
( chunks); 00 chunks);  used

0DynaHashTable used

: 0DynaHashTable total in : 00 total in  blocks; 00 blocks;  free (00 free
(TopMemoryContext0 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

DynaHashTableDynaHashTable: 0: 0 total in  total in 00 blocks;  blocks; 00
free ( free (00 chunks);  chunks); 00 used

used

ErrorContextErrorContext: : 81928192 total in  total in 11 blocks;  blocks;
81768176 free ( free (44 chunks);  chunks); 1616

used

used

: 2013-03-28 20:00:12 2013-03-28 20:00:12 FATAL:  out of memory

DETAIL:  Failed on request of size 112.

FATAL:  out of memory

DETAIL:  Failed on request of size 112.

24576TopMemoryContext total in TopMemoryContext2 blocks; 10272 free (2
chunks); 14304 used

CacheMemoryContext: 8192 total in 1 blocks; 2864 free (0 chunks); 5328 used

pg_class_oid_index: 1024 total in 1 blocks; 640 free (0 chunks); 384 used

MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used

DynaHash: 8192 total in 1 blocks; 4664 free (0 chunks); 3528 used

DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used

DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used

DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used

2013-03-28 20:00:12 FATAL:  out of memory

DETAIL:  Failed on request of size 112.

DETAIL:  Failed on request of size 112.

: 24576 total in 2 blocks; 10272 free (2 chunks); 14304 used

CacheMemoryContext: 8192 total in 1 blocks; 2864 free (0 chunks); 5328 used

pg_class_oid_index: 1024 total in 1 blocks; 640 free (0 chunks); 384 used

MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used

DynaHash: 8192 total in 1 blocks; 4664 free (0 chunks); 3528 used

DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used

DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used

DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used

2013-03-28 20:00:12 FATAL:  out of memory

DETAIL:  Failed on request of size 112.

2013-03-28 20:00:12 LOG:  connection received: host=[local] port=

2013-03-28 20:00:12 LOG:  connection authorized: user=mcdonner
database=template1

: 24576 total in 2 blocks; 10680 free (2 chunks); 13896 used

CacheMemoryContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used

MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used

DynaHash: 8192 total in 1 blocks; 4952 free (0 chunks); 3240 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

2013-03-28 20:00:12 LOG:  could not fork new process for connection: Not
enough space

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used

ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used

2013-03-28 20:00:12 FATAL:  out of memory

DETAIL:  Failed on request of size 1024.

2013-03-28 20:00:37 LOG:  could not fork checkpoint process: Not enough
space

2013-03-28 20:00:40 LOG:  server process (PID 224) was terminated by signal
11

2013-03-28 20:00:40 LOG:  terminating any other active server processes

2013-03-28 20:00:40 LOG:  all server processes terminated; reinitializing

2013-03-28 20:00:41 FATAL:  could not create shared memory segment: Not
enough space

DETAIL:  Failed system call was shmget(key=5432001, size=118464512, 03600).

HINT:  This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space

. To reduce the request size (currently 118464512 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 14080) and/

or its max_connections parameter (currently 40).

        The PostgreSQL documentation contains more information about shared
memory configuration.






============================================================================================================================Disclaimer:
 This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you
may review the policy at http://www.techmahindra.com/Disclaimer.html
externally and http://tim.techmahindra.com/tim/disclaimer.html
internally within Tech

Mahindra.============================================================================================================================

Re: FW: psql error

From
Albe Laurenz
Date:
archana shinde wrote:
> Please look at below mail and help me on this.

> Please could you help me to resolve this error which I am getting, I am using postgres  7.4.5  on
> solaris 9.

[...]

> 2013-03-28 20:00:12 FATAL:  out of memory
> DETAIL:  Failed on request of size 112.
[...]
> 2013-03-28 20:00:12 FATAL:  out of memory
> DETAIL:  Failed on request of size 1024.
> 2013-03-28 20:00:37 LOG:  could not fork checkpoint process: Not enough space
> 2013-03-28 20:00:40 LOG:  server process (PID 224) was terminated by signal 11
> 2013-03-28 20:00:40 LOG:  terminating any other active server processes
> 2013-03-28 20:00:40 LOG:  all server processes terminated; reinitializing
> 2013-03-28 20:00:41 FATAL:  could not create shared memory segment: Not enough space
> DETAIL:  Failed system call was shmget(key=5432001, size=118464512, 03600).
> HINT:  This error usually means that PostgreSQL's request for a shared memory segment exceeded
> available memory or swap space
> . To reduce the request size (currently 118464512 bytes), reduce PostgreSQL's shared_buffers parameter
> (currently 14080) and/
> or its max_connections parameter (currently 40).
>
>         The PostgreSQL documentation contains more information about shared memory configuration.

7.4 has been out of support for a while.

This looks like you cannot allocate enough shared memory.
If there is enough RAM in the machine, consider increasing
SHMALL (or maybe SHMMNI).

Yours,
Laurenz Albe