Package request: postgis #8142

sassanh · 2017-05-21T15:49:52Z

Is it possible to have postgis for termux?

its-pointless · 2017-05-22T04:10:48Z

Probably is but there are several dependencies some of which cannot be cross compiled.

sassanh · 2017-05-22T06:35:43Z

I see, I was just curious to see if I can run my django server on my android phone. Seems like postgis doesn't let me to do so.

jeanbarr · 2019-03-01T19:22:09Z

And now in 2019,is it possible to use postgis with postgresql on termux ?
It would be very useful for geographic jobs outside ......

bencevans · 2019-06-04T00:40:38Z

Made some headway on PostGIS but getting stuck compiling the PROJ dependency with the following error:

pkg install wget curl build-essential libiconv-dev postgresql-dev libxml2-dev libsqlite-dev

# rm -rf src
#mkdir src
cd src

# Download GEOS
#wget http://download.osgeo.org/geos/geos-3.7.2.tar.bz2
#bunzip2 geos-3.7.2.tar.bz2
#tar -xf geos-3.7.2.tar
#cd geos-3.7.2

#./configure --prefix=$PREFIX
#make
#make install

# Download PROJ
wget http://download.osgeo.org/proj/proj-6.1.0.tar.gz
tar -xzf proj-6.1.0.tar.gz
wget http://download.osgeo.org/proj/proj-datumgrid-1.8.zip
unzip proj-datumgrid-1.7.zip -d proj-6.1.0/data/
cd proj-6.1.0
export PKG_CONFIG_PATH=${PREFIX}/lib/pkgconfig:$PKG_CONFIG_PATH
./configure --prefix=$PREFIX
make
make install


# Download PostGIS
#wget https://download.osgeo.org/postgis/source/postgis-2.5.2.tar.gz
#tar -xzf postgis-2.5.2.tar.gz

#cd postgis-2.5.2
#./configure --prefix=$PREFIX
#make
#make install

bencevans · 2019-06-04T00:41:29Z

sqlite, libsqlite and libsqlite-dev are all installed

Grimler91 · 2019-06-04T04:33:15Z

@bencevans have a look in the config.log file for more information about why it can't find sqlite.

Also note that proj and geos are already available from the science repo so pkg in libgeos libgeos-dev proj proj-dev installs these dependencies.

bencevans · 2019-06-04T15:20:24Z

Thanks for the top @Grimler91. It's gotten me a bit further 🚀 PostGIS build is now getting stuck at finding proj_api.h which I can't find either scanning the file system.

Grimler91 · 2019-06-04T20:44:32Z

@bencevans I'm guessing you haven't installed proj-dev.

You probably also want to fix the /bin/sh: 0: Can't open build-aux/config.rpath error there (perhaps by changing /bin/sh to /data/data/com.termux/files/usr/bin/sh)

ghost · 2019-06-04T21:26:31Z

Packages:

pkg install build-essential gdal-dev json-c-dev postgresql-dev proj-dev libiconv-dev libgeos-dev libprotobuf-c-dev libxml2-dev

Configure:

./configure --prefix=$PREFIX --with-projdir=$PREFIX CFLAGS="-DACCEPT_USE_OF_DEPRECATED_PROJ_API_H=1"

Make:
```
make -j8
```
~~Looks like protoc-c is broken (cannot find symbol)~~ - fixed in ce72a89.

Installation:

make install

$ pgsql2shp
RELEASE: 2.5.1 (r17027)
USAGE: pgsql2shp [<options>] <database> [<schema>.]<table>
       pgsql2shp [<options>] <database> <query>

DouglasWJ · 2019-07-29T18:30:15Z

Seems instructions now broken due to upgrade to gdal 3 in the repositories.
EDIT: IT can be built using the --without-raster switch in the configure stage, however, this removes significant functionality (raster support and installing into the database via CREATE EXTENSION postgis;)

timlinux · 2019-07-30T21:27:56Z

@xeffyr I tried following your instructions but it seems like lots of the packages are not available:

