Postgresql.conf where to find

I am not sure if locate can be relied upon because the file and also its directory may be accessible exclusively by postgres or the products user only. A-B-B " I would not trust the output of locate. Now the cached data of locate is too old This is not reliable.

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. 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. Required to be on for csvlogs. 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. Eric Leschinski Eric Leschinski k 86 86 gold badges silver badges bronze badges. Joseph N. Feriman Feriman 3 3 silver badges 14 14 bronze badges. Dan Johnson 1, 16 16 silver badges 34 34 bronze badges.

Dell Kronewitter Dell Kronewitter 51 1 1 silver badge 3 3 bronze badges. Zihao Zhao Zihao Zhao 4 4 silver badges 9 9 bronze badges. Sampath Sampath Dinei Dinei 2, 3 3 gold badges 26 26 silver badges 54 54 bronze badges. This has changed with postgresql I'll update this comment when I find it — Gabriel Fair.

Milen A. Radev Milen A. Radev 5 5 silver badges 17 17 bronze badges. As Vinko said, the location is distribution-dependent. To add to his answer: Your package management sofware will tell you where are the files installed by each package, for example: dpkg -L postgresql.

Zstack Zstack 2 2 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Reload to refresh your session. You signed out in another tab or window. This file consists of lines of the form:. Whitespace may be used. Comments are introduced with.

The complete list of parameter names and allowed. 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;. Some parameters, which are marked below,.

Any parameter can also be given as a command-line option to the server, e. See also Section Specifies the name of an additional process-ID PID file that the server should create for use by server administration programs.

In a default installation, none of the above parameters are set explicitly. Instead, the data directory is specified by the -D command-line option or the PGDATA environment variable, and the configuration files are all found within the data directory.

When setting any of these parameters, a relative path will be interpreted with respect to the directory in which postgres is started.