Postgres Pro
Downloads
Home   >   mailing lists

postgres log_destination question - Mailing list pgsql-admin

From naveen kumar
Subject postgres log_destination question
Date
Msg-id CADye41JsAvZb_4_9-K4o3Dpu068ZkF1X8gAcUvVNbdVapXXWZw@mail.gmail.com
Whole thread Raw
Responses Re: postgres log_destination question  (John Scalia <jayknowsunix@gmail.com>)
List pgsql-admin
Tree view
Hello All,

I have configured postgresql on 2 machines. on both machines I have setup log_destination = 'syslog' and log_directory='pg_log'. if check logs on both machines, on one machine logs are moved to /var/log/pg_log and another one logs are moved to syslog only.
and log_line_prefix is set to 'host=%r,user=%u,db=%d' but still some sqls are logging with out prifix.

Can any one help me on this please..

Thanks & Regards,
M Naveen Kuamr,
PostgreSQL Database Administrator, 
Mobile Number: +91 7755929449. 

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: postgres hot-standby questions.
Next
From: Venkata Balaji N
Date:
Subject: Re: pg_xlog-files not deleted on a standby after accidental server crash