td-static/stable 1.4.2-1 aarch64
$ pkg install wget curl build-essential libiconv-dev postgresql-dev libxml2-dev libsqlite-dev
Ign:1 https://dl.bintray.com/termux/termux-packages-24 stable InRelease
Ign:2 https://dl.bintray.com/grimler/game-packages-24 games InRelease
Ign:3 https://dl.bintray.com/grimler/science-packages-24 science InRelease
Get:4 https://dl.bintray.com/termux/termux-packages-24 stable Release [6061 B]
Hit:4 https://dl.bintray.com/termux/termux-packages-24 stable Release
Get:5 https://dl.bintray.com/grimler/game-packages-24 games Release [5344 B]
Hit:5 https://dl.bintray.com/grimler/game-packages-24 games Release
Get:7 https://dl.bintray.com/grimler/science-packages-24 science Release [5348 B]
Hit:7 https://dl.bintray.com/grimler/science-packages-24 science Release
Reading package lists... Done
Building dependency tree
Reading state information... Done
All packages are up to date.
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package libiconv-dev is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
  libiconv

Package libsqlite-dev is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
  libsqlite

Package libxml2-dev is not available, but is referred to by another package.
This may mean that the package is missing, has be
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
  libxml2

Package postgresql-dev is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
  postgresql

E: Package 'libiconv-dev' has no installation candidate
E: Package 'postgresql-dev' has no installation candidate
E: Package 'libxml2-dev' has no installation candidate
E: Package 'libsqlite-dev' has no installation candidate
$

ghost · 2019-07-30T21:48:07Z

Now:
libiconv-dev => libiconv
postgresql-dev => postgresql
libxml2-dev => libxml2
libsqlite-dev => libsqlite

btw, message has all suggestions:

Package libiconv-dev is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
  libiconv

timlinux · 2019-07-30T23:06:34Z

@xeffyr Thanks so much - I got it built and working. Here is the full set of steps I followed:

pkg install build-essential
pkg install wget curl  libiconv-dev postgresql-dev libxml2-dev libsqlite-dev readline-dev libiconv postgresql libxml2 libsqlite proj libgeos
wget https://download.osgeo.org/postgis/source/postgis-2.5.2.tar.gz
tar xfz postgis-2.5.2.tar.gz
cd postgis-2.5.2
./configure --prefix=$PREFIX --with-projdir=$PREFIX CFLAGS="-DACCEPT_USE_OF_DEPRECATED_PROJ_API_H=1" --without-raster
make -j8
make install
mkdir -p $PREFIX/var/lib/postgresql
initdb $PREFIX/var/lib/postgresql
pg_ctl -D $PREFIX/var/lib/postgresql start
psql -l
createdb gis
cd /data/data/com.termux/files/usr/share/postgresql/contrib/postgis-2.5/
psql gis -f postgis.sql
psql gis -f spatial_ref_sys.sql
pg_ctl -D $PREFIX/var/lib/postgresql stop
#termux-setup-storage
#mkdir TermuxData
#cd TermuxData/
#history > install-steps.txt

Progdrasil · 2020-07-20T20:43:31Z

What are the next steps now that it can be built to package this up?

mdouchin · 2021-01-01T12:19:58Z

@timlinux hey ;) Have you already tried PostgreSQL/PostGIS inside a Android 10 environment ? Happy new year !

jeanbarr · 2021-01-01T17:15:17Z

Yes it's possible to have postgresql and postgis on android 10.
The full set of steps of timlinux has to be modified
Instead of :
pkg install wget curl libiconv-dev postgresql-dev libxml2-dev libsqlite-dev readline-dev libiconv postgresql libxml2 libsqlite proj libgeos
we have to use:
pkg install wget curl libiconv postgresql libxml2 libsqlite proj libgeos

seabre · 2021-01-01T20:36:16Z

I built this last night using the latest stable release of PostGIS. You need to install additional packages for it to work, and raster support also seems to work, so compile options are different. Here's what I did:

