pgsync
pgsync copied to clipboard
toluaina
Write To Database Table Instead of Text File
Maintaining the generated pgsync file in the cloud has proven slightly cumbersome. I was wondering if we could have an option instead write the checkpoint into a database table? A table with a schema like:
| Checkpoint Name | Value |
|---|---|
<user>_<database>_<index> |
<Generated Hash> |
How about moving this to Redis? I'd prefer to pollute the database as little as possible. I think I had a POC branch to move this to Redis
@toluaina That is fair. I ended up actually Dockerizing my application and maintaining this checkpoint file within a persistent cache layer.