7.2 Infinite CacheUnless otherwise noted, the commands and paths noted in the following section assume that you have performed an installation with the interactive installer.Please note: Infinite Cache has been deprecated and may be removed in a future release. Please contact your EnterpriseDB Account Manager or for more information.InfiniteCache allows Linux systems to utilize memory on other computers connected to their network to increase the amount of memory in the shared buffer cache. For more information about Infinite Cache functionality, please refer to the Postgres Plus Enterprise Edition Guide, available from the EnterpriseDB website at:After installing Advanced Server, you must provide configuration information for Infinite Cache, and start the service. You must:
2. Modify the Advanced Server postgresql.conf file, enabling Infinite Cache, and specifying connection and compression settings.The Infinite Cache configuration file is named ppas-infinitecache, and contains two parameters and their associated values:
The PORT variable specifies the port on which Infinite Cache listens for connections from the server. The CACHESIZE variable specifies the default cache size (in mega-bytes) By default, the file is located in the /opt/PostgresPlus/infinitecache/etc directory. To modify a parameter value, open the ppas-infinitecache file with your editor of choice, and edit the parameter values.To enable Infinite Cache, you must modify the postgresql.conf file, setting the values of the configuration parameters that control the behavior of Infinite Cache. To modify a parameter, open the postgresql.conf file (located in the data directory, under your Advanced Server installation), and locate the section of the configuration file shown below:# - Infinite Cache
#edb_enable_icache = off
#edb_icache_servers = '' #'host1:port1,host2,ip3:port3,ip4'
#edb_icache_compression_level = 6Within the postgresql.conf file, lines that begin with a pound sign (#) are treated as a comment; to edit a given parameter, remove the pound sign and specify a value for the parameter. When you've updated and saved the configuration file, restart the database server for the changes to take effect.
Use the edb_enable_icache parameter to enable or disable Infinite Cache. When edb_enable_icache is set to on, Infinite Cache is enabled; if the parameter is set to off, Infinite Cache is disabled.If you enable Infinite Cache, you must use the edb-icache_servers parameter to specify a list of cache servers. Use the edb_icache_servers parameter to specify a list of one or more servers with active edb-icache daemons. Specify a string value that takes the form of a comma-separated list of hostname:port pairs. You may specify a maximum of 128 cache nodes. edb_icache_compression_level controls the compression level that is applied to each page before storing it in the distributed cache. The parameter must be greater than or equal to 0 or less than or equal to 9.After specifying configuration options, you must start the Infinite Cache service. Before starting the service, ensure that the edb-icache daemons are running on each server specified in edb_icache_servers parameter.The Infinite Cache service script is named ppas-infinitecache. The service script resides in the /etc/init.d directory. You can control the Infinite Cache service, or check the status of the service with the following command:Where action specifies:
• start to start the service.
• stop to stop the service
• restart to stop and then start the service.
• status to return the status of the service.