Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Felipe Pereira 
2016-10-24 11:37 GMT-02:00 Luiz Carlos L. Nogueira Jr. <
lcnogueir...@gmail.com>:

> Flávio,
>
> Funcionou
>
> ignore_startup_parameters = extra_float_digits,application_name,geqo
>
> Só não sei as consequências disso...
>
> Desculpa os aperreios aí.
>
> ___
> pgbr-geral mailing list
> pgbr-geral@listas.postgresql.org.br
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>


Link do parâmetro:
https://www.postgresql.org/docs/current/static/geqo-pg-intro.html

Ele controla o comportamento do planejador de queries.

O servidor tem um valor default para este parâmetro, então tirá-lo da sua
conexão não deverá afetar o comportamento do seu sistema.Isto só
aconteceria caso você estivesse explicitamente configurando um valor
diferente do servidor por algum motivo especial (o que não parece ser o
caso mesmo).
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Luiz Carlos L. Nogueira Jr. 
Flávio,

Funcionou

ignore_startup_parameters = extra_float_digits,application_name,geqo

Só não sei as consequências disso...

Desculpa os aperreios aí.
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Luiz Carlos L. Nogueira Jr. 
ignore_startup_parameters = extra_float_digits,application_name,geco


ERROR: Unsupported startup parameter: geqo {08P01,NativeErr = 210}
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Luiz Carlos L. Nogueira Jr. 
Puts. Foi mal de novo, mas às vezes o gmail os ... somem
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Flavio Henrique Araque Gurgel 
Em seg, 24 de out de 2016 às 15:18, Luiz Carlos L. Nogueira Jr. <
lcnogueir...@gmail.com> escreveu:

> Flávio,
>
> Colocando esse parâmetro não terei nenhum prejuízo nos meus sistemas?
> Tinha visto essa solução, mas que não era recomendada.
>

Eu não respondo mais top post. Todo mundo tem pressa na vida e gasta tempo
catando suas respostas num mar de e-mails sem conexão, então gaste um pouco
do seu tempo respondendo adequadamente às threads.
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Luiz Carlos L. Nogueira Jr. 
Flávio,

Colocando esse parâmetro não terei nenhum prejuízo nos meus sistemas?
Tinha visto essa solução, mas que não era recomendada.
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Flavio Henrique Araque Gurgel 
Em seg, 24 de out de 2016 às 15:14, Flavio Henrique Araque Gurgel <
fha...@gmail.com> escreveu:

> Em seg, 24 de out de 2016 às 15:11, Luiz Carlos L. Nogueira Jr. <
> lcnogueir...@gmail.com> escreveu:
>
>
> Quando coloco o sslmode require dá o erro
>
> hgopoer, line 231: got native error 101 and sqlstate 08001; message
> follows...
> server does not support SSL, but SSL was required  {08001,NativeErr = 101}
>
>
> Ok, seu problema não é SSL.
>
>
>
> Quando tiro
> hgopoer, line 231: got native error 210 and sqlstate 08P01; message
> follows...
> ERROR: Unsupported startup parameter: geqo {08P01,NativeErr = 210}
>
> Você precisa adicionar uma string na conf ignore_startup_parameters do
> pgbouncer.ini , "geqo"
>

Só avisando: Seu driver odbc é velho pra caramba, está usando o protocolo
antigo do PostgreSQL (a.k.a. v2)

[]s
Flavio Gurgel
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Flavio Henrique Araque Gurgel 
Em seg, 24 de out de 2016 às 15:11, Luiz Carlos L. Nogueira Jr. <
lcnogueir...@gmail.com> escreveu:

>
> Quando coloco o sslmode require dá o erro
>
> hgopoer, line 231: got native error 101 and sqlstate 08001; message
> follows...
> server does not support SSL, but SSL was required  {08001,NativeErr = 101}
>

Ok, seu problema não é SSL.


>
> Quando tiro
> hgopoer, line 231: got native error 210 and sqlstate 08P01; message
> follows...
> ERROR: Unsupported startup parameter: geqo {08P01,NativeErr = 210}
>
> Você precisa adicionar uma string na conf ignore_startup_parameters do
pgbouncer.ini , "geqo"

