configuring the postmaster.log

["Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>]

Title: Signature

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