Re: postgres log_destination question

John Scalia <jayknowsunix@xxxxxxxxx> · Sat, 28 Mar 2015 10:06:47 -0400



    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.