MIXERP Server Configuration

Property Name Setting Description
allow_system_table_modsoffAllows modifications of the structure of system tables.
application_nameSets the application name to be reported in statistics and logs.
archive_command(disabled)Sets the shell command that will be called to archive a WAL file.
archive_modeoffAllows archiving of WAL files using archive_command.
archive_timeout0Forces a switch to the next xlog file if a new file has not been started within N seconds.
array_nullsonEnable input of NULL elements in arrays.
authentication_timeout1minSets the maximum allowed time to complete client authentication.
autovacuumonStarts the autovacuum subprocess.
autovacuum_analyze_scale_factor0.1Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.
autovacuum_analyze_threshold50Minimum number of tuple inserts, updates, or deletes prior to analyze.
autovacuum_freeze_max_age200000000Age at which to autovacuum a table to prevent transaction ID wraparound.
autovacuum_max_workers3Sets the maximum number of simultaneously running autovacuum worker processes.
autovacuum_multixact_freeze_max_age400000000Multixact age at which to autovacuum a table to prevent multixact wraparound.
autovacuum_naptime1minTime to sleep between autovacuum runs.
autovacuum_vacuum_cost_delay20msVacuum cost delay in milliseconds, for autovacuum.
autovacuum_vacuum_cost_limit-1Vacuum cost amount available before napping, for autovacuum.
autovacuum_vacuum_scale_factor0.2Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.
autovacuum_vacuum_threshold50Minimum number of tuple updates or deletes prior to vacuum.
backslash_quotesafe_encodingSets whether "\'" is allowed in string literals.
bgwriter_delay200msBackground writer sleep time between rounds.
bgwriter_lru_maxpages100Background writer maximum number of LRU pages to flush per round.
bgwriter_lru_multiplier2Multiple of the average buffer usage to free per round.
block_size8192Shows the size of a disk block.
bonjouroffEnables advertising the server via Bonjour.
bonjour_nameSets the Bonjour service name.
bytea_outputhexSets the output format for bytea.
check_function_bodiesonCheck function bodies during CREATE FUNCTION.
checkpoint_completion_target0.5Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.
checkpoint_segments3Sets the maximum distance in log segments between automatic WAL checkpoints.
checkpoint_timeout5minSets the maximum time between automatic WAL checkpoints.
checkpoint_warning30sEnables warnings if checkpoint segments are filled more frequently than this.
client_encodingUTF8Sets the client's character set encoding.
client_min_messagesnoticeSets the message levels that are sent to the client.
commit_delay0Sets the delay in microseconds between transaction commit and flushing WAL to disk.
commit_siblings5Sets the minimum concurrent open transactions before performing commit_delay.
config_fileC:/Program Files/PostgreSQL/9.3/data/postgresql.confSets the server's main configuration file.
constraint_exclusionpartitionEnables the planner to use constraints to optimize queries.
cpu_index_tuple_cost0.005Sets the planner's estimate of the cost of processing each index entry during an index scan.
cpu_operator_cost0.0025Sets the planner's estimate of the cost of processing each operator or function call.
cpu_tuple_cost0.01Sets the planner's estimate of the cost of processing each tuple (row).
cursor_tuple_fraction0.1Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
data_checksumsoffShows whether data checksums are turned on for this cluster.
data_directoryC:/Program Files/PostgreSQL/9.3/dataSets the server's data directory.
DateStyleISO, MDYSets the display format for date and time values.
db_user_namespaceoffEnables per-database user names.
deadlock_timeout1sSets the time to wait on a lock before checking for deadlock.
debug_assertionsoffTurns on various assertion checks.
debug_pretty_printonIndents parse and plan tree displays.
debug_print_parseoffLogs each query's parse tree.
debug_print_planoffLogs each query's execution plan.
debug_print_rewrittenoffLogs each query's rewritten parse tree.
default_statistics_target100Sets the default statistics target.
default_tablespaceSets the default tablespace to create tables and indexes in.
default_text_search_configpg_catalog.englishSets default text search configuration.
default_transaction_deferrableoffSets the default deferrable status of new transactions.
default_transaction_isolationread committedSets the transaction isolation level of each new transaction.
default_transaction_read_onlyoffSets the default read-only status of new transactions.
default_with_oidsoffCreate new tables with OIDs by default.
dynamic_library_path$libdirSets the path for dynamically loadable modules.
effective_cache_size128MBSets the planner's assumption about the size of the disk cache.
effective_io_concurrency0Number of simultaneous requests that can be handled efficiently by the disk subsystem.
enable_bitmapscanonEnables the planner's use of bitmap-scan plans.
enable_hashaggonEnables the planner's use of hashed aggregation plans.
enable_hashjoinonEnables the planner's use of hash join plans.
enable_indexonlyscanonEnables the planner's use of index-only-scan plans.
enable_indexscanonEnables the planner's use of index-scan plans.
enable_materialonEnables the planner's use of materialization.
enable_mergejoinonEnables the planner's use of merge join plans.
enable_nestlooponEnables the planner's use of nested-loop join plans.
enable_seqscanonEnables the planner's use of sequential-scan plans.
enable_sortonEnables the planner's use of explicit sort steps.
enable_tidscanonEnables the planner's use of TID scan plans.
escape_string_warningonWarn about backslash escapes in ordinary string literals.
event_sourcePostgreSQLSets the application name used to identify PostgreSQL messages in the event log.
exit_on_erroroffTerminate session on any error.
external_pid_fileWrites the postmaster PID to the specified file.
extra_float_digits3Sets the number of digits displayed for floating-point values.
from_collapse_limit8Sets the FROM-list size beyond which subqueries are not collapsed.
fsynconForces synchronization of updates to disk.
full_page_writesonWrites full pages to WAL when first modified after a checkpoint.
geqoonEnables genetic query optimization.
geqo_effort5GEQO: effort is used to set the default for other GEQO parameters.
geqo_generations0GEQO: number of iterations of the algorithm.
geqo_pool_size0GEQO: number of individuals in the population.
geqo_seed0GEQO: seed for random path selection.
geqo_selection_bias2GEQO: selective pressure within the population.
geqo_threshold12Sets the threshold of FROM items beyond which GEQO is used.
gin_fuzzy_search_limit0Sets the maximum allowed result for exact search by GIN.
hba_fileC:/Program Files/PostgreSQL/9.3/data/pg_hba.confSets the server's "hba" configuration file.
hot_standbyoffAllows connections and queries during recovery.
hot_standby_feedbackoffAllows feedback from a hot standby to the primary that will avoid query conflicts.
ident_fileC:/Program Files/PostgreSQL/9.3/data/pg_ident.confSets the server's "ident" configuration file.
ignore_checksum_failureoffContinues processing after a checksum failure.
ignore_system_indexesoffDisables reading from system indexes.
integer_datetimesonDatetimes are integer based.
IntervalStylepostgresSets the display format for interval values.
join_collapse_limit8Sets the FROM-list size beyond which JOIN constructs are not flattened.
krb_caseins_usersoffSets whether Kerberos and GSSAPI user names should be treated as case-insensitive.
krb_server_keyfileSets the location of the Kerberos server key file.
krb_srvnamepostgresSets the name of the Kerberos service.
lc_collateEnglish_United States.1252Shows the collation order locale.
lc_ctypeEnglish_United States.1252Shows the character classification and case conversion locale.
lc_messagesEnglish_United States.1252Sets the language in which messages are displayed.
lc_monetaryCSets the locale for formatting monetary amounts.
lc_numericEnglish_United States.1252Sets the locale for formatting numbers.
lc_timeEnglish_United States.1252Sets the locale for formatting date and time values.
listen_addresses*Sets the host name or IP address(es) to listen to.
lo_compat_privilegesoffEnables backward compatibility mode for privilege checks on large objects.
local_preload_librariesLists shared libraries to preload into each backend.
lock_timeout0Sets the maximum allowed duration of any wait for a lock.
log_autovacuum_min_duration-1Sets the minimum execution time above which autovacuum actions will be logged.
log_checkpointsoffLogs each checkpoint.
log_connectionsoffLogs each successful connection.
log_destinationstderrSets the destination for server log output.
log_directorypg_logSets the destination directory for log files.
log_disconnectionsoffLogs end of a session, including duration.
log_durationoffLogs the duration of each completed SQL statement.
log_error_verbositydefaultSets the verbosity of logged messages.
log_executor_statsoffWrites executor performance statistics to the server log.
log_file_mode0600Sets the file permissions for log files.
log_filenamepostgresql-%Y-%m-%d_%H%M%S.logSets the file name pattern for log files.
log_hostnameoffLogs the host name in the connection logs.
log_line_prefix%t Controls information prefixed to each log line.
log_lock_waitsoffLogs long lock waits.
log_min_duration_statement-1Sets the minimum execution time above which statements will be logged.
log_min_error_statementerrorCauses all statements generating error at or above this level to be logged.
log_min_messageswarningSets the message levels that are logged.
log_parser_statsoffWrites parser performance statistics to the server log.
log_planner_statsoffWrites planner performance statistics to the server log.
log_rotation_age1dAutomatic log file rotation will occur after N minutes.
log_rotation_size10MBAutomatic log file rotation will occur after N kilobytes.
log_statementnoneSets the type of statements logged.
log_statement_statsoffWrites cumulative performance statistics to the server log.
log_temp_files-1Log the use of temporary files larger than this number of kilobytes.
log_timezoneAsia/KatmanduSets the time zone to use in log messages.
log_truncate_on_rotationoffTruncate existing log files of same name during log rotation.
logging_collectoronStart a subprocess to capture stderr output and/or csvlogs into log files.
maintenance_work_mem16MBSets the maximum memory to be used for maintenance operations.
max_connections100Sets the maximum number of concurrent connections.
max_files_per_process1000Sets the maximum number of simultaneously open files for each server process.
max_function_args100Shows the maximum number of function arguments.
max_identifier_length63Shows the maximum identifier length.
max_index_keys32Shows the maximum number of index keys.
max_locks_per_transaction64Sets the maximum number of locks per transaction.
max_pred_locks_per_transaction64Sets the maximum number of predicate locks per transaction.
max_prepared_transactions0Sets the maximum number of simultaneously prepared transactions.
max_stack_depth2MBSets the maximum stack depth, in kilobytes.
max_standby_archive_delay30sSets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.
max_standby_streaming_delay30sSets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.
max_wal_senders0Sets the maximum number of simultaneously running WAL sender processes.
password_encryptiononEncrypt passwords.
plpgsql.variable_conflicterrorSets handling of conflicts between PL/pgSQL variable names and table column names.
port5432Sets the TCP port the server listens on.
post_auth_delay0Waits N seconds on connection startup after authentication.
pre_auth_delay0Waits N seconds on connection startup before authentication.
quote_all_identifiersoffWhen generating SQL fragments, quote all identifiers.
random_page_cost4Sets the planner's estimate of the cost of a nonsequentially fetched disk page.
restart_after_crashonReinitialize server after backend crash.
search_path"$user",publicSets the schema search order for names that are not schema-qualified.
segment_size1GBShows the number of pages per disk file.
seq_page_cost1Sets the planner's estimate of the cost of a sequentially fetched disk page.
server_encodingUTF8Sets the server (database) character set encoding.
server_version9.3.4Shows the server version.
server_version_num90304Shows the server version as an integer.
session_replication_roleoriginSets the session's behavior for triggers and rewrite rules.
shared_buffers128MBSets the number of shared memory buffers used by the server.
shared_preload_librariesLists shared libraries to preload into server.
sql_inheritanceonCauses subtables to be included by default in various commands.
ssloffEnables SSL connections.
ssl_ca_fileLocation of the SSL certificate authority file.
ssl_cert_fileserver.crtLocation of the SSL server certificate file.
ssl_ciphersDEFAULT:!LOW:!EXP:!MD5:@STRENGTHSets the list of allowed SSL ciphers.
ssl_crl_fileLocation of the SSL certificate revocation list file.
ssl_key_fileserver.keyLocation of the SSL server private key file.
ssl_renegotiation_limit0Set the amount of traffic to send and receive before renegotiating the encryption keys.
standard_conforming_stringsonCauses '...' strings to treat backslashes literally.
statement_timeout0Sets the maximum allowed duration of any statement.
stats_temp_directorypg_stat_tmpWrites temporary statistics files to the specified directory.
superuser_reserved_connections3Sets the number of connection slots reserved for superusers.
synchronize_seqscansonEnable synchronized sequential scans.
synchronous_commitonSets the current transaction's synchronization level.
synchronous_standby_namesList of names of potential synchronous standbys.
syslog_facilitynoneSets the syslog "facility" to be used when syslog enabled.
syslog_identpostgresSets the program name used to identify PostgreSQL messages in syslog.
tcp_keepalives_count0Maximum number of TCP keepalive retransmits.
tcp_keepalives_idle-1Time between issuing TCP keepalives.
tcp_keepalives_interval-1Time between TCP keepalive retransmits.
temp_buffers8MBSets the maximum number of temporary buffers used by each session.
temp_file_limit-1Limits the total size of all temporary files used by each session.
temp_tablespacesSets the tablespace(s) to use for temporary tables and sort files.
TimeZoneUTCSets the time zone for displaying and interpreting time stamps.
timezone_abbreviationsDefaultSelects a file of time zone abbreviations.
trace_notifyoffGenerates debugging output for LISTEN and NOTIFY.
trace_recovery_messageslogEnables logging of recovery-related debugging information.
trace_sortoffEmit information about resource usage in sorting.
track_activitiesonCollects information about executing commands.
track_activity_query_size1024Sets the size reserved for pg_stat_activity.query, in bytes.
track_countsonCollects statistics on database activity.
track_functionsnoneCollects function-level statistics on database activity.
track_io_timingoffCollects timing statistics for database I/O activity.
transaction_deferrableoffWhether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
transaction_isolationread committedSets the current transaction's isolation level.
transaction_read_onlyoffSets the current transaction's read-only status.
transform_null_equalsoffTreats "expr=NULL" as "expr IS NULL".
unix_socket_directoriesSets the directories where Unix-domain sockets will be created.
unix_socket_groupSets the owning group of the Unix-domain socket.
unix_socket_permissions0777Sets the access permissions of the Unix-domain socket.
update_process_titleonUpdates the process title to show the active SQL command.
vacuum_cost_delay0Vacuum cost delay in milliseconds.
vacuum_cost_limit200Vacuum cost amount available before napping.
vacuum_cost_page_dirty20Vacuum cost for a page dirtied by vacuum.
vacuum_cost_page_hit1Vacuum cost for a page found in the buffer cache.
vacuum_cost_page_miss10Vacuum cost for a page not found in the buffer cache.
vacuum_defer_cleanup_age0Number of transactions by which VACUUM and HOT cleanup should be deferred, if any.
vacuum_freeze_min_age50000000Minimum age at which VACUUM should freeze a table row.
vacuum_freeze_table_age150000000Age at which VACUUM should scan whole table to freeze tuples.
vacuum_multixact_freeze_min_age5000000Minimum age at which VACUUM should freeze a MultiXactId in a table row.
vacuum_multixact_freeze_table_age150000000Multixact age at which VACUUM should scan whole table to freeze tuples.
wal_block_size8192Shows the block size in the write ahead log.
wal_buffers4MBSets the number of disk-page buffers in shared memory for WAL.
wal_keep_segments0Sets the number of WAL files held for standby servers.
wal_levelminimalSet the level of information written to the WAL.
wal_receiver_status_interval10sSets the maximum interval between WAL receiver status reports to the primary.
wal_receiver_timeout1minSets the maximum wait time to receive data from the primary.
wal_segment_size16MBShows the number of pages per write ahead log segment.
wal_sender_timeout1minSets the maximum time to wait for WAL replication.
wal_sync_methodopen_datasyncSelects the method used for forcing WAL updates to disk.
wal_writer_delay200msWAL writer sleep time between WAL flushes.
work_mem1MBSets the maximum memory to be used for query workspaces.
xmlbinarybase64Sets how binary values are to be encoded in XML.
xmloptioncontentSets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
zero_damaged_pagesoffContinues processing past damaged page headers.