From: | "Rajan Bhide" <rbhide(at)nulinkinc(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-novice(at)postgresql(dot)org>, " Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Subject: | Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page |
Date: | 2004-05-31 12:30:30 |
Message-ID: | FF851C7EEB75954F9BCFB5CA117AB1ECFC322F@delta.nulinkinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | derrick | 2004-05-31 15:04:50 | Re: Dynamic Array into pl/pgSQL function |
Previous Message | Oliver Elphick | 2004-05-31 07:03:54 | Re: Dynamic Array into pl/pgSQL function |