Re: Can you refresh a materialized view from a materialized view on another server?

2024-04-19 Thread Adrian Klaver
On 4/18/24 19:49, Michael Nolan wrote: My production server has a materialized view that is refreshed from a mysql_fdw several times a day. What I'd like to be able to do is refresh the materialized view on the testbed server from the one on the production server so that they are the same.

Can you refresh a materialized view from a materialized view on another server?

2024-04-18 Thread Michael Nolan
My production server has a materialized view that is refreshed from a mysql_fdw several times a day. What I'd like to be able to do is refresh the materialized view on the testbed server from the one on the production server so that they are the same. (Refreshing it from the MySQL server will