Setting the Resource Limit on Open Files

Greenplum requires that the maximum number of files that can be opened is greater than or equal to 65535. You need to modify the /etc/security/limits.conf file. Perform the operations in this section on all nodes.

1. Open the /etc/security/limits.conf file.

   vim /etc/security/limits.conf

2. Press i to enter the insert mode and add the following content to the file:

   * soft nofile 65536
   * hard nofile 65536
   * soft nproc 131072
   * hard nproc 131072

3. Press Esc, type :wq!, and press Enter to save the file and exit.