yugo-n
commented
1 year ago What should I do for creating immv based on base table which is located in different container?
Unfortunately, pg_ivm cannot create an IMMV that contains table in other PostgreSQL instance. What use cases do you need the feature for?
Hi. we have 2 postgresql containers with same postgresql user, same host address different port numbers (xxx20 & xxx24) in one virtual machine. I succeed to install pg_ivm as extension, and in same container I succeeded to create immv table & it is updating immediately. I installed pg_ivm in container 1 (xxx20), but I didn't install in container 2 (xxx24). Case is that I want to get base table from container 2, and create immv table in container 1. note: Every container has different passwords.
Questions: What should I do for creating immv based on base table which is located in different container? Should I install also pg_ivm extension in container 2 (xxx24)? Is there any way to verify that pg_ivm is installed successfully and working well? Because I doubt that we installed partial part.
@yugo-n