pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: admin@usachurch.com
Cc: pgsql-admin@postgresql.org
Subject: Re: postgresql.conf file and logging questions
Date: Sun, 28 Mar 2004 10:28:59 -0500
Message-ID: <15722.1080487739@sss.pgh.pa.us> (raw)
In-Reply-To: <p06020435bc8bdba83519@[192.168.123.110]>
References: <p06020435bc8bdba83519@[192.168.123.110]>

admin@usachurch.com writes:
> 1.  Where should the postgresql.conf file be to be recognized by the 
> service on startup?  currently, it is inside my $PGDATA directory but 
> all of its contents are commented out.

That's the correct file.  Uncomment anything you want to change.

> 2.  I can't find any log files for postgres.  Inside my /var/log/ 
> directory, there is an empty
> file called pgsql.  What do I have to do to get it to log errors, 
> etc.

If you want to use that file you could add "-l /var/log/pgsql" to the
pg_ctl start command in your PG startup script.

> Is there a difference between normal logging and syslog logging?

Yes, one goes to a file and the other to syslog ;-)

I'd recommend syslog on the whole, since you don't normally have to
worry about rotating logfiles when you use syslog.

			regards, tom lane



view thread (3+ messages)  latest in thread

Message-ID: <15722.1080487739@sss.pgh.pa.us>
Permalink:  ../15722.1080487739@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/15722.1080487739@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, admin@usachurch.com
  Subject: Re: postgresql.conf file and logging questions
  In-Reply-To: <15722.1080487739@sss.pgh.pa.us>
  References: <p06020435bc8bdba83519@[192.168.123.110]> <15722.1080487739@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox