The only one that comes out different is inet_server_addr, via the program, it comes out: ::1 whereas via psql it comes out empty.
Yes, I am 100% sure I am using the same schema (which I never specify, so I am using 'public') and the same user and database. Susan On Thu, Mar 13, 2014 at 1:53 PM, Dennis Jenkins <dennis.jenkins...@gmail.com > wrote: > 1) > Run both "psql" and "perl" under "strace" and search the output for which > sockets it connects to. > eg, strace -o /tmp/psql.log psql -Upgsql -dmydatabase -c"select > version();" > > > 2) > Add a query into your perl script to perform the following SQL and print > the results: > > select current_database(); > select current_schema(); > select inet_server_addr(); > select current_user; > (and others, see > http://www.postgresql.org/docs/9.3/static/functions-info.html for more > functions) > Do the same from your "psql". Compare the output. Are you 110% sure that > you are connecting to the same database, as the same user, and using the > same schema? > > > > > On Thu, Mar 13, 2014 at 3:44 PM, Susan Cassidy < > susan.cass...@decisionsciencescorp.com> 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.li...@gmail.com> wrote: >> >>> On Thu, 13 Mar 2014 13:28:38 -0700 >>> Susan Cassidy <susan.cass...@decisionsciencescorp.com> 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? >>> >> >> >
