This is the setting I am thinking of, I believe we have root pg credentials to create more databases. We have to check out the PG's operator, it may have something there? Or should become a task in our operator somehow?

I was meaning no security, as it is intracluster and trust the client app. But trusting over the certificate is the correct way.

Built in support for Postgres DB as materialization target ---------------------------------------------------------- Key: TEIID-4251 URL: https://issues.jboss.org/browse/TEIID-4251 Project: Teiid Issue Type: Sub-task Components: Server Reporter: Ramesh Reddy Assignee: Steven Hawkins Priority: Major Fix For: 12.2 If Postgres database is available along with install or assumed that it is available, then some of the materialization task can be automated, like - Creation of a common STATUS table - Creation of the materilization targets (create views on dbms) - On load, on undeploy and load scripts for all the materialization views We need to device a way this to be pluggable, such that based on success of this, we can provide additional support for other sources.