Container relations

[ElsunNabatov]

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

[yugo-n]

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?