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
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