Estimados Señores, Hace unos dias tengo un problema que hace que el postgres deje de funciona, cabe indicar que trabaja en un servidor Centos 6, con postgres 9-3 y pgbouncer, agradeceria si me pueden dar indicaciones de que informacion necesitan para poder brindarles. Yo adjunto informacion: - cpuinfo - meminfo - postgresql.conf - pg_hba.conf - pgbouncer.ini
Cabe indicar que estuvo funcionando correctamente, hasta que el viernes quitaron unas redes publicias, porque antes teniamos 3 y ahora solo hay una. Desde ahi a ciertas horas se cae el postgres pero el apache sigue funcionando. Gracias, *Flor de María A. Avila Elias*
processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 42 model name : Intel(R) Core(TM) i5-2500K CPU @ 3.30GHz stepping : 7 microcode : 45 cpu MHz : 3601.000 cache size : 6144 KB physical id : 0 siblings : 4 core id : 0 cpu cores : 4 apicid : 0 initial apicid : 0 fpu : yes fpu_exception : yes cpuid level : 13 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm pcid sse4_1 sse4_2 popcnt tsc_deadline_timer aes xsave avx lahf_lm ida arat epb xsaveopt pln pts dtherm pti retpoline tpr_shadow vnmi flexpriority ept vpid ibpb ibrs bogomips : 6584.66 clflush size : 64 cache_alignment : 64 address sizes : 36 bits physical, 48 bits virtual power management: processor : 1 vendor_id : GenuineIntel cpu family : 6 model : 42 model name : Intel(R) Core(TM) i5-2500K CPU @ 3.30GHz stepping : 7 microcode : 45 cpu MHz : 1600.000 cache size : 6144 KB physical id : 0 siblings : 4 core id : 1 cpu cores : 4 apicid : 2 initial apicid : 2 fpu : yes fpu_exception : yes cpuid level : 13 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm pcid sse4_1 sse4_2 popcnt tsc_deadline_timer aes xsave avx lahf_lm ida arat epb xsaveopt pln pts dtherm pti retpoline tpr_shadow vnmi flexpriority ept vpid ibpb ibrs bogomips : 6584.66 clflush size : 64 cache_alignment : 64 address sizes : 36 bits physical, 48 bits virtual power management: processor : 2 vendor_id : GenuineIntel cpu family : 6 model : 42 model name : Intel(R) Core(TM) i5-2500K CPU @ 3.30GHz stepping : 7 microcode : 45 cpu MHz : 3601.000 cache size : 6144 KB physical id : 0 siblings : 4 core id : 2 cpu cores : 4 apicid : 4 initial apicid : 4 fpu : yes fpu_exception : yes cpuid level : 13 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm pcid sse4_1 sse4_2 popcnt tsc_deadline_timer aes xsave avx lahf_lm ida arat epb xsaveopt pln pts dtherm pti retpoline tpr_shadow vnmi flexpriority ept vpid ibpb ibrs bogomips : 6584.66 clflush size : 64 cache_alignment : 64 address sizes : 36 bits physical, 48 bits virtual power management: processor : 3 vendor_id : GenuineIntel cpu family : 6 model : 42 model name : Intel(R) Core(TM) i5-2500K CPU @ 3.30GHz stepping : 7 microcode : 45 cpu MHz : 1600.000 cache size : 6144 KB physical id : 0 siblings : 4 core id : 3 cpu cores : 4 apicid : 6 initial apicid : 6 fpu : yes fpu_exception : yes cpuid level : 13 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm pcid sse4_1 sse4_2 popcnt tsc_deadline_timer aes xsave avx lahf_lm ida arat epb xsaveopt pln pts dtherm pti retpoline tpr_shadow vnmi flexpriority ept vpid ibpb ibrs bogomips : 6584.66 clflush size : 64 cache_alignment : 64 address sizes : 36 bits physical, 48 bits virtual power management:
"postgres" "Gepesat2012" "gpnext" "Gepesat2012"
MemTotal: 3906016 kB MemFree: 223604 kB Buffers: 62048 kB Cached: 2780520 kB SwapCached: 0 kB Active: 1863556 kB Inactive: 1464504 kB Active(anon): 958236 kB Inactive(anon): 561488 kB Active(file): 905320 kB Inactive(file): 903016 kB Unevictable: 0 kB Mlocked: 0 kB SwapTotal: 4046844 kB SwapFree: 4046844 kB Dirty: 9844 kB Writeback: 8 kB AnonPages: 485648 kB Mapped: 882460 kB Shmem: 1034108 kB Slab: 237496 kB SReclaimable: 144216 kB SUnreclaim: 93280 kB KernelStack: 5776 kB PageTables: 47484 kB NFS_Unstable: 0 kB Bounce: 0 kB WritebackTmp: 0 kB CommitLimit: 5999852 kB Committed_AS: 7930848 kB VmallocTotal: 34359738367 kB VmallocUsed: 102912 kB VmallocChunk: 34359606756 kB HardwareCorrupted: 0 kB AnonHugePages: 122880 kB HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: 2048 kB DirectMap4k: 8000 kB DirectMap2M: 4169728 kB
pgbouncer.ini
Description: Binary data
pg_hba.conf
Description: Binary data
postgresql.conf
Description: Binary data
