[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17198112#comment-17198112 ] Karl Wright commented on CONNECTORS-1648: - Site has been updated but the mirror is apparently not working. I've alerted infrastruct...@apache.org. > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > Fix For: ManifoldCF 2.17 > > Attachments: image-2020-09-17-11-42-02-988.png > > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17198018#comment-17198018 ] Karl Wright commented on CONNECTORS-1648: - It has already been released. Site update hasn't happened yet is all. No time; I have multiple work-related crises and just have no cycles. You can download the release with the same URL as the 2.16 release; just change the 2.16 to 2.17. > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > Fix For: ManifoldCF 2.17 > > Attachments: image-2020-09-17-11-42-02-988.png > > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17197899#comment-17197899 ] DK commented on CONNECTORS-1648: [~kwri...@metacarta.com] When can we expect 2.17 to be released? I see 30/08/2020 as the release date. Is it expected to be released by this month? !image-2020-09-17-11-42-02-988.png! Thanks > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > Fix For: ManifoldCF 2.17 > > Attachments: image-2020-09-17-11-42-02-988.png > > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17192363#comment-17192363 ] Karl Wright commented on CONNECTORS-1648: - Ok, we tested through 12.2. If Postgres has chosen to get rid of more stuff since then you're on your own to find what they did and find a workaround. We can't keep up with them at the moment. See: https://issues.apache.org/jira/browse/CONNECTORS-1642 The date on that ticket is *May* of this year, and they've gone through two releases since then and broken things in doing so. > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > Fix For: ManifoldCF 2.17 > > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17192290#comment-17192290 ] DK commented on CONNECTORS-1648: Hi [~kwri...@metacarta.com], Switched to 2.16 and facing the same issue while connecting to Postgresql 12.4.(Trying 12.3 for now since we are not able to find the right download for 12.3). Any patches or something else we should try? Thanks > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > Fix For: ManifoldCF 2.17 > > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17190764#comment-17190764 ] Karl Wright commented on CONNECTORS-1648: - Hi, This was addressed in MCF release 2.16. > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > Fix For: ManifoldCF 2.17 > > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17190753#comment-17190753 ] DK commented on CONNECTORS-1648: getting this error from initialize script: org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: SQLException doing query (42703): ERROR: column pg_attrdef.adsrc does not exist Position: 447 at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.finishUp(Database.java:715) at org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:741) at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:803) at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1457) at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:146) at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:204) at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performQuery(DBInterfacePostgreSQL.java:837) at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.getTableSchema(DBInterfacePostgreSQL.java:696) at org.apache.manifoldcf.core.database.BaseTable.getTableSchema(BaseTable.java:185) at org.apache.manifoldcf.agents.agentmanager.AgentManager.install(AgentManager.java:67) at org.apache.manifoldcf.agents.system.ManifoldCF.installTables(ManifoldCF.java:112) at org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(InitializeAndRegister.java:39) at org.apache.manifoldcf.crawler.InitializeAndRegister.main(InitializeAndRegister.java:60) Caused by: org.postgresql.util.PSQLException: ERROR: column pg_attrdef.adsrc does not exist Position: 447 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117) at org.apache.manifoldcf.core.database.Database.execute(Database.java:902) at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:696) > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > Fix For: ManifoldCF 2.17 > > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17190726#comment-17190726 ] DK commented on CONNECTORS-1648: Hi [~kwri...@metacarta.com] , Is there any pointers regarding postgres 12.3 compatibility? Thanks > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > Fix For: ManifoldCF 2.17 > > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17183552#comment-17183552 ] DK commented on CONNECTORS-1648: [~michaelcizmar] Did you get a chance to run performance test? Could you advise on compatibility, results and versions used? [~kwri...@metacarta.com] Should we use the same postgres jdbc driver or need to upgrade? We are using Manifold 2.11. Would like to understand if manifold version needs to be upgraded as well to support PG 12.3 if there is no issue in performance tests. Thanks > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > Fix For: ManifoldCF 2.17 > > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17153142#comment-17153142 ] Michael Cizmar commented on CONNECTORS-1648: No. I can give that a go in the next week or so and report back. > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > Fix For: ManifoldCF 2.17 > > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17152982#comment-17152982 ] Furkan Kamaci commented on CONNECTORS-1648: --- [~michaelcizmar] have you run any performance test regarding PostgreSQL 12 as like here: [https://manifoldcf.apache.org/release/release-2.15/en_US/how-to-build-and-deploy.html] > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > Fix For: ManifoldCF 2.17 > > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17152789#comment-17152789 ] Karl Wright commented on CONNECTORS-1648: - Going back over my notes, we updated the code to work with Postgresql 12.1 not long ago. So I will update the compatibility list in the doc. > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17152786#comment-17152786 ] Karl Wright commented on CONNECTORS-1648: - Anyone with a successful deployment on newer versions is evidence that the newer versions are ok and we can update the doc. Other than running the load tests, there is no other magic we do to verify a platform. > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Assignee: Karl Wright >Priority: Major > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CONNECTORS-1648) PostgreSQL 10,11 and 12 support
[ https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17152340#comment-17152340 ] Michael Cizmar commented on CONNECTORS-1648: It works with new versions. I think we've run it on 10 and 11 recently. I would like this updated as well. > PostgreSQL 10,11 and 12 support > --- > > Key: CONNECTORS-1648 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1648 > Project: ManifoldCF > Issue Type: Improvement >Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13, > ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16 >Reporter: DK >Priority: Major > > As per the current documentation, "ManifoldCF has been tested against version > 8.3.7, 8.4.5 and 9.1 of PostgreSQL. " > 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already. > No support for newer versions. > This is important to deploy ManifoldCF in an enterprise environment where > value added service such as HA, Backup and Recovery and Monitoring etc are > provided by third party vendors. These vendors do not support postgreSql > versions which are reaching end of life. > Any plan to test and certify recent versions such as 10,11 and 12.3? > -- This message was sent by Atlassian Jira (v8.3.4#803005)