pkg install build-essential
pkg install wget curl libiconv postgresql libxml2 libsqlite readline libiconv postgresql libxml2 libsqlite proj libgeos json-c libprotobuf-c
wget https://download.osgeo.org/postgis/source/postgis-3.1.0.tar.gz
tar xfz postgis-3.1.0.tar.gz
cd postgis-3.1.0
./configure --prefix=$PREFIX --with-projdir=$PREFIX
make -j8
make install
mkdir -p $PREFIX/var/lib/postgresql
initdb $PREFIX/var/lib/postgresql
pg_ctl -D $PREFIX/var/lib/postgresql start
psql -l
createdb gis

Then boot up psql: psql gis

Then inside the psql console run: CREATE EXTENSION postgis;
Hit enter, then you should have a functional postgis install:

mdouchin · 2021-01-14T09:30:33Z

Hi all, thanks for your help. I could not build postgis with @seabre guidelines, but needed instead to add the --without-raster option.

seabre · 2021-01-14T14:48:07Z

@mdouchin I wiped my termux install and tried from scratch to see what the issue was. In addition to the packages installed in the instructions above, the package gdal needs to be included. I forgot I had installed that way before attempting to compile PostGIS. Updated version is this:

pkg install build-essential
pkg install wget curl libiconv postgresql libxml2 libsqlite readline libiconv postgresql libxml2 libsqlite proj libgeos json-c libprotobuf-c gdal
wget https://download.osgeo.org/postgis/source/postgis-3.1.0.tar.gz
tar xfz postgis-3.1.0.tar.gz
cd postgis-3.1.0
./configure --prefix=$PREFIX --with-projdir=$PREFIX
make -j8
make install
mkdir -p $PREFIX/var/lib/postgresql
initdb $PREFIX/var/lib/postgresql
pg_ctl -D $PREFIX/var/lib/postgresql start
psql -l
createdb gis

mdouchin · 2021-01-14T16:42:33Z

@seabre Thanks a lot ! Tested and approved !

Silly newbie question: how hard would it be to add postgis as a termux package, since building is working ? I could follow a step-by-step "create a package" guide and provide some help ?

Grimler91 · 2021-01-14T21:36:45Z

@mdouchin I started looking at packaging postgis, but it needs some work when cross-compiling.

Configure steps tries to run various config tools (like pg_config), which does not work since those tools are compiled for android. So, need to override all those calls in some way.

Please have a look at the github wiki pages if you are interested in learning about how to create packages and the build system: https://github.com/termux/termux-packages/wiki/Creating-new-package, https://github.com/termux/termux-packages/wiki/Building-packages

Also, moving this to science-packages since it depends on packages there.

mdouchin · 2021-01-18T20:16:05Z

Thanks for your detailed answer. Meanwhile I created a script based on this issue answers https://github.com/mdouchin/termux-postgis-script
I need to improve it a little to check PostgreSQL before installing it, and also reference this issue.

mdouchin · 2021-06-14T17:14:13Z

Hello

I just tried today on a new termux instance, and encoutered an issue with libproj not found during the configure step
./configure --prefix=$PREFIX --with-projdir=$PREFIX

The error tells

Checking for proj.h .....yes
checking for pj_get_release in -lproj... no
configure error: could not find libproj - you may need to specify the directory of a PROJ installation using --with-projdir

I checked, and proj is installed in version 8.0.1 . Perhaps PostGIS 3.1.0 cannot be built against it ?
Bizare, this worked I think last week...

