From: John Scalia <jayknowsunix@gmail.com>
To: naveen kumar <mnaveendba2@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: postgres log_destination question
Date: Sat, 28 Mar 2015 10:06:47 -0400
Message-ID: <5516B577.9070509@gmail.com> (raw)
In-Reply-To: <CADye41JsAvZb_4_9-K4o3Dpu068ZkF1X8gAcUvVNbdVapXXWZw@mail.gmail.com>
References: <CADye41JsAvZb_4_9-K4o3Dpu068ZkF1X8gAcUvVNbdVapXXWZw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 3/27/2015 8:33 PM, naveen kumar wrote:
> 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.
One thing that sticks out to me is "host=%r" should probably be "host=%h". not that I've checked what the %r stands for. What I'd do for the main problem, however, is check which
directory on each host is $PGDATA, as it sounds like one of your systems is looking for everything somewhere else and it could be reading a different postgresql.conf file.
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jayknowsunix@gmail.com, mnaveendba2@gmail.com
Subject: Re: postgres log_destination question
In-Reply-To: <5516B577.9070509@gmail.com>
* 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