You are already using Postgres in your setup so why not just use Postgres itself as metadata database? It is a much better setup than using Iceberg [1].
> and it also ties to DuckDB land wherease with Iceberg many engines can query directly.
Ducklake can also be queried by many engines [2]. Though not as exhaustive as Iceberg.