Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page
От | Rajan Bhide |
---|---|
Тема | Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page |
Дата | |
Msg-id | FF851C7EEB75954F9BCFB5CA117AB1ECFC322F@delta.nulinkinc.com обсуждение исходный текст |
Ответ на | Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page ("Rajan Bhide" <rbhide@nulinkinc.com>) |
Список | 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 по дате отправления: