FRAPID_LOCALHOST 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 WAL 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.
autovacuum_work_mem-1Sets the maximum memory to be used by each autovacuum worker process.
backend_flush_after0Number of pages after which previously performed writes are flushed to disk.
backslash_quotesafe_encodingSets whether "\'" is allowed in string literals.
bgwriter_delay200msBackground writer sleep time between rounds.
bgwriter_flush_after0Number of pages after which previously performed writes are flushed to disk.
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_flush_after0Number of pages after which previously performed writes are flushed to disk.
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.
cluster_nameSets the name of the cluster, which is included in the process title.
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_file/Library/PostgreSQL/10/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_directory/Library/PostgreSQL/10/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_assertionsoffShows whether the running server has assertion checks enabled.
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.
dynamic_shared_memory_typeposixSelects the dynamic shared memory implementation used.
effective_cache_size4GBSets 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_gathermergeonEnables the planner's use of gather merge 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.
force_parallel_modeoffForces use of parallel query facilities.
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.
gin_pending_list_limit4MBSets the maximum size of the pending list for GIN index.
hba_file/Library/PostgreSQL/10/data/pg_hba.confSets the server's "hba" configuration file.
hot_standbyonAllows connections and queries during recovery.
hot_standby_feedbackoffAllows feedback from a hot standby to the primary that will avoid query conflicts.
huge_pagestryUse of huge pages on Linux.
ident_file/Library/PostgreSQL/10/data/pg_ident.confSets the server's "ident" configuration file.
idle_in_transaction_session_timeout0Sets the maximum allowed duration of any idling transaction.
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_keyfileFILE:/mnt/hgfs/ the location of the Kerberos server key file.
lc_collateCShows the collation order locale.
lc_ctypeCShows the character classification and case conversion locale.
lc_messagesCSets the language in which messages are displayed.
lc_monetaryCSets the locale for formatting monetary amounts.
lc_numericCSets the locale for formatting numbers.
lc_timeCSets 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 unprivileged 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_directorylogSets 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%m [%p] 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_replication_commandsoffLogs each replication command.
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_mem64MBSets 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_logical_replication_workers4Maximum number of logical replication worker processes.
max_parallel_workers8Sets the maximum number of parallel workers that can be active at one time.
max_parallel_workers_per_gather2Sets the maximum number of parallel processes per executor node.
max_pred_locks_per_page2Sets the maximum number of predicate-locked tuples per page.
max_pred_locks_per_relation-2Sets the maximum number of predicate-locked pages and tuples per relation.
max_pred_locks_per_transaction64Sets the maximum number of predicate locks per transaction.
max_prepared_transactions0Sets the maximum number of simultaneously prepared transactions.
max_replication_slots10Sets the maximum number of simultaneously defined replication slots.
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_sync_workers_per_subscription2Maximum number of table synchronization workers per subscription.
max_wal_senders10Sets the maximum number of simultaneously running WAL sender processes.
max_wal_size1GBSets the WAL size that triggers a checkpoint.
max_worker_processes8Maximum number of concurrent worker processes.
min_parallel_index_scan_size512kBSets the minimum amount of index data for a parallel scan.
min_parallel_table_scan_size8MBSets the minimum amount of table data for a parallel scan.
min_wal_size80MBSets the minimum size to shrink the WAL to.
old_snapshot_threshold-1Time before a snapshot is too old to read pages changed after the snapshot was taken.
operator_precedence_warningoffEmit a warning for constructs that changed meaning since PostgreSQL 9.4.
parallel_setup_cost1000Sets the planner's estimate of the cost of starting up worker processes for parallel query.
parallel_tuple_cost0.1Sets the planner's estimate of the cost of passing each tuple (row) from worker to master backend.
password_encryptionmd5Encrypt passwords.
plpgsql.check_assertsonPerform checks given in ASSERT statements.
plpgsql.extra_errorsnoneList of programming constructs that should produce an error.
plpgsql.extra_warningsnoneList of programming constructs that should produce a warning.
plpgsql.print_strict_paramsoffPrint information about parameters in the DETAIL part of the error messages generated on INTO ... STRICT failures.
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.
replacement_sort_tuples150000Sets the maximum number of tuples to be sorted using replacement selection.
restart_after_crashonReinitialize server after backend crash.
row_securityonEnable row security.
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_version10.5Shows the server version.
server_version_num100005Shows the server version as an integer.
session_preload_librariesLists shared libraries to preload into each backend.
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.
ssloffEnables SSL connections.
ssl_ca_fileLocation of the SSL certificate authority file.
ssl_cert_fileserver.crtLocation of the SSL server certificate file.
ssl_ciphersHIGH:MEDIUM:+3DES:!aNULLSets the list of allowed SSL ciphers.
ssl_crl_fileLocation of the SSL certificate revocation list file.
ssl_dh_params_fileLocation of the SSL DH parameters file.
ssl_ecdh_curveprime256v1Sets the curve to use for ECDH.
ssl_key_fileserver.keyLocation of the SSL server private key file.
ssl_prefer_server_ciphersonGive priority to server ciphersuite order.
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_namesNumber of synchronous standbys and list of names of potential synchronous ones.
syslog_facilitylocal0Sets the syslog "facility" to be used when syslog enabled.
syslog_identpostgresSets the program name used to identify PostgreSQL messages in syslog.
syslog_sequence_numbersonAdd sequence number to syslog messages to avoid duplicate suppression.
syslog_split_messagesonSplit messages sent to syslog by lines and to fit into 1024 bytes.
tcp_keepalives_count0Maximum number of TCP keepalive retransmits.
tcp_keepalives_idle7200Time between issuing TCP keepalives.
tcp_keepalives_interval0Time 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 process.
temp_tablespacesSets the tablespace(s) to use for temporary tables and sort files.
TimeZoneAsia/KatmanduSets 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_commit_timestampoffCollects transaction commit time.
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_directories/tmpSets 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_compressionoffCompresses full-page writes written in WAL file.
wal_consistency_checkingSets the WAL resource managers for which WAL consistency checks are done.
wal_keep_segments0Sets the number of WAL files held for standby servers.
wal_levelreplicaSet the level of information written to the WAL.
wal_log_hintsoffWrites full pages to WAL when first modified after a checkpoint, even for a non-critical modifications.
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_retrieve_retry_interval5sSets the time to wait before retrying to retrieve WAL after a failed attempt.
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_delay200msTime between WAL flushes performed in the WAL writer.
wal_writer_flush_after1MBAmount of WAL written out by WAL writer that triggers a flush.
work_mem4MBSets 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.