FW: psql error

From: archana shinde <archii4u(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: FW: psql error
Date: 2013-04-02 06:25:48
Message-ID: -1500769024086802266@unknownmsgid
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Please look at below mail and help me on this.
------------------------------
From: Archana.2.Shinde
Sent: 02-04-2013 11:53
To: archii4u(at)gmail(dot)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.============================================================================================================================

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Guyot (English) 2013-04-02 14:29:34 Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?
Previous Message Armand du Plessis 2013-04-01 22:09:12 Problems with pg_locks explosion