AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Postgresql mac port12/4/2023 #wal_level = minimal # minimal, archive, or hot_standby #bgwriter_lru_multiplier = 2.0 # 0-10.0 multipler on buffers scanned/round #bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round #bgwriter_delay = 200ms # 10-10000ms between rounds #vacuum_cost_delay = 0ms # 0-100 milliseconds #shared_preload_libraries = '' # (change requires restart) # actively intend to use prepared transactions. # It is not advisable to set max_prepared_transactions nonzero unless you # per transaction slot, plus lock space (see max_locks_per_transaction). # Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory #max_prepared_transactions = 0 # zero disables the feature #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds #krb_srvname = 'postgres' # (Kerberos only) #ssl_renegotiation_limit = 512MB # amount of data between renegotiations #bonjour_name = '' # defaults to the computer name #bonjour = off # advertise server via Bonjour #unix_socket_permissions = 0777 # begin with 0 to use octal notation #unix_socket_group = '' # (change requires restart) #unix_socket_directories = '/var/run/postgresql, /tmp' #superuser_reserved_connections = 3 # (change requires restart) # connection slot, plus lock space (see max_locks_per_transaction). # Note: Increasing max_connections costs ~400 bytes of shared memory per Max_connections = 100 # (change requires restart) # Note: In RHEL/Fedora installations, you can't set the port number here #listen_addresses = 'localhost' # what IP address(es) to listen on #external_pid_file = '(none)' # write an extra PID file # If external_pid_file is not explicitly set, no extra PID file is written. #ident_file = 'ConfigDir/pg_nf' # ident configuration file #hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file #data_directory = 'ConfigDir' # use data in another directory # option or PGDATA environment variable, represented here as ConfigDir. # The default values of these variables are driven from the -D command-line # Memory units: kB = kilobytes Time units: ms = milliseconds Some parameters can be changed at run time # Any parameter can also be given as a command-line option to the server, e.g., # parameters, which are marked below, require a server shutdown and restart to # server for the changes to take effect, or use "pg_ctl reload". If you edit the file on a running system, you have to SIGHUP the # This file is read on server startup and when the server receives a SIGHUP # Re-commenting a setting is NOT sufficient to revert it to the default value # The commented-out settings shown in this file represent the default values. # values can be found in the PostgreSQL documentation. The complete list of parameter names and allowed # (The "=" is optional.) Whitespace may be used. # This file consists of lines of the form: The location of nf will be different depending on what operating system you are using. It has permission 600 which explains why you have a hard time finding it with a file search. Notice it is owned by postgres: -rw- 1 postgres postgres 19332 Oct 14 09:38 Here is where mine is on Fedora 17: /]# ll /var/lib/pgsql/data/nf The reason you may have trouble finding nf is because it is owned by postgres, not root. Query the database with the sql query: SHOW config_file
0 Comments
Read More
Leave a Reply. |