The only thing we could do is have a single pg instance have multiple databases - which is not something the default install is setup to do.

What do you mean by implicitly trusted over service?

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.