Re: puzzling perl DBI vs psql problem

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(dot)cassidy(at)decisionsciencescorp(dot)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(dot)lists(at)gmail(dot)com> wrote:
>
>> On Thu, 13 Mar 2014 13:28:38 -0700
>> Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)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?
>>
>
>