>> Does stats collector process need any other special >> resource/privilege/operations/port to start? > If I understand correctly, it uses UDP. I don't think PostgreSQL > uses UDP outside of that. Still I'm not able to resolve/fix this statistics collector (not starting/working) in one of our customer production server and because of this autovacuum daemon is also not able to perform its job effectively, thereby it is indirectly impacting on the disk space growth. There are no anti-virus program running, no SE-Linux, etc. I've pasted below my "/etc/sysconfig/iptables" to reveal my firewall rules. Does PostgreSQL establish working UDP sockets on some specific defined port or it chooses the port randomly? Looking at experts guidance to resolve my issue. ================================= [root@dbserver ~]# more /etc/sysconfig/iptables # Generated by iptables-save v1.3.5 on Mon Sep 14 20:04:30 2009 *nat :PREROUTING ACCEPT [10934:1556118] :POSTROUTING ACCEPT [0:0] :OUTPUT ACCEPT [111392:6686084] -A PREROUTING -p tcp -m tcp --dport 80 -j REDIRECT --to-ports 5050 -A POSTROUTING -j MASQUERADE -A OUTPUT -d 192.168.0.200 -p tcp -m tcp --dport 80 -j DNAT --to-destination 192.168.0.200:5050 -A OUTPUT -d 127.0.0.1 -p tcp -m tcp --dport 80 -j DNAT --to-destination 127.0.0.1:5050 COMMIT # Completed on Mon Sep 14 20:04:30 2009 # Generated by iptables-save v1.3.5 on Mon Sep 14 20:04:30 2009 *filter :INPUT ACCEPT [0:0] :FORWARD ACCEPT [0:0] :OUTPUT ACCEPT [0:0] -A INPUT -j ACCEPT -A FORWARD -j ACCEPT -A OUTPUT -j ACCEPT COMMIT # Completed on Mon Sep 14 20:04:30 2009 ================================= -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
