configuring the postmaster.log

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: configuring the postmaster.log
Date: 2007-01-11 12:07:08
Message-ID: CA896D7906BF224F8A6D74A1B7E54AB301750961@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I'm confused about the logging destination parameters in
postgresql.conf

My Problem is that the postmaster.log is getting too large and I want to
roll it (once per day)

Following parameters apply to optional postgresql...log.

log_rotation_age = 1440
log_filename = 'postgresql-%Y-%m-%d_%H.log'

Is there a way to use a similar definition for the postmaster.log ?

When I generate postgresql...log files, are log messages written in
both
postmaster.log and postgresql.log ?

I guess I don't understand the meaning of these two different logging
destination.

Moreover, I'm catching the error stream in a perl application to log
errors:

$sth = $dbh->prepare( "select ..." );
$sth->execute ()||
print (STDERR "PG error:" . $sth->errstr ."\n") && exit 1;
$sth->finish;

Will I still get the postgres error in perl if I set redirect_stderr =
on in postgresql.conf ?





Thanks,

Marc


Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Shellam (Mailing Lists) 2007-01-11 12:24:26 Re: configuring the postmaster.log
Previous Message Andy Shellam (Mailing Lists) 2007-01-11 10:54:09 Re: Can not connect to database in Workgroup-Net on Windows-XP