FW: psql error - Mailing list pgsql-admin

From archana shinde
Subject FW: psql error
Date
Msg-id -1500769024086802266@iso-8859-1msgid
Whole thread Raw
List pgsql-admin
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.============================================================================================================================

pgsql-admin by date:

Previous
From: Armand du Plessis
Date:
Subject: Problems with pg_locks explosion
Next
From: "David Guyot (English)"
Date:
Subject: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?