Hi,
On Mon, 31 Mar 2003, Delao, Darryl W wrote:
> How about sending log messages to a single file. I see a file under var/log
> called pgsql, but it has nothing in it. What do I need to enable in the
> postgreql.conf to start logging to a local file?
Start PostgreSQL with -l parameter:
pg_ctl .... -l /var/log/pgsql
If you are using an rpm-based installation; edit the init script of
PostgreSQL (usually under /etc/init.d) and add -l parameter to start line,
i.e.
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -l /var/log/pgsql -D
$PGDATA -p /usr/bin/postmaster start > /dev/null 2>&1" < /dev/null
Regards,
--
Devrim GUNDUZ
devrim@gunduz.org devrim.gunduz@linux.org.tr
http://www.gunduz.org