[]s
Flavio Gurgel
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Luiz Carlos L. Nogueira Jr. 
Quando coloco o sslmode require dá o erro

hgopoer, line 231: got native error 101 and sqlstate 08001; message
follows...
server does not support SSL, but SSL was required  {08001,NativeErr = 101}

Quando tiro
hgopoer, line 231: got native error 210 and sqlstate 08P01; message
follows...
ERROR: Unsupported startup parameter: geqo {08P01,NativeErr = 210}
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Luiz Carlos L. Nogueira Jr. 
Flávio,
Foi mal. É a pressa.
O arquivo não existe
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Flavio Henrique Araque Gurgel 
Em seg, 24 de out de 2016 às 14:55, Luiz Carlos L. Nogueira Jr. <
lcnogueir...@gmail.com> escreveu:

> Já tinha testado e... NADA
>

Luiz, você já é macaco velho por aqui pra saber que top post é o inferno
desta lista.


>
>
> ORA-28500: conexão do ORACLE com um sistema não Oracle retornou esta
> mensagem:
> server does not support SSL, but SSL was required
>  {08001,NativeErr = 101}
> ORA-02063: precedendo 3 lines a partir de PG_LINK
> 28500. 0 -  "connection from ORACLE to a non-Oracle system returned
> this message:"
> *Cause:The cause is explained in the forwarded message.
> *Action:   See the non-Oracle system's documentation of the forwarded
>message.
> Erro na linha: 1 Coluna: 27
>
> Em 24 de outubro de 2016 09:42, Flavio Henrique Araque Gurgel <
> fha...@gmail.com> escreveu:
>
>
>
> Em seg, 24 de out de 2016 às 14:21, Luiz Carlos L. Nogueira Jr. <
> lcnogueir...@gmail.com> escreveu:
>
> odbcinst.ini
>
> [PostgreSQL64]
> Description = ODBC for PostgreSQL
> Driver  = /usr/lib/psqlodbc.so
> Setup   = /usr/lib/libodbcpsqlS.so
> Driver64= /usr/pgsql-9.3/lib/psqlodbc.so
> Setup64 = /usr/lib64/libodbcpsqlS.so
> FileUsage   = 1
>
>
> odbc.ini
> [PG_LINK]
> Description = PG_LINK
> Driver = PostgreSQL64
> Trace = No
> TraceFil = /tmp/odbc.log
>
>

O que diz este arquivo :
/tmp/odbc.log

[]s
Flavio Gurgel
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Luiz Carlos L. Nogueira Jr. 
Já tinha testado e... NADA


ORA-28500: conexão do ORACLE com um sistema não Oracle retornou esta
mensagem:
server does not support SSL, but SSL was required
 {08001,NativeErr = 101}
ORA-02063: precedendo 3 lines a partir de PG_LINK
28500. 0 -  "connection from ORACLE to a non-Oracle system returned
this message:"
*Cause:The cause is explained in the forwarded message.
*Action:   See the non-Oracle system's documentation of the forwarded
   message.
Erro na linha: 1 Coluna: 27

Em 24 de outubro de 2016 09:42, Flavio Henrique Araque Gurgel <
fha...@gmail.com> escreveu:

>
>
> Em seg, 24 de out de 2016 às 14:21, Luiz Carlos L. Nogueira Jr. <
> lcnogueir...@gmail.com> escreveu:
>
>> odbcinst.ini
>>
>> [PostgreSQL64]
>> Description = ODBC for PostgreSQL
>> Driver  = /usr/lib/psqlodbc.so
>> Setup   = /usr/lib/libodbcpsqlS.so
>> Driver64= /usr/pgsql-9.3/lib/psqlodbc.so
>> Setup64 = /usr/lib64/libodbcpsqlS.so
>> FileUsage   = 1
>>
>>
>> odbc.ini
>> [PG_LINK]
>> Description = PG_LINK
>> Driver = PostgreSQL64
>> Trace = No
>> TraceFil = /tmp/odbc.log
>> Database = pje_jud1g_p
>> Servername = 192.168.252.37
>> Username = user_dblink
>> #Port = 5432
>> ReadOnly = Yes
>> #Servername = 192.168.252.43 <-aqui é do bouncer onde deu problema
>> #Port = 6432
>>
>
> Adicione a opção:
> Sslmode = require
>
> E veja se resolve seu problema.
>
> []s
> Flavio Gurgel
>
>
> ___
> pgbr-geral mailing list
> pgbr-geral@listas.postgresql.org.br
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Flavio Henrique Araque Gurgel 
Em seg, 24 de out de 2016 às 14:21, Luiz Carlos L. Nogueira Jr. <
lcnogueir...@gmail.com> escreveu:

> odbcinst.ini
>
> [PostgreSQL64]
> Description = ODBC for PostgreSQL
> Driver  = /usr/lib/psqlodbc.so
> Setup   = /usr/lib/libodbcpsqlS.so
> Driver64= /usr/pgsql-9.3/lib/psqlodbc.so
> Setup64 = /usr/lib64/libodbcpsqlS.so
> FileUsage   = 1
>
>
> odbc.ini
> [PG_LINK]
> Description = PG_LINK
> Driver = PostgreSQL64
> Trace = No
> TraceFil = /tmp/odbc.log
> Database = pje_jud1g_p
> Servername = 192.168.252.37
> Username = user_dblink
> #Port = 5432
> ReadOnly = Yes
> #Servername = 192.168.252.43 <-aqui é do bouncer onde deu problema
> #Port = 6432
>

Adicione a opção:
Sslmode = require

E veja se resolve seu problema.

[]s
Flavio Gurgel
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Luiz Carlos L. Nogueira Jr. 
odbcinst.ini

[PostgreSQL64]
Description = ODBC for PostgreSQL
Driver  = /usr/lib/psqlodbc.so
Setup   = /usr/lib/libodbcpsqlS.so
Driver64= /usr/pgsql-9.3/lib/psqlodbc.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage   = 1


odbc.ini
[PG_LINK]
Description = PG_LINK
Driver = PostgreSQL64
Trace = No
TraceFil = /tmp/odbc.log
Database = pje_jud1g_p
Servername = 192.168.252.37
Username = user_dblink
#Port = 5432
ReadOnly = Yes
#Servername = 192.168.252.43 <-aqui é do bouncer onde deu problema
#Port = 6432
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Luiz Carlos L. Nogueira Jr. 
Complementando


O postgresql.ini é igual nos 2 lados, só com a opção de slave diferente.



pgbouncer .ini
; bancos de producao
pje_jud1g_p  = host=192.168.252.xx  port=5432 pool_size=100
<- aqui funciona
; bancos de replicacao
pje_jud1g_p_rep  = host=192.168.251.yyy port=5432 pool_size=50
dbname=pje_jud1g_p <-aqui dá problema
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Flavio Henrique Araque Gurgel 
Em seg, 24 de out de 2016 às 13:13, Luiz Carlos L. Nogueira Jr. <
lcnogueir...@gmail.com> escreveu:

> Pessoal,
> Instalei o pgbouncer e algumas aplicações minhas que vinham através de
> DBLINKs do Oracle pararam de funcionar.
> Algumas aplicações asp tive que colocar o modo ssl pra poderem funcionar,
> mas com o DBLINK não encontrei algum tipo de opção assim.
>

Isso fica no odbc.ini. Poderia postar o seu?
A versão do driver odbc também importa.


