How can I write to a remote DuckLake

[kinghuang]

The README shows replication from local or remote PostgreSQL tables to a DuckLake whose catalog is in the local PostgreSQL instance. How do I configure pg_duckpipe to replicate to some other DuckLake? I see that pg_ducklake supports connecting to DuckLakes via ducklake_fdw. It's not clear to me how to configure pg_duckpipe for this.

[YuweiXiao]

Hi, thanks for the interests. Syncing local pg tables to remote Ducklakes (with remote pg as catalog) is unsupported. Though technically possible, I would recommand using daemon mode for this usecase (https://github.com/relytcloud/pg_duckpipe/blob/main/doc/DAEMON.md).

[kinghuang]

Thanks, I'll look at the daemon. Can you give any pointers on how “technically possible” would work? Is that something I can configure?

[YuweiXiao]

It will require code changes (I believe). E.g., extending the interface to accept a remote pg as the DuckLake catalog.