Libpq on windows

Started by Phil Longstaffalmost 17 years ago12 messagesgeneral
Jump to latest
#1Phil Longstaff
plongstaff@rogers.com

I want to develop an app which uses libpq, built with mingw. Is there a
download package which contains just the include files/dlls? If not, what
package do I download? I don't need the server, just the client libraries.

Phil

#2Andy Colson
andy@squeakycode.net
In reply to: Phil Longstaff (#1)
Re: Libpq on windows

Phil Longstaff wrote:

I want to develop an app which uses libpq, built with mingw. Is there a
download package which contains just the include files/dlls? If not,
what package do I download? I don't need the server, just the client
libraries.

Phil

If you dont mind all the ssl stuff (5 or 6 dll's worth) you can borrow
the client from pgAdmin III.

I, however, just build my own w/out the ssl stuff. There is no client
only, but its really not hard, just download the full source, unpack,
compile and then copy the libpq.dll out.

If you want mine I could copy it out so you can download it.

-Andy

#3Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Phil Longstaff (#1)
Re: Libpq on windows

Phil wrote:

I want to develop an app which uses libpq, built with mingw.
Is there a download package which contains just the include files/dlls?
If not, what package do I download? I don't need the server, just the client libraries.

You can use the regular binary installer for Windows,
it gives you the option to deselect certain components.
So you can just install th client and libraries without the server.

Yours,
Laurenz Albe

#4Phil Longstaff
plongstaff@rogers.com
In reply to: Laurenz Albe (#3)
Re: Libpq on windows

On June 11, 2009 01:21:09 am Albe Laurenz wrote:

Phil wrote:

I want to develop an app which uses libpq, built with mingw.
Is there a download package which contains just the include files/dlls?
If not, what package do I download? I don't need the server, just the
client libraries.

You can use the regular binary installer for Windows,
it gives you the option to deselect certain components.
So you can just install th client and libraries without the server.

Yours,
Laurenz Albe

I should have been more specific. I was hoping for a compressed file to
download and uncompress, because this is part of an automated build process.
Downloading the larger installer and manually selecting components doesn't
help me.

Thanks anyway.

Phil

#5Phil Longstaff
plongstaff@rogers.com
In reply to: Andy Colson (#2)
Re: Libpq on windows

On June 10, 2009 10:00:48 pm Andy Colson wrote:

Phil Longstaff wrote:

I want to develop an app which uses libpq, built with mingw. Is there a
download package which contains just the include files/dlls? If not,
what package do I download? I don't need the server, just the client
libraries.

Phil

If you dont mind all the ssl stuff (5 or 6 dll's worth) you can borrow
the client from pgAdmin III.

I, however, just build my own w/out the ssl stuff. There is no client
only, but its really not hard, just download the full source, unpack,
compile and then copy the libpq.dll out.

If you want mine I could copy it out so you can download it.

Thanks. How strict is pgsql about version matches (client to server). If I
get your client, will it work with all 8.x versions of the server?

Is there a place on the postgresql.org website that I could request that they
package the library (built, or just source) by itself?

Phil

#6Andy Colson
andy@squeakycode.net
In reply to: Phil Longstaff (#5)
Re: Libpq on windows

Phil Longstaff wrote:

On June 10, 2009 10:00:48 pm Andy Colson wrote:

Phil Longstaff wrote:

I want to develop an app which uses libpq, built with mingw. Is there a
download package which contains just the include files/dlls? If not,
what package do I download? I don't need the server, just the client
libraries.

Phil

If you dont mind all the ssl stuff (5 or 6 dll's worth) you can borrow
the client from pgAdmin III.

I, however, just build my own w/out the ssl stuff. There is no client
only, but its really not hard, just download the full source, unpack,
compile and then copy the libpq.dll out.

If you want mine I could copy it out so you can download it.

Thanks. How strict is pgsql about version matches (client to server). If
I get your client, will it work with all 8.x versions of the server?

Not very. I'm was using the 8.2 client to hit 8.2 and 8.3. I just
recompiled the client to 8.4 (in beta 1, just to make sure it compiles
ok on mingw). I'm currently using it to hit an 8.3 server. I'm not
using anything "advanced" though... just the basics and I'v never had a
problem

Is there a place on the postgresql.org website that I could request that
they package the library (built, or just source) by itself?

dunno. I saw a while ago on the newgroups someone asking about a "make
client" for the source... but I think they just need someone to write it...

I put a copy of my dll here if you wanna try it out: (this was built
with 8.4 beta1, and hits 8.3 just fine)

http://squeakycode.net/dn/libpq.dll

-Andy

#7Andy Colson
andy@squeakycode.net
In reply to: Phil Longstaff (#4)
Re: Libpq on windows

Phil Longstaff wrote:

On June 11, 2009 01:21:09 am Albe Laurenz wrote:

Phil wrote:

I want to develop an app which uses libpq, built with mingw.
Is there a download package which contains just the include files/dlls?
If not, what package do I download? I don't need the server, just the
client libraries.

You can use the regular binary installer for Windows,
it gives you the option to deselect certain components.
So you can just install th client and libraries without the server.

Yours,
Laurenz Albe

I should have been more specific. I was hoping for a compressed file to
download and uncompress, because this is part of an automated build
process. Downloading the larger installer and manually selecting
components doesn't help me.

Thanks anyway.

Phil

I think the implication was: use the installer on your computer, pull
out the DLL's you need and copy them into your own installer.

If I'm not mistaken, the installer will use all the ssl stuff, so make
sure you get all the dll's, there are quite a few.

-Andy

#8Phil Longstaff
plongstaff@rogers.com
In reply to: Andy Colson (#6)
Re: Libpq on windows

I need the include files as well so I can build against the library.

Phil

________________________________
From: Andy Colson <andy@squeakycode.net>
To: Phil Longstaff <plongstaff@rogers.com>
Cc: pgsql-general@postgresql.org
Sent: Thursday, June 11, 2009 9:47:52 AM
Subject: Re: [GENERAL] Libpq on windows

Phil Longstaff wrote:

On June 10, 2009 10:00:48 pm Andy Colson wrote:

Phil Longstaff wrote:

I want to develop an app which uses libpq, built with mingw. Is there a
download package which contains just the include files/dlls? If not,
what package do I download? I don't need the server, just the client
libraries.

Phil

If you dont mind all the ssl stuff (5 or 6 dll's worth) you can borrow
the client from pgAdmin III.

I, however, just build my own w/out the ssl stuff. There is no client
only, but its really not hard, just download the full source, unpack,
compile and then copy the libpq.dll out.

If you want mine I could copy it out so you can download it.

Thanks. How strict is pgsql about version matches (client to server). If I get your client, will it work with all 8.x versions of the server?

Not very. I'm was using the 8.2 client to hit 8.2 and 8.3. I just recompiled the client to 8.4 (in beta 1, just to make sure it compiles ok on mingw). I'm currently using it to hit an 8.3 server. I'm not using anything "advanced" though... just the basics and I'v never had a problem

Is there a place on the postgresql.org website that I could request that they package the library (built, or just source) by itself?

dunno. I saw a while ago on the newgroups someone asking about a "make client" for the source... but I think they just need someone to write it...

I put a copy of my dll here if you wanna try it out: (this was built with 8.4 beta1, and hits 8.3 just fine)

http://squeakycode.net/dn/libpq.dll

-Andy

#9Andy Colson
andy@squeakycode.net
In reply to: Phil Longstaff (#8)
Re: Libpq on windows

My stuff is in Delphi, so I don't use the .h files, I'm not even sure
which one's you'd need.

You should grab the source from the main site, it'll have all the .h
files you'll ever need.

-Andy

Phil Longstaff wrote:

Show quoted text

I need the include files as well so I can build against the library.

Phil

------------------------------------------------------------------------
*From:* Andy Colson <andy@squeakycode.net>
*To:* Phil Longstaff <plongstaff@rogers.com>
*Cc:* pgsql-general@postgresql.org
*Sent:* Thursday, June 11, 2009 9:47:52 AM
*Subject:* Re: [GENERAL] Libpq on windows

Phil Longstaff wrote:

On June 10, 2009 10:00:48 pm Andy Colson wrote:

Phil Longstaff wrote:

I want to develop an app which uses libpq, built with mingw. Is

there a

download package which contains just the include files/dlls? If not,
what package do I download? I don't need the server, just the client
libraries.

Phil

If you dont mind all the ssl stuff (5 or 6 dll's worth) you can borrow
the client from pgAdmin III.

I, however, just build my own w/out the ssl stuff. There is no client
only, but its really not hard, just download the full source, unpack,
compile and then copy the libpq.dll out.

If you want mine I could copy it out so you can download it.

Thanks. How strict is pgsql about version matches (client to server).

If I get your client, will it work with all 8.x versions of the server?

Not very. I'm was using the 8.2 client to hit 8.2 and 8.3. I just
recompiled the client to 8.4 (in beta 1, just to make sure it compiles
ok on mingw). I'm currently using it to hit an 8.3 server. I'm not
using anything "advanced" though... just the basics and I'v never had a
problem

Is there a place on the postgresql.org website that I could request

that they package the library (built, or just source) by itself?

dunno. I saw a while ago on the newgroups someone asking about a "make
client" for the source... but I think they just need someone to write it...

I put a copy of my dll here if you wanna try it out: (this was built
with 8.4 beta1, and hits 8.3 just fine)

http://squeakycode.net/dn/libpq.dll

-Andy

#10Jasen Betts
jasen@xnet.co.nz
In reply to: Phil Longstaff (#1)
Re: Libpq on windows

On 2009-06-11, Phil Longstaff <plongstaff@rogers.com> wrote:

--Boundary-00=_kTFMK/PsAPB2oua
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

I want to develop an app which uses libpq, built with mingw. Is there a
download package which contains just the include files/dlls? If not, what
package do I download? I don't need the server, just the client libraries.

Phil

are you on dialup, or pay per kilobyte, or some other restricitve net
connection?

at work we download the msi installer, run it to get the dev files,
and save the installer for distribution with the finished app.

#11Jasen Betts
jasen@xnet.co.nz
In reply to: Phil Longstaff (#1)
Re: Libpq on windows

On 2009-06-11, Phil Longstaff <plongstaff@rogers.com> wrote:

--Boundary-00=_SzPMK0I3TQhQuQd
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

On June 11, 2009 01:21:09 am Albe Laurenz wrote:

Phil wrote:

I want to develop an app which uses libpq, built with mingw.
Is there a download package which contains just the include files/dlls?
If not, what package do I download? I don't need the server, just the
client libraries.

You can use the regular binary installer for Windows,
it gives you the option to deselect certain components.
So you can just install th client and libraries without the server.

Yours,
Laurenz Albe

I should have been more specific. I was hoping for a compressed file to
download and uncompress, because this is part of an automated build process.
Downloading the larger installer and manually selecting components doesn't
help me.

the MSI installer can be run unattended,
the no-installer zip will have the files themselves somewhere.

#12Jasen Betts
jasen@xnet.co.nz
In reply to: Phil Longstaff (#1)
Re: Libpq on windows

On 2009-06-11, Phil Longstaff <plongstaff@rogers.com> wrote:

--Boundary-00=_G1PMKwGIJrCuvLL
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

On June 10, 2009 10:00:48 pm Andy Colson wrote:

Phil Longstaff wrote:

I want to develop an app which uses libpq, built with mingw. Is there a
download package which contains just the include files/dlls? If not,
what package do I download? I don't need the server, just the client
libraries.

Phil

If you dont mind all the ssl stuff (5 or 6 dll's worth) you can borrow
the client from pgAdmin III.

I, however, just build my own w/out the ssl stuff. There is no client
only, but its really not hard, just download the full source, unpack,
compile and then copy the libpq.dll out.

If you want mine I could copy it out so you can download it.

Thanks. How strict is pgsql about version matches (client to server). If I
get your client, will it work with all 8.x versions of the server?

Is there a place on the postgresql.org website that I could request that they
package the library (built, or just source) by itself?

there's a source repostiory, CVS I think.