>
> A mensagem de erro abaixo me deixou mais confuso ainda.
>
> Segue trace do oracle com
> Oracle Corporation --- MONDAYOCT 24 2016 07:50:50.425
>
>
> Heterogeneous Agent Release
> 11.2.0.4.0
>
>
>
>
> Oracle Corporation --- MONDAYOCT 24 2016 07:50:50.424
>
> Version 11.2.0.4.0
>
> Entered hgogprd
> HOSGIP for "HS_FDS_TRACE_LEVEL" returned "4"
> Entered hgosdip
>  setting HS_OPEN_CURSORS to default of 50
>  setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
>  setting HS_FDS_RECOVERY_PWD to default value
>  setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
>  setting HS_IDLE_TIMEOUT to default of 0
>  setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
>  setting HS_NLS_NCHAR to default of "AL32UTF8"
>  setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
>  setting HS_FDS_DATE_MAPPING to default of "DATE"
>  setting HS_RPC_FETCH_REBLOCKING to default of "ON"
>  setting HS_FDS_FETCH_ROWS to default of "100"
>  setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
>  setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
>  setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
>  setting HS_FDS_MAP_NCHAR to default of "TRUE"
>  setting HS_NLS_DATE_FORMAT to default of "-MM-DD HH24:MI:SS"
>  setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
>  setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
>  setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
>  setting HS_FDS_QUERY_DRIVER to default of "TRUE"
>  setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
>  setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"
>  setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
>  setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
>  setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
> Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION
>  setting HS_CALL_NAME_ISP to
> "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
>  setting HS_FDS_DELAYED_OPEN to default of "TRUE"
>  setting HS_FDS_WORKAROUNDS to default of "0"
> Exiting hgosdip, rc=0
>  ORACLE_SID is "PG_LINK"
>  Product-Info:
>   Port Rls/Upd:4/0 PrdStat:0
>   Agent:Oracle Database Gateway for ODBC
>   Facility:hsa
>   Class:ODBC, ClassVsn:11.2.0.4.0_0019, Instance:PG_LINK
> Exiting hgogprd, rc=0
> Entered hgoinit
> HOCXU_COMP_CSET=1
> HOCXU_DRV_CSET=31
> HOCXU_DRV_NCHAR=873
> HOCXU_DB_CSET=178
> HS_LANGUAGE is BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1
> LANG=en_US.UTF-8
> HOCXU_SEM_VER=112000
> Entered hgolofn at 2016/10/24-07:50:50
> HOSGIP for "HS_FDS_SHAREABLE_NAME" returned
> "/usr/pgsql-9.3/lib/psqlodbcw.so"
> Entered hgolofns at 2016/10/24-07:50:50
> 
>
>  hoaerr:0
> Exiting hgolofns at 2016/10/24-07:50:50
> Exiting hgolofn, rc=0 at 2016/10/24-07:50:50
> HOSGIP for "HS_OPEN_CURSORS" returned "50"
> HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
> HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
> HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
> HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
> HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
> HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
> HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
> HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
> Invalid value of 64 given for HS_FDS_SQLLEN_INTERPRETATION
> treat_SQLLEN_as_compiled = 1
> Exiting hgoinit, rc=0 at 2016/10/24-07:50:50
> Entered hgolgon at 2016/10/24-07:50:50
>  reco:0, name:user_dblink, tflag:0
> Entered hgosuec at 2016/10/24-07:50:50
> Exiting hgosuec, rc=0 at 2016/10/24-07:50:50
> HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
> HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
> HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
> HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
> HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
> HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
> HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
> HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
> HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
>  using user_dblink as default value for "HS_FDS_DEFAULT_OWNER"
> HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
> Entered hgocont at 2016/10/24-07:50:50
>  HS_FDS_CONNECT_INFO = "PG_LINK"
>  RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
> Entered hgogenconstr at 2016/10/24-07:50:50
>  dsn:PG_LINK, name:user_dblink
>  optn:
> Entered hgocip at 2016/10/24-07:50:50
>  dsn:PG_LINK
> Exiting hgocip, rc=0 at 2016/10/24-07:50:50
>

[pgbr-geral] DBLINK Oracle x PGBouncer

2016-10-24 Por tôpico Luiz Carlos L. Nogueira Jr. 
Pessoal,
Instalei o pgbouncer e algumas aplicações minhas que vinham através de
DBLINKs do Oracle pararam de funcionar.
Algumas aplicações asp tive que colocar o modo ssl pra poderem funcionar,
mas com o DBLINK não encontrei algum tipo de opção assim.

A mensagem de erro abaixo me deixou mais confuso ainda.

Segue trace do oracle com
Oracle Corporation --- MONDAYOCT 24 2016 07:50:50.425


