Skip to content

PostGIS spatial database extension to OpenTenBase

License

GPL-2.0, Unknown licenses found

Licenses found

GPL-2.0
COPYING
Unknown
LICENSE.TXT
Notifications You must be signed in to change notification settings

OpenTenBase/postgis-for-opentenbase

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Postgis for OpenTenBase

Introduction

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.

How to install

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.

How to test

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 

How to use

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

CREATE EXTENSION postgis;

GitHub GitLab Drone.io
CI Gitlab-CI Build Status
Debbie Winnie Dronie
Build Status Build Status Build Status
Bessie Bessie32 Cirrus-ci
Build Status Build Status Build Status
Berrie Berrie64
Build Status Build Status

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

Official code repository, issue tracker and wiki:

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

Official chat room:

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:

Or join via matrix

Official source tarball releases

http://postgis.net/source

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

Project Home Page and Manuals

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

About

PostGIS spatial database extension to OpenTenBase

Resources

License

GPL-2.0, Unknown licenses found

Licenses found

GPL-2.0
COPYING
Unknown
LICENSE.TXT

Security policy

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published