oneslideicywater commented 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:
   
   using pg_dump dump the logical database `sharding_db` (with postgis 
extension enabled using `CREATE EXTENSION postgis;`) failed:
   
   ```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]


Reply via email to