search

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.87k stars 1.05k forks source link

[YSQL] Postgis in kubernetes #2861

Open tuanng-cognite opened 4 years ago

tuanng-cognite commented 4 years ago

Jira Link: DB-4723 I followed the instruction here https://docs.yugabyte.com/latest/api/ysql/extensions/#postgis

However, when running command:

./bin/ysqlsh -c "CREATE EXTENSION postgis"

I got this error,

ERROR: could not load library "/home/yugabyte/postgres/lib/postgis-2.5.so": liblwgeom-2.5.so.0: cannot open shared object file: No such file or directory

Note that I was running Yugabyte db inside kubernetes, not locally. So I have to copy files (.so, .sql, .control) into pod yb-tserver-0

jaki commented 4 years ago

Hi, @tuanng-cognite. We haven't tried PostGIS with Kubernetes, yet. Thanks for reporting the issue. We will try to reproduce the error and get back to you.

tuan-nng commented 4 years ago

So, how do you install it in distributed database setup?

jaki commented 4 years ago

Today, the setup steps are manual, and you'll need to do them on every node of the cluster.