This repo is a modified version of postgis extension based on Postgis 3.2.1. This version aims to enable the PostGIS extension to support the distributed features of OpenTenBase and to provide as much support as possible for any issues users may encounter during its use.

SOURCECODE_PATH=/your/path/to/OpenTenBase/source/code
INSTALL_PATH=/your/path/to/install/

# Get source code of Opentenbase
cd ${SOURCE_CODE_PATH}
git clone https://github.com/OpenTenBase/OpenTenBase

# Build & Install
cd ${SOURCECODE_PATH}/OpenTenBase
rm -rf ${INSTALL_PATH}/opentenbase_bin_v2.0
chmod +x configure*
./configure --prefix=${INSTALL_PATH}/opentenbase_bin_v2.0  --enable-user-switch --with-openssl --with-ossp-uuid CFLAGS="-g -DPGXC -D_PG_ORCL -DXCP  -D_USER_SWITCH_"
make clean
make -sj
make install
chmod +x contrib/pgxc_ctl/make_signature
cd contrib
make -sj
make install

# Get source code of postgis-for-otb
cd ${SOURCE_CODE_PATH}/contrib
git clone https://github.com/OpenTenBase/postgis-for-opentenbase.git

# Get dependency tarball

# The following tools are needed:
#     sqlite-autoconf-3390400
#     googletest-release-1.8.1
#     proj-6.2.0
#     gdal-3.4.1
#     geos-3.9.3
#     protobuf-3.7.1
#     protobuf-c-1.4
wget https://mirrors.cloud.tencent.com/macports/distfiles/sqlite3/sqlite-autoconf-3390400.tar.gz

wget https://github.com/google/googletest/archive/refs/tags/release-1.8.1.zip
mv ./release-1.8.1.zip ./googletest-release-1.8.1.zip

wget https://download.osgeo.org/proj/proj-6.2.0.tar.gz

wget https://download.osgeo.org/gdal/3.4.1/gdal-3.4.1.tar.gz

wget https://download.osgeo.org/geos/geos-3.9.3.tar.bz2

wget https://github.com/protocolbuffers/protobuf/releases/download/v3.7.1/protobuf-all-3.7.1.tar.gz
mv ./protobuf-all-3.7.1.tar.gz ./protobuf-3.7.1.tar.gz 

wget https://github.com/protobuf-c/protobuf-c/releases/download/v1.4.0/protobuf-c-1.4.0.tar.gz



# Compile dependency & postgis
cp ./postgis-for-opentenbase/deps/postgis_compile.sh ./
./postgis_compile.sh

# Then postgis extension has already built & installed to your OpenTenBase installation dir.

cd ${SOURCE_CODE_PATH}/contrib/postgis-for-opentenbase/
rm -r /tmp/pgis_reg/* 
make installcheck # This would output result to cmd line.

# If user wants to read from /tmp/res.txt, redirecting output using this cmd below.
# make installcheck > /tmp/res.txt 2>&1 

psql -U [USER_NAME] -p [PORT] -d [DB_NAME] -h [HOST_IP]

CREATE EXTENSION postgis;

---

GitHub	GitLab	Drone.io
Debbie	Winnie	Dronie
Bessie	Bessie32	Cirrus-ci
Berrie	Berrie64

This file is here to play nicely with modern code repository facilities. Actual readme is here.

https://trac.osgeo.org/postgis/

Official chat room is the #postgis:osgeo.org room on the Libera.chat network.

To participate, point your preferred IRC client to:

irc://irc.libera.chat/#postgis

Or try a web IRC client like:

• web.libera.chat

Or join via matrix

http://postgis.net/source

If you would like to contribute to this project, please refer to our contributing guidelines.

Project homepage: http://postgis.net/ PostGIS Manuals: http://postgis.net/documentation