Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page - Mailing list pgsql-novice

From Rajan Bhide
Subject Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page
Date
Msg-id FF851C7EEB75954F9BCFB5CA117AB1ECFC322F@delta.nulinkinc.com
Whole thread Raw
In response to Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page  ("Rajan Bhide" <rbhide@nulinkinc.com>)
List pgsql-novice
> 5) What additional logs should be monitored/enabled to get more help
to resolve this problem?

To enable statistics collection I updated few related entries in
postgresql.conf file but got following msg.

$ 2004-05-28 08:13:01 LOG:  could not bind socket for statistics
collector: Cannot assign requested address
2004-05-28 08:13:01 LOG:  database system was shut down at 2004-05-28
08:13:00 GMT
2004-05-28 08:13:01 LOG:  checkpoint record is at 80/89392010
2004-05-28 08:13:01 LOG:  redo record is at 80/89392010; undo record is
at 0/0; shutdown TRUE
2004-05-28 08:13:01 LOG:  next transaction ID: 124196777; next OID:
237888262
2004-05-28 08:13:01 LOG:  database system is ready

Whats the reason for this?
I am starting Postmaster with -o -I option. (Enabled TCP/IP
communication)

The localhost is avaliable in /etc/hosts file.

$)ifconfig -a
lo0: flags=1000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4> mtu 8232 index 1
        inet 127.0.0.1 netmask ff000000
eri0: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index
2
        inet 10.2.5.3 netmask ffff0000 broadcast 10.2.255.255
eri1: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index
3
        inet 192.168.206.2 netmask ffffff00 broadcast 192.168.206.255

$)nslookup localhost
Server:  <undisclosed>
Address:  12.33.234.50

Name:    localhost
Address:  127.0.0.1

$)more /etc/hosts
127.0.0.1       localhost


$)more /etc/inet/ipnodes
#
# Internet host table
#
::1             localhost
127.0.0.1       localhost


Thanks,
Rajan Bhide


pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Dynamic Array into pl/pgSQL function
Next
From: "derrick"
Date:
Subject: Re: Dynamic Array into pl/pgSQL function