oneslideicywater edited a comment on issue #13978:
URL:
https://github.com/apache/shardingsphere/issues/13978#issuecomment-988620559
@TeslaCN It's very nice that I successfully build an image
`apache/shardingsphere-proxy:5.0.1-SNAPSHOT`, the previous problem solved!.
but there's another question occurs:
dump the logical database `sharding_db` (with postgis extension enabled
using `CREATE EXTENSION postgis;`)
failed when using pg_dump
:
```bash
root@a15d5aac4a11:/var/lib/postgresql/data# pg_dump -U postgres -d
sharding_db -h 192.168.10.53 -p 13308 > test.sql
Password:
pg_dump: [archiver (db)] query failed: ERROR: You have an error in your SQL
syntax
pg_dump: [archiver (db)] query was: LOCK TABLE public.spatial_ref_sys IN
ACCESS SHARE MODE
```
but dump the physical database( not proxyed by sharding-proxy) is ok :
```bash
pg_dump -U postgres -d geo -h 192.168.10.53 -p 5432 > test.sql
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
