Thread: Support for PostgreSQL 8.1.3 stable

Support for PostgreSQL 8.1.3 stable

From
"Andrew Ng"
Date:
Hi,

like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3?

I had compiled and installed psqlodbc on OpenBSD 3.8, but was unable to
connect with isql. The Driver Manager is unixODBC-2.2.11 from source and
PGSQL was installed from source as well. There was no error of warning
when I run isql, the program just exit and return to the shell prompt.

I tried with PGSQL 8.0.7 installed from OpenBSD packages, and was able
to connect and query the db. Thus, I seek confirmation/verification on
8.1.3 support. Appreciate any advice. Thanks.

Regards,
Andrew Ng
--
  Andrew Ng
  ngandrew@fastmail.fm

--
http://www.fastmail.fm - And now for something completely different…


Re: Support for PostgreSQL 8.1.3 stable

From
Ludek Finstrle
Date:
I'm sorry for late response at firest.

> like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3?

Yes it can. I see no problem with this combination.

> I had compiled and installed psqlodbc on OpenBSD 3.8, but was unable to
> connect with isql. The Driver Manager is unixODBC-2.2.11 from source and
> PGSQL was installed from source as well. There was no error of warning
> when I run isql, the program just exit and return to the shell prompt.
>
> I tried with PGSQL 8.0.7 installed from OpenBSD packages, and was able
> to connect and query the db. Thus, I seek confirmation/verification on
> 8.1.3 support. Appreciate any advice. Thanks.

Are you able to produce some mylog output with psqlodbc 08.01.0200?

Regards,

Luf

Re: Support for PostgreSQL 8.1.3 stable

From
"Andrew Ng"
Date:
Hi Luf,

only saw your below reply from archive, must have deleted original
message inadvertently :)

I can't find instructions on how to enable mylog and where the output is
save to, please provide any reference or steps. Thanks.

Regards

------------------------------------------------------------------------------------------------
I'm sorry for late response at firest.

> like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3?

Yes it can. I see no problem with this combination.

> I had compiled and installed psqlodbc on OpenBSD 3.8, but was unable to
> connect with isql. The Driver Manager is unixODBC-2.2.11 from source and
> PGSQL was installed from source as well. There was no error of warning
> when I run isql, the program just exit and return to the shell prompt.

> I tried with PGSQL 8.0.7 installed from OpenBSD packages, and was able
> to connect and query the db. Thus, I seek confirmation/verification on
> 8.1.3 support. Appreciate any advice. Thanks.

Are you able to produce some mylog output with psqlodbc 08.01.0200?

Regards,

Luf
------------------------------------------------------------------------------------
--
  Andrew Ng
  ngandrew@fastmail.fm

--
http://www.fastmail.fm - And now for something completely different…


Re: Support for PostgreSQL 8.1.3 stable

From
Ludek Finstrle
Date:
> I can't find instructions on how to enable mylog and where the output is
> save to, please provide any reference or steps. Thanks.

You only add line Debug = 1 in the odbc.ini. You find the mylog output
in /tmp directory. It is /tmp/mylog_*.log.

Regards

Luf

> ---------------------------------------------------------------------------
> I'm sorry for late response at firest.
>
> > like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3?
>
> Yes it can. I see no problem with this combination.
>
> > I had compiled and installed psqlodbc on OpenBSD 3.8, but was unable to
> > connect with isql. The Driver Manager is unixODBC-2.2.11 from source and
> > PGSQL was installed from source as well. There was no error of warning
> > when I run isql, the program just exit and return to the shell prompt.
>
> > I tried with PGSQL 8.0.7 installed from OpenBSD packages, and was able
> > to connect and query the db. Thus, I seek confirmation/verification on
> > 8.1.3 support. Appreciate any advice. Thanks.
>
> Are you able to produce some mylog output with psqlodbc 08.01.0200?
>
> Regards,
>
> Luf

Re: Support for PostgreSQL 8.1.3 stable

From
"Andrew Ng"
Date:
Added but /tmp/mylog_*.log file not found, search return no match as
well. I have checked the docs for unixODBC, don't think there is a
"Debug" entry, there are "Trace" and "TraceFile". I had enabled them but
couldn't find the log file too.

On Tue, 25 Apr 2006 15:03:16 +0200, "Ludek Finstrle" <luf@pzkagis.cz>
said:
> > I can't find instructions on how to enable mylog and where the output is
> > save to, please provide any reference or steps. Thanks.
>
> You only add line Debug = 1 in the odbc.ini. You find the mylog output
> in /tmp directory. It is /tmp/mylog_*.log.
>
> Regards
>
> Luf
>
> > ---------------------------------------------------------------------------
> > I'm sorry for late response at firest.
> >
> > > like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3?
> >
> > Yes it can. I see no problem with this combination.
> >
> > > I had compiled and installed psqlodbc on OpenBSD 3.8, but was unable to
> > > connect with isql. The Driver Manager is unixODBC-2.2.11 from source and
> > > PGSQL was installed from source as well. There was no error of warning
> > > when I run isql, the program just exit and return to the shell prompt.
> >
> > > I tried with PGSQL 8.0.7 installed from OpenBSD packages, and was able
> > > to connect and query the db. Thus, I seek confirmation/verification on
> > > 8.1.3 support. Appreciate any advice. Thanks.
> >
> > Are you able to produce some mylog output with psqlodbc 08.01.0200?
> >
> > Regards,
> >
> > Luf
--
  Andrew Ng
  ngandrew@fastmail.fm

--
http://www.fastmail.fm - Access all of your messages and folders
                          wherever you are


Re: Support for PostgreSQL 8.1.3 stable

