postgres_fdw -> Crate

[robd003]

Has anyone had luck connecting Crate to a Postgres server via foreign data wrappers?

[proddata]

We tested it a while ago. As far as I remember one missing feature was cursor support, which currently is being worked on and might be released with 5.0 within the coming weeks, or otherwise the next iteration.

[robd003]

By the way it would be AMAZING if Crate could do it's own "FDW" connections to other Postgres databases.

Being able to join from external postgres databases would be immensely useful. At the moment I've been writing crappy functions that will annotate the results from Crate with extra properties from other Postgres databases. (I tried doing nightly database sync's but we'd always have missing rows throughout the day)

...just posted this and and then saw that it's on the list #12686

Crate rocks!

[hlcianfagna]

Hi @robd003 ,
just wanted to give you a quick update on this front,

since CrateDB added support for DECLARE CURSOR it is now possible to use postgres_fdw to query CrateDB from a PostgreSQL instance (but there are currently some limitations depending on the queries and the version of PostgreSQL - see https://community.crate.io/t/cratedb-postgres-fdw-limit-parameter/1420 for details)

you also mention syncing of data from other DBs to CrateDB
while waiting for #12686
you could use the approach from https://community.crate.io/t/replicating-data-from-other-databases-to-cratedb-with-debezium-and-kafka/1388

I hope this helps.