Bueno, basicamente dmesg te esta diciendo que el link (o sea la actividad en la interfaz) fue y vino a su gusto durante un buen rato.
Revisa que el cable este correctamente enchufado en ambos extremos, switch e interfaz de red del server. Revisa que el cable funcione bien. Y comentale al administrador de red el problema con urgencia, puede ser tranquilamente un problema en el switch o en el port del mismo. De nuevo, esto NO es un problema de postgres, sino de redes. Con respecto a ulimit, la cantidad de file descriptors (flag -n en 1024) a mi entender es poca, pero no esta relacionado con el problema en cuestión. Saludos, Guido On Wed, Apr 7, 2010 at 3:56 PM, Edwin Quijada <[email protected]> wrote: > > > > Claramente un factor ajeno al servicio de Postgres. >> >> sudo dmesg y a ver que paso con la red >> > > Esto fue lo que consegui con dmesg que la verdad no entiedno mucho la > informacion > > diamante:/usr/local/pgsql/data# dmesg |grep eth0 > [ 1.758938] eth0: Broadcom NetXtreme II BCM5709 1000Base-T (C0) PCI > Express found at mem d6000000, IRQ 36, node addr 00:26:b9:3b:1b:c5 > [ 56.153764] bnx2: eth0: using MSIX > [ 56.291201] ADDRCONF(NETDEV_UP): eth0: link is not ready > [ 57.761598] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex > [ 57.761598] ADDRCONF(NETDEV_CHANGE): eth0: link becomes ready > [ 67.976423] eth0: no IPv6 routers present > [ 287.033502] bnx2: eth0 NIC Copper Link is Down > [ 311.706468] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex > [ 352.087214] bnx2: eth0 NIC Copper Link is Down > [ 389.746738] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex > [47733.700698] bnx2: eth0 NIC Copper Link is Down > [47830.642744] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex > [47830.843812] bnx2: eth0 NIC Copper Link is Down > [47839.438783] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex > [285342.817391] bnx2: eth0 NIC Copper Link is Down > [285344.438020] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex > [4001436.465577] bnx2: eth0 NIC Copper Link is Down > [4001438.572582] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex > [4002061.215076] bnx2: eth0 NIC Copper Link is Down > [4002063.044273] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex > [4002084.900365] bnx2: eth0 NIC Copper Link is Down > [4002086.452943] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex > [4003379.332121] bnx2: eth0 NIC Copper Link is Down > [4003383.829401] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex > [4003958.056174] bnx2: eth0 NIC Copper Link is Down > [4003964.530612] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex > [11481867.883010] bnx2: eth0 NIC Copper Link is Down > [11484966.345353] bnx2: eth0 NIC Copper Link is Up, 1000 Mbps full duplex > [11486137.815575] bnx2: eth0 NIC Copper Link is Down > [11486155.082838] bnx2: eth0 NIC Copper Link is Up, 1000 Mbps full duplex > [11489092.767044] bnx2: eth0 NIC Copper Link is Down > [11489095.800636] bnx2: eth0 NIC Copper Link is Up, 1000 Mbps full duplex > diamante:/usr/local/pgsql/data# > > ________________________________ -- TIP 8: explain analyze es tu amigo
