max_connections = 100 # (change requires restart) # Note: Increasing max_connections costs ~400 bytes of shared memory per # connection slot, plus lock space (see max_locks_per_transaction). # It is not advisable to set max_prepared_transactions nonzero unless you # actively intend to use prepared transactions.

#superuser_reserved_connections = 3 # (change requires restart) #unix_socket_directories = '/var/run/postgresql, /tmp' # comma-separated list of directories # (change requires restart) #unix_socket_group = '' # (change requires restart) #unix_socket_permissions = 0777 # begin with 0 to use octal notation # (change requires restart) #bonjour = off # advertise server via Bonjour # (change requires restart) #bonjour_name = '' # defaults to the computer name # (change requires restart) # - Security and Authentication - #authentication_timeout = 1min # 1s-600s #ssl = off # (change requires restart) #ssl_ciphers = 'ALL:! #work_mem = 1MB # min 64k B #maintenance_work_mem = 16MB # min 1MB #max_stack_depth = 2MB # min 100k B # - Kernel Resource Usage - #max_files_per_process = 1000 # min 25 # (change requires restart) #shared_preload_libraries = '' # (change requires restart) # - Cost-Based Vacuum Delay - #vacuum_cost_delay = 0ms # 0-100 milliseconds #vacuum_cost_page_hit = 1 # 0-10000 credits #vacuum_cost_page_miss = 10 # 0-10000 credits #vacuum_cost_page_dirty = 20 # 0-10000 credits #vacuum_cost_limit = 200 # 1-10000 credits # - Background Writer - #bgwriter_delay = 200ms # 10-10000ms between rounds #bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round #bgwriter_lru_multiplier = 2.0 # 0-10.0 multipler on buffers scanned/round # - Asynchronous Behavior - #effective_io_concurrency = 1 # 1-1000.

In Linux each programmer is free to choose the configuration file format he or she prefers.

Format options range from the /etc/shells file, which contains a list of possible shells separated by a newline, to Apache's complex /etc/file.

Some # parameters, which are marked below, require a server shutdown and restart to # take effect.

# # Any parameter can also be given as a command-line option to the server, e.g., # "postgres -c log_connections=on".

Default is # off, meaning append to existing files # in all cases.

log_rotation_age = 1d # Automatic rotation of logfiles will # happen after that time. log_rotation_size = 0 # Automatic rotation of logfiles will # happen after that much log output. # These are relevant when logging to syslog: #syslog_facility = 'LOCAL0' #syslog_ident = 'postgres' #silent_mode = off # Run server silently.

However, I've also gotten in trouble by relying on those defaults on installations where they have specified alternate locations.

Every Linux program is an executable file holding the list of opcodes the CPU executes to accomplish specific operations.

I have recently reinstalled postgresql 8.3 on my Ubuntu 8.04 after update. I can connect to the database locally, I see system DB postgres but I can't configure it because I can't find config files.