Re: postgresql

[Ben Pfaff]

On Fri, Aug 19, 2016 at 10:48:52PM +0200, Harry Thijssen wrote:
> I am looking again in the postgresql issue when cross-compiling.
> 
> 
> 2016-03-18 21:23 GMT+01:00 John Darrington <address@hidden>:
> 
> > On Fri, Mar 18, 2016 at 08:53:09PM +0100, Harry Thijssen wrote:
> >      Hi
> >
> >      It seems to me that the test for Postgresql in configure is not
> > correct.
> >
> >      I think it is testing if Postgresql is installed in the host
> > environment
> >      instead of the target environment.
> >
> >
> > There are several things one needs to be carefull of in such discussions.
> >
> > Firstly, the terms "host", "target" and "build" have been used to mean
> > different
> > things over the years.  The most common usage today I think is as follows:
> >
> > The "build" platform means the platform on which the software is being
> > built -
> > that is to say the platform on which the compiler is running.
> >
> > The "host" platform is the platform on which the built software is intented
> > to run.
> >
> > The term "target" today is relevant only for compilers and similar tools.
> > It means
> > the platform on which software produced by the compiler currently being
> > built is
> > intended to run.  It is probably not relevant for our discussion.
> >
> >
> > As far as Postgresql and PSPP is concerned :
> >
> > The libpq library needs to be available *on* the build platform, cross
> > compiled so
> > that it can run on the host platform.
> >
> 
> Ok so I have the lippq.dll on my cross-compiling environment. (mingw on
> openSUSE)
> 
> >
> > For the purposes of running the tests, a postgresql server needs to be
> > available on
> > the build platform.
> >
> 
> Only necessary when run "make test" ?

Right, for "make check".

> >
> > Complicating matters further, Postgresql has a binary called pg_config -
> > which performs
> > a similar role to pkg-config - We use it to try and find the relevant
> > postgres bits.
> > pg_config needs to be installed on and for the build platform.
> >
> 
> This is confusing. Is this used during
> 
> ./configure
>  make
>  make install
> 
> or later on when the resulting binaries are executed on a MSWindows
> environment? I have pg_config.exe now available in my mingw
> environment.

It's used during "./configure", only.

>  Hopefully the above doesn't confuse you too much.
> 
> >
> > J'
> >
> 
> For me it is still very confusing and I don't know what to do to get
> postgresql support in the MSWindows binaries. Does this work for GNU/Linux
> packages?

Yes.

Basically: you need the client library to do the build and the server to
test that it works.