OPTION

DESCRIPTION

DEFAULT

 data_directory

The default directory where EnterpriseDB will store data.  Set during installation.

 hba_file

Host Based Authentication file.  Authentication for IP and user access.

pg_hba.conf

ident_file

Ident authentication.

pg_ident.conf

listen_addresses

A list of IP addresses that the database will listen for connections.  To secure your system you can limit this to only certain addresses.  The keyword localhost will only allow local connections and using an * will allow connections from any address.  If you want to limit by IP, you can set this to * and use the pg_hba.conf file.

 port

Server TCP port that will be used to listen for connections.

5444

 max_connections

Maximum number of concurrent connections.  Each connection requires memory even if the connection is not being used.

100

 ssl

Enable ssl connections.

Off

 password_encryption

Encrypt user passwords.

On

edb_dynatune

Automatic resource tuning.  A very handy feature.  For development and testing it is a set it and forget about it feature.  For production you may want to tweak this parameter to get the best performance.

This value can be any number between 0 and 100.  If you set it to 1 EnterpriseDB will try to only use the least amount of available system resources.  Set it to 100 and EnterpriseDB will use the maximum amount of system resources.  If set to 0, automatic resource tuning is turned off.

The default is set during installation.  33% for development, 66% for mixed server and 100% for dedicated server.

 archive_command

This option sets the program that will be used to archive log files.  If it is empty, the database is not in archive log mode and that is a bad thing.  This program can be any third party utility or shell command.  It can be as simple as a cp or COPY command.

Unset

constraint_exclusion

This option will tell the optimizer to use check constraints when optimizing queries.  This will need to be on if you use partitioned tables.

Off

 log_destination

Type of system logging to enable, stderr, syslog (Linux), or the event log (MS-Windows).

stderr & syslog (Linux) or eventlog (MS-Windows)

redirect_stderr

Allow stderr to be redirected to a file.

On

log_directory

Directory to store system log files.

dbserver_logs

log_filename

Log file name as stored in the OS.  The file name can contain certain parameters:

%Y = Year

%m = Month

%d = day

%H = hour

%M = minute

%S = Second

log_%Y-%m%d_%H%M%S

will create a file name like:

log_2006-10-01_123208

enterprisedb-

%Y-%m-%d_

%H%M%S.log

 log_rotation_size

Size the system log file should be allowed to grow to before starting a new file.

102400

log_min_messages

The minimal level of message logging.  Values are DEBUG5-1, INFO, NOTICE, WARNING, and ERROR.  In a development environment, you may want to log at a DEBUG level.  In production, you may want to generate fewer messages.

NOTICE

stats_start_collector

Allows statistical information to be collected.

 On

stats_command_string

Collects statistics on each command that is run.  Set this to On.

Off

stats_block_level

Database block level statistics.  Set this on.

Off

stats_row_level

Row level statistics.  Set this to on.

On

autovacuum

Automatically clean up updated and deleted rows.  Should be set to on.

On

DateStyle

How should EnterpriseDB display dates.  Valid options are Redwood (DATE + TIME, DD-MON-YYYY), ISO, SQL or German. 

Redwood

edb_redwood_date

If on, creating a table with a DATE column will replace DATE with TIMESTAMP(0) so that DATE + TIME will be stored.  If this is off, the DATE will remain a DATE and no time component will be stored. 

On