Message-ID: <5516B577.9070509@gmail.com>
Date: Sat, 28 Mar 2015 10:06:47 -0400
From: John Scalia <jayknowsunix@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:31.0) Gecko/20100101 Thunderbird/31.5.0
MIME-Version: 1.0
To: naveen kumar <mnaveendba2@gmail.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: postgres log_destination question
References: 
 <CADye41JsAvZb_4_9-K4o3Dpu068ZkF1X8gAcUvVNbdVapXXWZw@mail.gmail.com>
In-Reply-To: 
 <CADye41JsAvZb_4_9-K4o3Dpu068ZkF1X8gAcUvVNbdVapXXWZw@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------030501000504050106030902"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------030501000504050106030902
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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.

--------------030501000504050106030902
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <br>
    <br>
    <div class="moz-cite-prefix">On 3/27/2015 8:33 PM, naveen kumar
      wrote:<br>
    </div>
    <blockquote
cite="mid:CADye41JsAvZb_4_9-K4o3Dpu068ZkF1X8gAcUvVNbdVapXXWZw@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div>
          <div>
            <div>
              <div><span style="font-family:verdana,sans-serif">Hello
                  All,<br>
                  <br>
                </span></div>
            </div>
            <span style="font-family:verdana,sans-serif">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.<br>
            </span></div>
          <span style="font-family:verdana,sans-serif">and
            log_line_prefix is set to 'host=%r,user=%u,db=%d' but still
            some sqls are logging with out prifix. <br>
            <br>
          </span></div>
        <div><span style="font-family:verdana,sans-serif">Can any one
            help me on this please..</span><br>
        </div>
        <div>
          <div>
            <div>
              <div>
                <div>
                  <div><br clear="all">
                    <div>
                      <div>
                        <div class="gmail_signature">
                          <div dir="ltr"><font face="verdana,
                              sans-serif">Thanks &amp; Regards,<br>
                              M Naveen Kuamr,<br>
                              PostgreSQL Database Administrator, </font>
                            <div><font face="verdana, sans-serif">Mobile
                                Number: +91 7755929449. </font></div>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    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.<br>
  </body>
</html>

--------------030501000504050106030902--