https://www.percona.com/blog/postgres_fdw-enhancement-in-postgresql-14/ Wed, 24 Nov 2021 17:02:51 +0000 hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/postgres_fdw-enhancement-in-postgresql-14/#comment-10973412 Wed, 24 Nov 2021 17:02:51 +0000 https://www.percona.com/blog/?p=76265#comment-10973412 That’s amazing. I am surprised by the small number of companies using FDW today, as it is such an advanced and powerful tool. One question though, let’s say I have 35 microservices, each one running a remote database and one of these databases changes its schema. Is there a way of syncing this to the MASTER PostgreSQL so that it can refresh the schema on its side? Thanks!!

]]> https://www.percona.com/blog/postgres_fdw-enhancement-in-postgresql-14/#comment-10973289 Wed, 11 Aug 2021 18:21:31 +0000 https://www.percona.com/blog/?p=76265#comment-10973289 I have 1,000 stores. Each has it’s own Postgres server and database. The tables are the same at each store. Can I use postgres_fdw to create a single db that has access to the cumulative data of all stores? Ideally I want each table to have an extra field added that will identify which store provided the data.

]]>