Обсуждение: Libpq on windows

Phil

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

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

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

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

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

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:
> 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

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.

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.

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.