Heterogeneous Agent Release
11.2.0.4.0




Oracle Corporation --- MONDAYOCT 24 2016 07:50:50.424

Version 11.2.0.4.0

Entered hgogprd
HOSGIP for "HS_FDS_TRACE_LEVEL" returned "4"
Entered hgosdip
 setting HS_OPEN_CURSORS to default of 50
 setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
 setting HS_FDS_RECOVERY_PWD to default value
 setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
 setting HS_IDLE_TIMEOUT to default of 0
 setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
 setting HS_NLS_NCHAR to default of "AL32UTF8"
 setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
 setting HS_FDS_DATE_MAPPING to default of "DATE"
 setting HS_RPC_FETCH_REBLOCKING to default of "ON"
 setting HS_FDS_FETCH_ROWS to default of "100"
 setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
 setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
 setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
 setting HS_FDS_MAP_NCHAR to default of "TRUE"
 setting HS_NLS_DATE_FORMAT to default of "-MM-DD HH24:MI:SS"
 setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
 setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
 setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
 setting HS_FDS_QUERY_DRIVER to default of "TRUE"
 setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
 setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"
 setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
 setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
 setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION
 setting HS_CALL_NAME_ISP to
"gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
 setting HS_FDS_DELAYED_OPEN to default of "TRUE"
 setting HS_FDS_WORKAROUNDS to default of "0"
Exiting hgosdip, rc=0
 ORACLE_SID is "PG_LINK"
 Product-Info:
  Port Rls/Upd:4/0 PrdStat:0
  Agent:Oracle Database Gateway for ODBC
  Facility:hsa
  Class:ODBC, ClassVsn:11.2.0.4.0_0019, Instance:PG_LINK
Exiting hgogprd, rc=0
Entered hgoinit
HOCXU_COMP_CSET=1
HOCXU_DRV_CSET=31
HOCXU_DRV_NCHAR=873
HOCXU_DB_CSET=178
HS_LANGUAGE is BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1
LANG=en_US.UTF-8
HOCXU_SEM_VER=112000
Entered hgolofn at 2016/10/24-07:50:50
HOSGIP for "HS_FDS_SHAREABLE_NAME" returned
"/usr/pgsql-9.3/lib/psqlodbcw.so"
Entered hgolofns at 2016/10/24-07:50:50


 hoaerr:0
Exiting hgolofns at 2016/10/24-07:50:50
Exiting hgolofn, rc=0 at 2016/10/24-07:50:50
HOSGIP for "HS_OPEN_CURSORS" returned "50"
HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
Invalid value of 64 given for HS_FDS_SQLLEN_INTERPRETATION
treat_SQLLEN_as_compiled = 1
Exiting hgoinit, rc=0 at 2016/10/24-07:50:50
Entered hgolgon at 2016/10/24-07:50:50
 reco:0, name:user_dblink, tflag:0
Entered hgosuec at 2016/10/24-07:50:50
Exiting hgosuec, rc=0 at 2016/10/24-07:50:50
HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
 using user_dblink as default value for "HS_FDS_DEFAULT_OWNER"
HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
Entered hgocont at 2016/10/24-07:50:50
 HS_FDS_CONNECT_INFO = "PG_LINK"
 RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
Entered hgogenconstr at 2016/10/24-07:50:50
 dsn:PG_LINK, name:user_dblink
 optn:
Entered hgocip at 2016/10/24-07:50:50
 dsn:PG_LINK
Exiting hgocip, rc=0 at 2016/10/24-07:50:50
##>Connect Parameters (len=50)<##
## DSN=PG_LINK;
#! UID=user_dblink;
#! PWD=*
Exiting hgogenconstr, rc=0 at 2016/10/24-07:50:50
Entered hgopoer at 2016/10/24-07:50:50
*hgopoer, line 231: got native error 210 and sqlstate 08P01; message
follows...*
*ERROR: Unsupported startup parameter: geqo {08P01,NativeErr = 210}*
Exiting hgopoer, rc=0 at 2016/10/24-07:50:50
hgocont, line 2831: calling SqlDriverConnect got