Where are my postgres conf files

Question

I have recently reinstalled postgresql 8 3 on my Ubuntu 8 04 after update  Used EnterpriseDB package  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  Searched through entire hard drive and found only samples like pg hba conf sample  Where are the postgres   conf files

User · Answer

If you followed the white paper put out by Amazon for installing Postgresql on AWS, which included creating a /data/ directory on a filesystem mounted on a separate EBS volume, then your postgresql.conf file is in /data/

From which I conclude the file is created during initialisation of the data directory, and resides in the root of the data dir. For a default install this appears to be /var/lib/pgsql/data, but not if you moved the data dir

User · Answer

I like this thread because it documents the default locations for various postgresql conf files on various architectures     However  I ve also gotten in trouble by relying on those defaults on installations where they have specified alternate locations  One way to find out where a particular config file is by querying the database directly   select   from pg settings where name  config file   Drop the where clause to see all the settings  which can also be illuminating because it shows where data directories  pg hba conf  etc  are

User · Answer

In CentOS 7 with PostgreSQL 9 4 it s in the following directory     var lib pgsql 9 4 data   I can see it when I m logged in as root

User · Answer

Print pg hba conf file location   su - postgres -c  psql -t -P format unaligned -c  show hba file      Print postgresql conf file location   su - postgres -c  psql -t -P format unaligned -c  SHOW config file

User · Answer

On Fedora 20    cd  var lib pgsql data   ls -ltr   conf  -rw-------  1 postgres postgres 20453 Jan 18 23 22 postgresql conf -rw-------  1 postgres postgres  1636 Jan 18 23 22 pg ident conf -rw-------  1 postgres postgres  4476 Jan 18 23 22 pg hba conf

User · Answer

nantha   SHOW config file                  config file   var lib postgresql data postgresql conf  1 row   nantha   SHOW hba file                  hba file   var lib postgresql data pg hba conf  1 row

User · Answer

on MacOS Mojave where I used brew install postgresql to install  I found it here   usr local var postgres postgresql conf  I got this using the following sql command cited in this response here    psql -U postgres -c  SHOW config file

User · Answer

Run  sudo updatedb   followed by  locate postgresql conf

User · Answer

To get the location of the pg hba conf file  you can also query the database like  SHOW hba file    You should get something like              hba file              ---------------------------------   var lib pgsql data pg hba conf  1 row

User · Answer

Win7  version 10 location   C  Program Files PostgreSQL 10 postgresql conf

User · Answer

As I don t have access to postgres account  so can t run SHOW config file  and my postgres is installed on Windows  none of the answers helped me  so I m sharing my file location for future Windows readers   C  Program Files PostgreSQL 9 5 data

User · Answer

For CentOS 6 and 7 and postgresql 9 2  and below  I suppose  possibly Fedora and Redhat as well     var lib pgsql data  For CentOS 6 and 7 postgresql 9 3 or 9 4  and above  I suppose     var lib pgsql 9 3 data  var lib pgsql 9 4 data   For Ubuntu 14 and postgresql 9 3     etc postgresql 9 3 main postgresql conf

User · Answer

On Mac OS X   sudo find   -name postgresql conf    You can find other conf files by the following command   sudo find   -name pg   conf   Note  See usage using man   man find

User · Answer

My installation is not default  but you can go to directory the Postgres and find subdirectory  Data    Configuration Files C  Postgres Data postgresql conf C  Postgres Data pg hba conf

User · Answer

Ubuntu 13 04 installed using software centre    The location for mine is    etc postgresql 9 1 main postgresql conf

User · Answer

If you have just installed it  it is possible that locate doesn t help  In that case  the service should be running and you can run  ps aux    grep  postgres  -D    to see where the postgresql-master is loading the config files from

User · Answer

