Re: puzzling perl DBI vs psql problem

Поиск
Список
Период
Сортировка
От Dennis Jenkins
Тема Re: puzzling perl DBI vs psql problem
Дата
Msg-id CAAEzAp9G22i2BSSr1crz-VMF7dien9vJie8g36Jy7VZ0=jEH-Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: puzzling perl DBI vs psql problem  (Susan Cassidy <susan.cassidy@decisionsciencescorp.com>)
Ответы Re: puzzling perl DBI vs psql problem
Список pgsql-general
Дерево обсуждения
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.cassidy@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.lists@gmail.com> wrote:
On Thu, 13 Mar 2014 13:28:38 -0700
Susan Cassidy <susan.cassidy@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?


В списке pgsql-general по дате отправления:

Предыдущее
От: Susan Cassidy
Дата:
Сообщение: Re: puzzling perl DBI vs psql problem
Следующее
От: Rodrigo Gonzalez
Дата:
Сообщение: Re: puzzling perl DBI vs psql problem