From: Pallav Kalva <pkalva@deg.cc>
To: pgsql-admin@postgresql.org
Subject: Postgres 8.0 Log Configuration
Date: Fri, 21 Jan 2005 11:15:25 -0500
Message-ID: <41F12A9D.6050706@deg.cc> (raw)
Hi,
Whenever i start my postgres 8 server i do "pg_ctl restart -D
/var/lib/pgsql/data -l /var/log/postgresql/postmaster" where
/var/log/postgresql/ is the dir and postmaster is the output log file
for all postgres logging and errors. This above command works fine and
logs all the postgres related messages into the specified filename. But
I dont want to specify the "-l /var/log/postgresql/postmaster" option
everytime I start the postmaster. I want to set the logfile name in the
postgresql.conf file, i used the following setting :
log_destination = 'syslog,stderr'
redirect_stderr = true
log_directory = '/var/lib/pgsql/'
log_filename = 'postmaster.log'
But still whenever i start my postgres server some of the messages
are not logged into the specified logfile name in the postgresq.conf
file and it is printing the log messages on the command line like this :
$ pg_ctl restart -m f -D /var/lib/pgsql/data -o "-p 5432"
waiting for postmaster to shut down....2005-01-21 10:37:13 EST%% LOG:
logger shutting down
done
postmaster stopped
postmaster starting
$ 2005-01-21 10:37:15 EST%% LOG: could not create IPv6 socket: Address
family not supported by protocol
I want all the postgres related messages to be logged into the file
in "log_filename" parameter specified in postgresql.conf . I tried
changing "log_destination" parameter to syslog only or stderr only but
still no change. am I missing something here ? or this is not
possible with the postgresql.conf
Thanks in advance.
Pallav
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: pkalva@deg.cc
Subject: Re: Postgres 8.0 Log Configuration
In-Reply-To: <41F12A9D.6050706@deg.cc>
References: <41F12A9D.6050706@deg.cc>
* 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