Pivotal Knowledge Base


Database Creation Error: "Out of Shared-Memory for Persistent Databases"


  • Pivotal Greenplum Database (GPDB) 4.3.x
  • Operating System- All supported


When you attempt to create more than 256 databases, it is not possible to create all of them, and the following error is thrown:

PANIC:  Out of shared-memory for persistent databaseS (cdbpersistentdatabase.c:528)
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
connection to server was lost


The three parameters below limit the persistent entries for the number of directories:

  • gp_max_databases - Max # of databases : Default 16, Max value is 256
  • gp_max_filespaces - Max # of file spaces : Default 8, Max value is 256
  • gp_max_tablespaces - Max # of tablespaces : Default 16, Max value is 2048

The maximum number of database directories is calculated by gp_max_databases * gp_max_tablespaces. The default is 16 * 64, or 256.


Increasing the values of gp_max_database / gp_max_filespace / gp_max_tablespace to 64 on your $MASTER_DATA_DIRECTORY/postgresql.conf file would help you add more databases to your cluster.


Powered by Zendesk