ArcGIS Server Banner

LOGFILE DEFAULTS for PostgreSQL

LOGFILE DEFAULTS for PostgreSQL

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
In the PostgreSQL dbtune.sde file, most parameters are included twice—once with the default setting and once as a commented parameter to indicate the proper syntax for tablespace designation. This was done because the syntax for tablespace designation varies depending on the type of object created.

Use only one version of the parameter. In other words, if you want to specify a different tablespace for certain indexes, uncomment that line, specify a tablespace, then comment out or delete the default parameter. If you want, you can also alter the index fill factors.

##LOGFILE_DEFAULTS
LD_INDEX_ALL       "WITH (FILLFACTOR = 75)"
#LD_INDEX_ALL       "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name> "
LD_STORAGE         ""
#LD_STORAGE         "TABLESPACE <lower_case_name>"
LF_INDEX_ID        "WITH (FILLFACTOR = 75)"
#LF_INDEX_ID        "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name> "
LF_INDEX_NAME      "WITH (FILLFACTOR = 75)"
#LF_INDEX_NAME      "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name> "
LF_STORAGE         ""
#LF_STORAGE         "TABLESPACE <lower_case_name>"
SESSION_INDEX      "WITH (FILLFACTOR = 75)"
#SESSION_INDEX      "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name> "
SESSION_STORAGE    ""
#SESSION_STORAGE    "TABLESPACE <lower_case_name>"
SESSION_TEMP_TABLE 1
END

If you do not alter the values prior to geodatabase creation, you can use the sdeconfig command to set them after the geodatabase is set up. Consult the ArcSDE Administration Command Reference included with the ArcSDE component of ArcGIS Server Enterprise for details on the sdeconfig command.

See Also

  • Log file keywords
  • Log file configuration options