From
Ludek Finstrle
Date:
> Added but /tmp/mylog_*.log file not found, search return no match as
> well. I have checked the docs for unixODBC, don't think there is a
> "Debug" entry, there are "Trace" and "TraceFile". I had enabled them but
> couldn't find the log file too.

It's not unixODBC parameter. It's psqlodbc one. I check it and I have
here Debug = Yes. I'm lazy to find if Yes and 1 is equivalent.
I try it on linux box and it works as I expect.
The non-exist mylog file could means that unixODBC doesn't connect
psqlodbc.
Maybe you could try to use Trace and TraceFile but I know nothing
about it. I think they're unixODBC parameters.

Regards,

Luf

> On Tue, 25 Apr 2006 15:03:16 +0200, "Ludek Finstrle" <luf@pzkagis.cz>
> said:
> > > I can't find instructions on how to enable mylog and where the output is
> > > save to, please provide any reference or steps. Thanks.
> >
> > You only add line Debug = 1 in the odbc.ini. You find the mylog output
> > in /tmp directory. It is /tmp/mylog_*.log.
> >
> > > ---------------------------------------------------------------------------
> > > I'm sorry for late response at firest.
> > >
> > > > like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3?
> > >
> > > Yes it can. I see no problem with this combination.
> > >
> > > > I had compiled and installed psqlodbc on OpenBSD 3.8, but was unable to
> > > > connect with isql. The Driver Manager is unixODBC-2.2.11 from source and
> > > > PGSQL was installed from source as well. There was no error of warning
> > > > when I run isql, the program just exit and return to the shell prompt.
> > >
> > > > I tried with PGSQL 8.0.7 installed from OpenBSD packages, and was able
> > > > to connect and query the db. Thus, I seek confirmation/verification on
> > > > 8.1.3 support. Appreciate any advice. Thanks.
> > >
> > > Are you able to produce some mylog output with psqlodbc 08.01.0200?

Re: Support for PostgreSQL 8.1.3 stable

From
"Andrew Ng"
Date:
The only odbc.ini in my system is at /usr/local/etc/odbc.ini. If I'm not
wrong, it's for unixODBC configurations. Do you mind posting the file
location and content(with confidential data obfuscated)?

On Tue, 25 Apr 2006 16:04:43 +0200, "Ludek Finstrle" <luf@pzkagis.cz>
said:
> > Added but /tmp/mylog_*.log file not found, search return no match as
> > well. I have checked the docs for unixODBC, don't think there is a
> > "Debug" entry, there are "Trace" and "TraceFile". I had enabled them but
> > couldn't find the log file too.
>
> It's not unixODBC parameter. It's psqlodbc one. I check it and I have
> here Debug = Yes. I'm lazy to find if Yes and 1 is equivalent.
> I try it on linux box and it works as I expect.
> The non-exist mylog file could means that unixODBC doesn't connect
> psqlodbc.
> Maybe you could try to use Trace and TraceFile but I know nothing
> about it. I think they're unixODBC parameters.
>
> Regards,
>
> Luf
>
> > On Tue, 25 Apr 2006 15:03:16 +0200, "Ludek Finstrle" <luf@pzkagis.cz>
> > said:
> > > > I can't find instructions on how to enable mylog and where the output is
> > > > save to, please provide any reference or steps. Thanks.
> > >
> > > You only add line Debug = 1 in the odbc.ini. You find the mylog output
> > > in /tmp directory. It is /tmp/mylog_*.log.
> > >
> > > > ---------------------------------------------------------------------------
> > > > I'm sorry for late response at firest.
> > > >
> > > > > like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3?
> > > >
> > > > Yes it can. I see no problem with this combination.
> > > >
> > > > > I had compiled and installed psqlodbc on OpenBSD 3.8, but was unable to
> > > > > connect with isql. The Driver Manager is unixODBC-2.2.11 from source and
> > > > > PGSQL was installed from source as well. There was no error of warning
> > > > > when I run isql, the program just exit and return to the shell prompt.
> > > >
> > > > > I tried with PGSQL 8.0.7 installed from OpenBSD packages, and was able
> > > > > to connect and query the db. Thus, I seek confirmation/verification on
> > > > > 8.1.3 support. Appreciate any advice. Thanks.
> > > >
> > > > Are you able to produce some mylog output with psqlodbc 08.01.0200?
--
  Andrew Ng
  ngandrew@fastmail.fm

--
http://www.fastmail.fm - Email service worth paying for. Try it for free


Re: Support for PostgreSQL 8.1.3 stable

From
Ludek Finstrle
Date:
> The only odbc.ini in my system is at /usr/local/etc/odbc.ini. If I'm not
> wrong, it's for unixODBC configurations. Do you mind posting the file
> location and content(with confidential data obfuscated)?

I don't know maybe someone here could see the problem. I have zero
knowledge about *BSD systems so maybe problem could be there. If I have
same problem I'll try strace to see what happens.
The odbc.ini location depends on configure parameters for unixODBC.

Regards,

Luf

Re: Support for PostgreSQL 8.1.3 stable

From
"Andrew Ng"
Date:
Thanks, will check on strace.

On Wed, 26 Apr 2006 15:11:13 +0200, "Ludek Finstrle" <luf@pzkagis.cz>
said:
> > The only odbc.ini in my system is at /usr/local/etc/odbc.ini. If I'm not
> > wrong, it's for unixODBC configurations. Do you mind posting the file
> > location and content(with confidential data obfuscated)?
>
> I don't know maybe someone here could see the problem. I have zero
> knowledge about *BSD systems so maybe problem could be there. If I have
> same problem I'll try strace to see what happens.
> The odbc.ini location depends on configure parameters for unixODBC.
>
> Regards,
>
> Luf
--
  Andrew Ng
  ngandrew@fastmail.fm

--
http://www.fastmail.fm - I mean, what is it about a decent email service?