I really think we should provide a PostGIS package. I will try to help, but have not much time at present :(

Grimler91 · 2021-06-14T18:06:48Z

Could be that pj_get_release was renamed or modified in some way in the 8.0.1 update, so that the check fails. Check config.log for the full error and more details

mdouchin · 2021-06-14T20:20:14Z

Thanks for the answer.
I manage to solve this issue simply by using PostGIS 3.1.2 instead of 3.1.0

IMMSPgisgroup · 2021-11-20T21:13:47Z

I compiled PostGIS as in seabre instruction, but

~/postgis-3.1.1 $ ./configure --prefix=$PREFIX --with-projdir=$PREFIX
checking for a BSD-compatible install... /data/data/com.termux/files/usr/bin/install -c
checking build system type... aarch64-unknown-linux-gnu
checking host system type... aarch64-unknown-linux-gnu
checking how to print strings... printf
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for a sed that does not truncate output... /data/data/com.termux/files/usr/bin/sed
checking for grep that handles long lines and -e... /data/data/com.termux/files/usr/bin/grep
checking for egrep... /data/data/com.termux/files/usr/bin/grep -E
checking for fgrep... /data/data/com.termux/files/usr/bin/grep -F
checking for ld used by gcc... no
configure: error: no acceptable ld found in $PATH

What I do wrong?

Grimler91 · 2021-11-20T22:04:49Z

I compiled PostGIS as in seabre instruction, but
[...]
checking for ld used by gcc... no
configure: error: no acceptable ld found in $PATH
What I do wrong?

What compiler are you using? (clang or inofficial gcc?)

Try installing build-essential if not installed already, and check what the entire error message says in config.log

mdouchin · 2021-11-21T10:00:07Z

I also discovered recently you need to add these packages to make it work

binutils zstd zstd-static

IMMSPgisgroup · 2021-11-21T13:56:35Z

I added packages from mdouchin message. PostGIS 3.1.4 compiled.

In config.log I see about PKG_CONFIG_PATH. And I see some error messages.

...
conftest.c:9:10: fatal error: 'ac_nonexistent.h' file not found
#include <ac_nonexistent.h>
         ^~~~~~~~~~~~~~~~~~
1 error generated.
configure:7066: $? = 1
configure: failed program was:
| /* confdefs.h */
| #define PACKAGE_NAME ""
| #define PACKAGE_TARNAME ""
| #define PACKAGE_VERSION ""
| #define PACKAGE_STRING ""
| #define PACKAGE_BUGREPORT ""
| #define PACKAGE_URL ""
| /* end confdefs.h.  */
| #include <ac_nonexistent.h>
configure:7091: result: gcc -E
configure:7111: gcc -E  conftest.c
configure:7111: $? = 0
configure:7125: gcc -E  conftest.c
conftest.c:9:10: fatal error: 'ac_nonexistent.h' file not found
...
configure:25590: WARNING: 
configure:25592: WARNING:  | You are building using --with-projdir. This option isn't standard and    |
configure:25594: WARNING:  | might be incompatible with future releases of PROJ.                      |
configure:25596: WARNING:  | You can instead adjust the PKG_CONFIG_PATH environment variable if you   |
configure:25598: WARNING:  | installed software in a non-standard prefix.                             |
configure:25600: WARNING:  | Alternatively, you may set the environment variables PROJ_CFLAGS and     |
configure:25602: WARNING:  | PROJ_LIBS to avoid the need to call pkg-config.

postgis is not really set up for cross-compilation. It wants to run cross-compiled programs to check proj and protobuf versions, so we need to patch that in configure script. The current patch added to do this will be annoying to maintain. I tried patching the configure.ac script instead but got weird errors that seemed to have more to do with the autoconf version we have in the docker image. Fixes #8142

Grimler91 · 2021-12-05T12:59:29Z

Postgis has been added, seems to work when i run simple commands on archlinux wiki, but please test it and report issues

davemackintosh · 2021-12-12T17:24:59Z

I managed to install successfully thanks to @seabre's pkg install.

Grimler91 · 2021-12-12T19:29:00Z

@davemackintosh you mean compilation from source on device? Was there an issue with/did you try the package available through apt/pkg?

davemackintosh · 2021-12-12T20:30:16Z

🤡
It's Sunday. I'm tired. Damnit

This comment has been minimized.

Sign in to view

Grimler91 transferred this issue from termux/termux-packages Jan 14, 2021

Grimler91 transferred this issue from termux/science-packages Dec 4, 2021

Grimler91 closed this as completed in 714aa0d Dec 5, 2021

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Package request: postgis #8142

Package request: postgis #8142

sassanh commented May 21, 2017

its-pointless commented May 22, 2017

sassanh commented May 22, 2017

jeanbarr commented Mar 1, 2019

bencevans commented Jun 4, 2019

bencevans commented Jun 4, 2019

Grimler91 commented Jun 4, 2019 •

edited

Loading

bencevans commented Jun 4, 2019

Grimler91 commented Jun 4, 2019

This comment has been minimized.

ghost commented Jun 4, 2019 •

edited by ghost

Loading

DouglasWJ commented Jul 29, 2019 •

edited

Loading

timlinux commented Jul 30, 2019

ghost commented Jul 30, 2019 •

edited by ghost

Loading

timlinux commented Jul 30, 2019 •

edited

Loading

Progdrasil commented Jul 20, 2020

mdouchin commented Jan 1, 2021

jeanbarr commented Jan 1, 2021

seabre commented Jan 1, 2021

mdouchin commented Jan 14, 2021

seabre commented Jan 14, 2021

mdouchin commented Jan 14, 2021

Grimler91 commented Jan 14, 2021

mdouchin commented Jan 18, 2021

mdouchin commented Jun 14, 2021

Grimler91 commented Jun 14, 2021

mdouchin commented Jun 14, 2021

IMMSPgisgroup commented Nov 20, 2021

Grimler91 commented Nov 20, 2021

mdouchin commented Nov 21, 2021

IMMSPgisgroup commented Nov 21, 2021 •

edited

Loading

Grimler91 commented Dec 5, 2021

davemackintosh commented Dec 12, 2021

Grimler91 commented Dec 12, 2021

davemackintosh commented Dec 12, 2021

Package request: postgis #8142

Package request: postgis #8142

Comments

sassanh commented May 21, 2017

its-pointless commented May 22, 2017

sassanh commented May 22, 2017

jeanbarr commented Mar 1, 2019

bencevans commented Jun 4, 2019

bencevans commented Jun 4, 2019

Grimler91 commented Jun 4, 2019 • edited Loading

bencevans commented Jun 4, 2019

Grimler91 commented Jun 4, 2019

This comment has been minimized.

ghost commented Jun 4, 2019 • edited by ghost Loading

DouglasWJ commented Jul 29, 2019 • edited Loading

timlinux commented Jul 30, 2019

ghost commented Jul 30, 2019 • edited by ghost Loading

timlinux commented Jul 30, 2019 • edited Loading

Progdrasil commented Jul 20, 2020

mdouchin commented Jan 1, 2021

jeanbarr commented Jan 1, 2021

seabre commented Jan 1, 2021

mdouchin commented Jan 14, 2021

seabre commented Jan 14, 2021

mdouchin commented Jan 14, 2021

Grimler91 commented Jan 14, 2021

mdouchin commented Jan 18, 2021

mdouchin commented Jun 14, 2021

Grimler91 commented Jun 14, 2021

mdouchin commented Jun 14, 2021

IMMSPgisgroup commented Nov 20, 2021

Grimler91 commented Nov 20, 2021

mdouchin commented Nov 21, 2021

IMMSPgisgroup commented Nov 21, 2021 • edited Loading

Grimler91 commented Dec 5, 2021

davemackintosh commented Dec 12, 2021

Grimler91 commented Dec 12, 2021

davemackintosh commented Dec 12, 2021

Grimler91 commented Jun 4, 2019 •

edited

Loading

ghost commented Jun 4, 2019 •

edited by ghost

Loading

DouglasWJ commented Jul 29, 2019 •

edited

Loading

ghost commented Jul 30, 2019 •

edited by ghost

Loading

timlinux commented Jul 30, 2019 •

edited

Loading

IMMSPgisgroup commented Nov 21, 2021 •

edited

Loading