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