The answer may be that you have not initialized the database yet    After installing postgres  but before initializing the database  the postgres  sql files will be absent    After initializing the database the postgres  sql files will appear    Centos 6  Postgres 9 3 demonstrated here    root localhost     yum -y install postgresql93 postgresql93-server   root localhost     ls  var lib pgsql 9 3 data   root localhost      root localhost     service postgresql-9 3 initdb Initializing database                                         OK     root localhost     ls  var lib pgsql 9 3 data  base         pg ident conf  pg serial     pg subtrans  pg xlog global       pg log         pg snapshots  pg tblspc    postgresql conf pg clog      pg multixact   pg stat       pg twophase pg hba conf  pg notify      pg stat tmp   PG VERSION  root localhost

User · Answer

Besides the direct answer  you will probably want to check out the docs about Postgres config file locations   In most cases  under  PGDATA  which is normally  var lib postgresql data or something similar  at least it s the default path if you use Docker images

User · Answer

Or ask your database    psql -U postgres -c  SHOW config file   or  if logged in as the ubuntu user    sudo -u postgres psql -c  SHOW config file

User · Answer

30-07-2019  In Windows 10 pro   C  Program Files PostgreSQL 11 data

User · Answer

Where are my postgres   conf files   Query the database with the sql query   SHOW config file    The reason you may have trouble finding postgresql conf is because it is owned by postgres  not root   Here is where mine is on Fedora 17     root defiant     ll  var lib pgsql data postgresql conf    Notice it is owned by postgres   -rw------- 1 postgres postgres 19332 Oct 14 09 38        var lib pgsql data postgresql conf   It has permission 600 which explains why you have a hard time finding it with a file search   The location of postgresql conf will be different depending on what operating system you are using     Here is the contents of mine     -----------------------------   PostgreSQL configuration file   -----------------------------     This file consists of lines of the form        name   value      The     is optional    Whitespace may be used   Comments are introduced with       anywhere on a line   The complete list of parameter names and allowed   values can be found in the PostgreSQL documentation      The commented-out settings shown in this file represent the default values    Re-commenting a setting is NOT sufficient to revert it to the default value    you need to reload the server      This file is read on server startup and when the server receives a SIGHUP   signal   If you edit the file on a running system  you have to SIGHUP the   server for the changes to take effect  or use  pg ctl reload    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    Some parameters can be changed at run time   with the  SET  SQL command      Memory units   kB   kilobytes        Time units   ms    milliseconds                  MB   megabytes                     s     seconds                  GB   gigabytes                     min   minutes                                                     h     hours                                                     d     days    ------------------------------------------------------------------------------   FILE LOCATIONS  ------------------------------------------------------------------------------    The default values of these variables are driven from the -D command-line   option or PGDATA environment variable  represented here as ConfigDir    data directory    ConfigDir          use data in another directory                        change requires restart   hba file    ConfigDir pg hba conf    host-based authentication file                        change requires restart   ident file    ConfigDir pg ident conf    ident configuration file                        change requires restart     If external pid file is not explicitly set  no extra PID file is written   external pid file     none           write an extra PID file                        change requires restart     ------------------------------------------------------------------------------   CONNECTIONS AND AUTHENTICATION  ------------------------------------------------------------------------------    - Connection Settings -   listen addresses    localhost        what IP address es  to listen on                         comma-separated list of addresses                        defaults to  localhost         all                        change requires restart   port   5432                   change requires restart    Note  In RHEL Fedora installations  you can t set the port number here    adjust it in the service file instead  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    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  ADH  LOW  EXP  MD5  STRENGTH     allowed SSL ciphers                        change requires restart   ssl renegotiation limit   512MB      amount of data between renegotiations  password encryption   on  db user namespace   off    Kerberos and GSSAPI  krb server keyfile       krb srvname    postgres           Kerberos only   krb caseins users   off    - TCP Keepalives -   see  man 7 tcp  for details   tcp keepalives idle   0          TCP KEEPIDLE  in seconds                        0 selects the system default  tcp keepalives interval   0          TCP KEEPINTVL  in seconds                        0 selects the system default  tcp keepalives count   0         TCP KEEPCNT                        0 selects the system default    ------------------------------------------------------------------------------   RESOURCE USAGE  except WAL   ------------------------------------------------------------------------------    - Memory -  shared buffers   24MB             min 128kB                        change requires restart   temp buffers   8MB           min 800kB  max prepared transactions   0        zero disables the feature                        change requires restart    Note   Increasing max prepared transactions costs  600 bytes of shared memory   per transaction 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   work mem   1MB               min 64kB  maintenance work mem   16MB          min 1MB  max stack depth   2MB            min 100kB    - 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  0 disables prefetching    ------------------------------------------------------------------------------   WRITE AHEAD LOG  ------------------------------------------------------------------------------    - Settings -   wal level   minimal              minimal  archive  or hot standby                        change requires restart   fsync   on               turns forced synchronization on or off  synchronous commit   on          synchronization level  on  off  or local  wal sync method   fsync          the default is the first option                       supported by the operating system                          open datasync                         fdatasync  default on Linux                          fsync                         fsync writethrough                         open sync  full page writes   on            recover from partial page writes  wal buffers   -1             min 32kB  -1 sets based on shared buffers                        change requires restart   wal writer delay   200ms         1-10000 milliseconds   commit delay   0             range 0-100000  in microseconds  commit siblings   5              range 1-1000    - Checkpoints -   checkpoint segments   3          in logfile segments  min 1  16MB each  checkpoint timeout   5min        range 30s-1h  checkpoint completion target   0 5   checkpoint target duration  0 0 - 1 0  checkpoint warning   30s         0 disables    - Archiving -   archive mode   off       allows archiving to be done                    change requires restart   archive command              command to use to archive a logfile segment  archive timeout   0          force a logfile segment switch after this                   number of seconds  0 disables    ------------------------------------------------------------------------------   REPLICATION  ------------------------------------------------------------------------------    - Master Server -    These settings are ignored on a standby server   max wal senders   0          max number of walsender processes                    change requires restart   wal sender delay   1s        walsender cycle time  1-10000 milliseconds  wal keep segments   0        in logfile segments  16MB each  0 disables  vacuum defer cleanup age   0     number of xacts by which cleanup is delayed  replication timeout   60s    in milliseconds  0 disables  synchronous standby names        standby servers that provide sync rep                   comma-separated list of application name                   from standby s         all    - Standby Servers -    These settings are ignored on a master server   hot standby   off             on  allows queries during recovery                        change requires restart   max standby archive delay   30s      max delay before canceling queries                       when reading WAL from archive                        -1 allows indefinite delay  max standby streaming delay   30s    max delay before canceling queries                       when reading streaming WAL                        -1 allows indefinite delay  wal receiver status interval   10s   send replies at least this often                       0 disables  hot standby feedback   off       send info from standby to prevent                       query conflicts    ------------------------------------------------------------------------------   QUERY TUNING  ------------------------------------------------------------------------------    - Planner Method Configuration -   enable bitmapscan   on  enable hashagg   on  enable hashjoin   on  enable indexscan   on  enable material   on  enable mergejoin   on  enable nestloop   on  enable seqscan   on  enable sort   on  enable tidscan   on    - Planner Cost Constants -   seq page cost   1 0              measured on an arbitrary scale  random page cost   4 0           same scale as above  cpu tuple cost   0 01            same scale as above  cpu index tuple cost   0 005         same scale as above  cpu operator cost   0 0025       same scale as above  effective cache size   128MB    - Genetic Query Optimizer -   geqo   on  geqo threshold   12  geqo effort   5              range 1-10  geqo pool size   0           selects default based on effort  geqo generations   0             selects default based on effort  geqo selection bias   2 0        range 1 5-2 0  geqo seed   0 0              range 0 0-1 0    - Other Planner Options -   default statistics target   100      range 1-10000  constraint exclusion   partition     on  off  or partition  cursor tuple fraction   0 1          range 0 0-1 0  from collapse limit   8  join collapse limit   8          1 disables collapsing of explicit                       JOIN clauses    ------------------------------------------------------------------------------   ERROR REPORTING AND LOGGING  ------------------------------------------------------------------------------    - Where to Log -   log destination    stderr        Valid values are combinations of                       stderr  csvlog  syslog  and eventlog                        depending on platform   csvlog                       requires logging collector to be on     This is used when logging to stderr  logging collector   on            Enable capturing of stderr and csvlog                       into log files  Required to be on for                       csvlogs                         change requires restart     These are only used if logging collector is on   log directory    pg log          directory where log files are written                        can be absolute or relative to PGDATA log filename    postgresql- a log     log file name pattern                        can include strftime   escapes  log file mode   0600             creation mode for log files                        begin with 0 to use octal notation log truncate on rotation   on         If on  an existing log file with the                       same name as the new log file will be                       truncated rather than appended to                        But such truncation only occurs on                       time-driven rotation  not on restarts                       or size-driven rotation   Default is                       off  meaning append to existing files                       in all cases  log rotation age   1d             Automatic rotation of logfiles will                       happen after that time   0 disables  log rotation size   0             Automatic rotation of logfiles will                       happen after that much log output                        0 disables     These are relevant when logging to syslog   syslog facility    LOCAL0   syslog ident    postgres    silent mode   off            Run server silently                        DO NOT USE without syslog or                       logging collector                        change requires restart      - When to Log -   client min messages   notice         values in order of decreasing detail                          debug5                         debug4                         debug3                         debug2                         debug1                         log                         notice                         warning                         error   log min messages   warning       values in order of decreasing detail                          debug5                         debug4                         debug3                         debug2                         debug1                         info                         notice                         warning                         error                         log                         fatal                         panic   log min error statement   error      values in order of decreasing detail                          debug5                         debug4                         debug3                         debug2                         debug1                         info                         notice                         warning                         error                         log                         fatal                         panic  effectively off    log min duration statement   -1      -1 is disabled  0 logs all statements                       and their durations   gt  0 logs only                       statements running at least this number                       of milliseconds     - What to Log -   debug print parse   off  debug print rewritten   off  debug print plan   off  debug pretty print   on  log checkpoints   off  log connections   off  log disconnections   off  log duration   off  log error verbosity   default        terse  default  or verbose messages  log hostname   off  log line prefix                  special values                           a   application name                          u   user name                          d   database name                          r   remote host and port                          h   remote host                          p   process ID                          t   timestamp without milliseconds                          m   timestamp with milliseconds                          i   command tag                          e   SQL state                          c   session ID                          l   session line number                          s   session start timestamp                          v   virtual transaction ID                          x   transaction ID  0 if none                           q   stop here in non-session                              processes                                                        e g    lt  u   d gt     log lock waits   off             log lock waits  gt   deadlock timeout  log statement    none            none  ddl  mod  all  log temp files   -1              log temporary files equal or larger                       than the specified size in kilobytes                        -1 disables  0 logs all temp files  log timezone     defaults to server environment setting      ------------------------------------------------------------------------------   RUNTIME STATISTICS  ------------------------------------------------------------------------------    - Query Index Statistics Collector -   track activities   on  track counts   on  track functions   none           none  pl  all  track activity query size   1024      change requires restart   update process title   on  stats temp directory    pg stat tmp      - Statistics Monitoring -   log parser stats   off  log planner stats   off  log executor stats   off  log statement stats   off    ------------------------------------------------------------------------------   AUTOVACUUM PARAMETERS  ------------------------------------------------------------------------------   autovacuum   on              Enable autovacuum subprocess    on                        requires track counts to also be on   log autovacuum min duration   -1     -1 disables  0 logs all actions and                       their durations   gt  0 logs only                       actions running at least this number                       of milliseconds   autovacuum max workers   3       max number of autovacuum subprocesses                        change requires restart   autovacuum naptime   1min        time between autovacuum runs  autovacuum vacuum threshold   50     min number of row updates before                       vacuum  autovacuum analyze threshold   50    min number of row updates before                       analyze  autovacuum vacuum scale factor   0 2     fraction of table size before vacuum  autovacuum analyze scale factor   0 1    fraction of table size before analyze  autovacuum freeze max age   200000000    maximum XID age before forced vacuum                        change requires restart   autovacuum vacuum cost delay   20ms      default vacuum cost delay for                       autovacuum  in milliseconds                        -1 means use vacuum cost delay  autovacuum vacuum cost limit   -1    default vacuum cost limit for                       autovacuum  -1 means use                       vacuum cost limit    ------------------------------------------------------------------------------   CLIENT CONNECTION DEFAULTS  ------------------------------------------------------------------------------    - Statement Behavior -   search path      user  public        schema names  default tablespace               a tablespace name     uses the default  temp tablespaces                 a list of tablespace names     uses                       only default tablespace  check function bodies   on  default transaction isolation    read committed   default transaction read only   off  default transaction deferrable   off  session replication role    origin   statement timeout   0            in milliseconds  0 is disabled  vacuum freeze min age   50000000  vacuum freeze table age   150000000  bytea output    hex              hex  escape  xmlbinary    base64   xmloption    content     - Locale and Formatting -  datestyle    iso  mdy   intervalstyle    postgres   timezone     defaults to server environment setting    timezone abbreviations    Default        Select the set of available time zone                       abbreviations   Currently  there are                         Default                         Australia                         India                       You can create your own file in                       share timezonesets    extra float digits   0           min -15  max 3  client encoding   sql ascii          actually  defaults to database                       encoding    These settings are initialized by initdb  but they can be changed  lc messages    en US UTF-8            locale for system error message                       strings lc monetary    en US UTF-8            locale for monetary formatting lc numeric    en US UTF-8             locale for number formatting lc time    en US UTF-8                locale for time formatting    default configuration for text search default text search config    pg catalog english     - Other Defaults -   dynamic library path     libdir   local preload libraries         ------------------------------------------------------------------------------   LOCK MANAGEMENT  ------------------------------------------------------------------------------   deadlock timeout   1s  max locks per transaction   64       min 10                        change requires restart    Note   Each lock table slot uses  270 bytes of shared memory  and there are   max locks per transaction    max connections   max prepared transactions    lock table slots   max pred locks per transaction   64      min 10                        change requires restart    ------------------------------------------------------------------------------   VERSION PLATFORM COMPATIBILITY  ------------------------------------------------------------------------------    - Previous PostgreSQL Versions -   array nulls   on  backslash quote   safe encoding      on  off  or safe encoding  default with oids   off  escape string warning   on  lo compat privileges   off  quote all identifiers   off  sql inheritance   on  standard conforming strings   on  synchronize seqscans   on    - Other Platforms and Clients -   transform null equals   off    ------------------------------------------------------------------------------   ERROR HANDLING  ------------------------------------------------------------------------------   exit on error   off                  terminate session on any error   restart after crash   on             reinitialize after backend crash     ------------------------------------------------------------------------------   CUSTOMIZED OPTIONS  ------------------------------------------------------------------------------   custom variable classes              list of custom variable class names

User · Answer

On Mac  Postgres installed using brew      usr local Cellar postgresql 9 3 3 gt bin postgres -D  usr local var postgres

User · Answer

For Debian 9 I found mine using Franke Heikens answer -    etc postgresql 9 6 main postgresql conf

[postgresql] Where are my postgres *.conf files?

Examples related to postgresql

Examples related to configuration

Examples related to ubuntu-8.04