mimeo
mimeo copied to clipboard
Snapshot UNLOGGED source tables
Hello. I have a question.
Source postgresql have a table created by: CREATE UNLOGGED TABLE stat; Because, want to disable WAL and no want replication of this table on source postgresql cluster.
I want use snapshot mimeo replication for periodic copy this tables to destination postgresql cluster, but I want on destination postgresql have standard table, NOT UNLOGGED. Because I need to replicate this table on standby postgresql servers in destination postgresql cluster.
It`s possible? Thanks.
I believe this should be possible. It's not really caring what the object is on the source end. It currently supports tables and views for sources. And for snapshots, mimeo uses a two-table/one view system so that it can refresh the table with minimal downtime. It just builds those tables based on the column schema of the source and they are created as normal tables. A description of how snapshot works is in the intro blog post for mimeo - https://www.keithf4.com/mimeo-introduction/
So, simple answer is, it should work. If it doesn't, please let us know.