Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sync_zhprs_custom_word()这个函数能否改成使用自定义的数据路径,不用PG的数据目录 #86

Open
Poiig opened this issue Nov 6, 2024 · 4 comments

Comments

@Poiig
Copy link

Poiig commented Nov 6, 2024

sync_zhprs_custom_word函数中使用PG数据目录作为字典存储位置,会有一定的问题。Barman进行备份的时候,会报错。

下面为Barman日志:

2024-11-06 09:55:01,853 [96037] barman.wal_archiver INFO: No xlog segments found from streaming for xxx.
2024-11-06 09:55:01,858 [96036] barman.wal_archiver INFO: No xlog segments found from streaming for xxxxx.
2024-11-06 09:55:17,068 [95003] barman.backup_executor INFO: WARNING: skipping special file "./.s.PGSQL.5432"
2024-11-06 09:55:17,085 [95003] barman.backup_executor INFO: pg_basebackup: 已完成检查点
2024-11-06 09:55:17,105 [95003] barman.backup_executor INFO: pg_basebackup: 错误: 无法得到复制数据流: ERROR: invalid segment number 0 in file "zhprs_dict_xxxxx.txt"
2024-11-06 09:55:17,105 [95003] barman.backup_executor INFO: pg_basebackup: 删除数据目录 "/backup/streaming_backup/xxxxxx/base/20241106T093927/data" 的内容

@Poiig
Copy link
Author

Poiig commented Nov 7, 2024

你的意思是,barman备份完成后,再restore回去吗

@Poiig
Copy link
Author

Poiig commented Nov 7, 2024

这个本地文件存在的意义是什么,数据库中不是存在一个表用来记录自定义词典了吗

@Poiig
Copy link
Author

Poiig commented Nov 7, 2024

image
我可以重新定义这个存储过程,虽然说可能更新会导致失效。

修改这个存储过程的文件存储位置,对于分词插件有影响吗

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants