[postgis-devel] [postgis-users] raster2pgsql binary in apt distros

[Regina Obe]

I don't think there is any way to get it via apt without getting PostgreSQL as I think it's only part of postgis package which contains just the loaders and dumpers (raster2pgsql, shp2pgsql, pgsql2shp)
and postgis was marked as depending on postgresql.

I'm guessing the reason for that is because pgsql2shp has a dependency on libpq.  Though the others do not so would have a dependency on the postgresql client tools.  Then again why that is sufficient to require postgresql seems a bit odd to me.

That said, assuming you had all the dependencies (GDAL generally being the biggest unless you compiled your own), then you in theory could

1) Download the postgis tar ball
2) Run configure (which you can't cause we require it to find pg_config which only comes with postgresql development)
3) CD into the raster/loader folder
4) run make && make install


It would seem to me though we could make this easier for folks.  I too have on occasion only needed the commandline tools.
It would seem while we would "In theory" require libpq for the pgsql2shp, which having postgresql client would be sufficient.

Shp2pgsql and raster2pgsql just write out SQL so don't even need that.

Something to think about for our 3.0 release.



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