search

bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL
http://www.agensgraph.org
Other
1.32k stars 146 forks source link

grants issue while restoring pg_dumpall backup #593

Closed ns-berumalu closed 1 year ago

ns-berumalu commented 1 year ago

Hi , we are using pg_dumpall backups to restore. but we are frequently getting below grant issue when we are restoring.

agens:allbackup.sql:511129: ERROR: syntax error at or near "spm" LINE 1: GRANT USAGE ON GRAPH xxx TO readwrite; ^ agens:allbackup.sql:511130: ERROR: syntax error at or near "spm" LINE 1: GRANT USAGE ON GRAPH xxx TO readonly;

when we are running with modified one "GRANT USAGE ON SCHEMA xxx TO readwrite" , its working. Could you please suggest. =# GRANT USAGE ON schema xxx TO readwrite; GRANT =# GRANT USAGE ON schema xxx TO readonly; GRANT

emotionbug commented 1 year ago

Opps. We missed that. We'll fix it. thanks for your reporting.

ns-berumalu commented 1 year ago

@emotionbug

Is it bug, how to fix it in our environment.

ns-berumalu commented 1 year ago

@emotionbug

Any update on this. Any fixed release for this issue

emotionbug commented 1 year ago

This has been resolved. The patch has been applied to the all branches. It will be available in the next release.

ns-berumalu commented 1 year ago

@emotionbug

when next release will be available. Can we use this repo to fix the issue on our current environments

emotionbug commented 1 year ago

release date is not considered, yet. also, if you want apply patch right now, you can download and build from specific branch.

e.g., v2.12.0_hotfix_dump_restore