Thread: postgresql.conf

postgresql.conf

From
"Jim Kunkel"
Date:
The docs suggest the file "postgresql.conf" is a method of configuring the db engine.  I want to turn on logging.  The line "DEBUG_PRETTY_PRINT=1" should turn on tracing.  I just can't figure out where the file goes.  The filename (postgresql.conf) doesn't seem to be in the sources I hunted through and if I search for it on the web site, I get an internal error.  Can someone point me to the right directory?  Better yet, can you point me to the spot in the documentation that tells me that?

Re: postgresql.conf

From
"Josh Berkus"
Date:
Jim,

> The docs suggest the file "postgresql.conf" is a method of
> configuring the db engine.  I want to turn on logging.  The line
> "DEBUG_PRETTY_PRINT=1" should turn on tracing.  I just can't figure
> out where the file goes.  The filename (postgresql.conf) doesn't seem
> to be in the sources I hunted through and if I search for it on the
> web site, I get an internal error.  Can someone point me to the right
> directory?  Better yet, can you point me to the spot in the
> documentation that tells me that?

Postgresql.conf is loacted in your pgsql/data directory.  For example,
mine is at /usr/local/pgsql/data/postgresql.conf.

However, logging usually needs to be set whough the command line which
starts postmaster.  The debug levels just set what gets logged once
logging is started.  There aren't good docs on this that I know of
online.  Try some of the PostgreSQL books out there.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

Attachment

Re: postgresql.conf

From
Joel Burton
Date:
On Tue, 16 Oct 2001, Jim Kunkel wrote:

> The docs suggest the file "postgresql.conf" is a method of configuring
> the db engine.  I want to turn on logging.  The line
> "DEBUG_PRETTY_PRINT=1" should turn on tracing.  I just can't figure
> out where the file goes.  The filename (postgresql.conf) doesn't seem
> to be in the sources I hunted through and if I search for it on the
> web site, I get an internal error.  Can someone point me to the right
> directory?  Better yet, can you point me to the spot in the
> documentation that tells me that?

In your PGDATA directory. For RPMS, this is often /var/lib/pgsql/.
The file should already exist after a successful installation.

--

Joel BURTON  |  joel@joelburton.com  |  http://joelburton.com  |  aim: wjoelburton
Independent Knowledge Management Consultant