X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B6BEFD1ED6B for ; Sun, 28 Mar 2004 15:28:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 67479-10 for ; Sun, 28 Mar 2004 11:28:56 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id E2A2AD1ED58 for ; Sun, 28 Mar 2004 11:28:54 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2SFSxMK015723; Sun, 28 Mar 2004 10:28:59 -0500 (EST) To: admin@usachurch.com Cc: pgsql-admin@postgresql.org Subject: Re: postgresql.conf file and logging questions In-reply-to: References: Comments: In-reply-to admin@usachurch.com message dated "Sat, 27 Mar 2004 18:32:37 -0700" Date: Sun, 28 Mar 2004 10:28:59 -0500 Message-ID: <15722.1080487739@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/365 X-Sequence-Number: 12934 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