[postgis-users] raster2pgsql binary in apt distros

[Mateusz Loskot]

Regina,
I don't see how raster2pgsql depends on libpq. It does depend on liblwgeom,
librtcore though.

Mateusz Loskot, mateusz at loskot.net
(Sent from mobile)


On Fri, 16 Nov 2018, 08:19 Michał Garnysz <garnysz.michal at gmail.com wrote:

> I noticed many of things you described and im i doubt there is any clean
> way to get it working. It looked like simple task get tar ball of postgres
> & postgis and make it work. (was even able to configure and make postgis
> but was installation dependant)
> I made it run instance just overloading some param -L while executing
> initdb - on extracted binaries on clean ubuntu - not 100% all was working
> fine but where able to add extension and populate data.
>
> It's sad that you can apt-get all of this in like 5steps, but there is no
> way to make it work form one binary (not installed) folder - there are
> ready to use docker container db with spatial but it's another dependency
> to project (and just for tests it's an overkill)
> Or maybe someone prove me wrong, anyone - please :)
>
> czw., 15 lis 2018 o 20:54 Regina Obe <lr at pcorp.us> napisał(a):
>
>> I think we can make it a bit easier on them and also easier on people who
>> just want the commandline tools
>>
>>
>>
>> 1)      Right now you can't compile the commandlines without having
>> postgres installed unless you hack the make scripts
>>
>> 2)      It has come to my attention that raster2pgsql has a dependency
>> on libpq.  I'm not sure why it should when I thought it just emits SQL
>> similar to shp2pgsql (which has no libpq dependency).
>>
>> So this sounds like a dependency that may be accidental.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *From:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] *On
>> Behalf Of *Paul Ramsey
>> *Sent:* Thursday, November 15, 2018 2:39 PM
>> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
>> *Subject:* Re: [postgis-users] raster2pgsql binary in apt distros
>>
>>
>>
>> Something to think about for our 3.0 release.
>>
>>
>>
>> Might need to be ticketed and assigned to packagers? It's not a big ask,
>> but it's easy to forget if they just copy'n'ship the old specs.
>>
>>
>> P
>>
>>
>>
>>
>>
>>
>> > -----Original Message-----
>> > From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
>> Behalf
>> > Of Nils Nolde
>> > Sent: Thursday, November 15, 2018 5:55 AM
>> > To: postgis-users at lists.osgeo.org
>> > Subject: [postgis-users] raster2pgsql binary in apt distros
>> >
>> > Hi,
>> >
>> > I had trouble accessing the raster2pgsql binary with different apt
>> postgresql-x-
>> > postgis-x distros in the past. It�s not callable as executable and I
>> can�t find it
>> > in the usual bin/ directories. I can only access it when installing �
>> apt-get
>> > install postgis� which leaves me with a postgresql v10 distro. Not a
>> > dealbreaker, but a bit annoying. So my questions are:
>> >
>> > - how can I access raster2pgsql in a postgres specific postgis version
>> from apt,
>> > e.g. postgresql-9.6-postgis-2.4?
>> >
>> > - is there a way to compile the tool independent of a postgis
>> installation, as
>> > to not have a full postgres installation for just using raster2pgsql?
>> Context:
>> > sometimes I only need the tool in a docker container to update an
>> external
>> > database.
>> >
>> > Or does it need compilation against specific postgis versions? I guess
>> GDAL is a
>> > dependency, but the produced .sql should be rather independent of
>> postgis
>> > versions right?
>> >
>> > Of course I could write my own sql statements for raster import, but it
>> �s sooo
>> > convenient:)
>> >
>> > Many thanks
>> > Nils
>> > _______________________________________________
>> > postgis-users mailing list
>> > postgis-users at lists.osgeo.org
>> > https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181116/0c4aa974/attachment.html>