You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/12/09 01:23:29 UTC

[GitHub] [shardingsphere] oneslideicywater opened a new issue #14008: failed backup database with postgis extension enabled when using pg_dump

oneslideicywater opened a new issue #14008:
URL: https://github.com/apache/shardingsphere/issues/14008


   It's very nice that I successfully build an image `apache/shardingsphere-proxy:5.0.1-SNAPSHOT` [refer to this link](https://github.com/apache/shardingsphere/issues/13978), 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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] terrymanu commented on issue #14008: failed backup database with postgis extension enabled when using pg_dump

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #14008:
URL: https://github.com/apache/shardingsphere/issues/14008#issuecomment-997427236


   No plan to support pg_dump now, anybody interesting this issue?


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org