[teiid-issues] [JBoss JIRA] (TEIID-4251) Built in support for Postgres DB as materialization target
Steven Hawkins (Jira)
issues at jboss.org
Fri Jun 28 14:32:00 EDT 2019
[ https://issues.jboss.org/browse/TEIID-4251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13753649#comment-13753649 ]
Steven Hawkins commented on TEIID-4251:
---------------------------------------
> I thought they were based on the status table times
Not at start-up, we just schedule a job based upon the ttl. Obviously that wouldn't be too hard to correct.
> We really do not need coordination among nodes as if you use cental PG store right?
That is correct. You make the single pg instance the master / owner of the materialization process. Things may get more complicated if at scale (or when considering multi-tenant) we need a pg cluster.
> Built in support for Postgres DB as materialization target
> ----------------------------------------------------------
>
> Key: TEIID-4251
> URL: https://issues.jboss.org/browse/TEIID-4251
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 12.3
>
>
> 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.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
More information about the teiid-issues
mailing list