Re: puzzling perl DBI vs psql problem

Rob Sargent <robjsargent@xxxxxxxxx> · Thu, 13 Mar 2014 14:55:28 -0600



    On 03/13/2014 02:44 PM, Susan Cassidy
      wrote:

    
        No, I don't have 2 instances running.  I default the port
          on the psql command line, and the perl program is using 5432,
          as normal.

          
          Now, I'm discovering that syslog is no longer logging
          anything.  I bounced it, but to no avail.

          
        Susan

      
        On Thu, Mar 13, 2014 at 1:34 PM,
          Rodrigo Gonzalez <rjgonzale.lists@xxxxxxxxx>
          wrote:

          On Thu, 13
            Mar 2014 13:28:38 -0700

            Susan Cassidy <susan.cassidy@xxxxxxxxxxxxxxxxxxxxxxxx>
            wrote:

            
            > No, it is connecting to localhost, which is the same
            system I am

            > running psql on.

            >

            > Susan

            >

            Well, if one query is logged and the other one is not it
            means that it

            is running against different servers (as far as I understand

            logging)....

            
            Maybe psql is connecting using one socket and perl using
            another one?

            maybe you have 2 instances running?

          
    I would
        like to see the output of 

      
    ps auxw | grep p

        
    when
        each or both is running