Parent topic: Installing and Upgrading Greenplum Example iptables Rules To maintain the value after reboot, you can update the /etc/nf file as discussed in Setting the Greenplum Recommended OS Parameters. The value might need to be adjusted for your hosts. To ensure that the Greenplum Database workload does not overflow the iptables table, as root, set it to the following value: # sysctl _conntrack_max=6553600 ip_conntrack: table full, dropping packet.Īs root, run this command to view the iptables table value: # sysctl _conntrack_max Update the file /etc/sysconfig/iptables based on the Example iptables Rules.Īs root user, run these commands to enable iptables: # chkconfig iptables onĪs gpadmin, run this command on the Greenplum Database coordinator host to start Greenplum Database: $ gpstart -aĪfter enabling iptables, this error in the /var/log/messages file indicates that the setting for the iptables table is too low and needs to be increased.How to Enable iptablesĪs gpadmin, run this command on the Greenplum Database coordinator host to stop Greenplum Database: $ gpstop -a See also Deactivating SELinux and Firewall Software. You should test the performance of your application with iptables enabled to ensure that performance is acceptable.įor more information about iptables see the iptables and firewall documentation for your operating system. Greenplum Database performance might be impacted when iptables is enabled. On Linux systems, you can configure and enable the iptables firewall to work with Greenplum Database.

Iptables examples