0037310: Amazon RDS - Postgresql compatibility. Remove superuser role.

Notes
(0100791) caristu (developer) 2017-11-28 17:17 edited on: 2017-11-28 17:22	Added changes into dbsm-main repository[1]. See changesets 08ee84691713:caaf4ec353b2 [1] https://code.openbravo.com/erp/devel/dbsm-main [^]

(0100793) hgbot (developer) 2017-11-28 17:36	Repository: erp/devel/pi Changeset: bc62b428fd985c1545ce8e90818221e95d1961cd Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> Date: Tue Nov 28 17:36:39 2017 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/bc62b428fd985c1545ce8e90818221e95d1961cd [^] Related to issue 37310. New dbsourcemanager version to support rds. To properly support Amazon RDS it is required to create a prescript that it is executed with systemAdmin user. This new version of dbms enables that ability. --- M src-db/database/lib/dbsourcemanager.jar ---

(0100886) hgbot (developer) 2017-12-01 11:32	Repository: erp/devel/pi Changeset: 0247affd1bb7dbd9a6e0e265ee6aefd45d0a1211 Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> Date: Fri Dec 01 11:32:33 2017 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/0247affd1bb7dbd9a6e0e265ee6aefd45d0a1211 [^] Fixed issue 37310. Add support for Amazon PG RDS database. Changes required to support Amazon PG RDS. bbdd.user is no longer superuser new prescript added in postgresql to execute with bbdd.systemUser to create requried pg extensions that need superuser privileges to execute. *uuid_generate_v4 function is now created by creating the full uuid-ossp instead of just the function. --- M src-db/database/build-create.xml M src-db/database/build.xml M src-db/database/model/excludeFilter.xml M src-db/database/model/postscript-PostgreSql.sql M src-db/database/model/prescript-PostgreSql.sql A src-db/database/model/prescript-systemuser-PostgreSql.sql ---

(0101112) alostale (manager) 2017-12-19 08:01	reviewed

(0101493) hudsonbot (developer) 2018-01-03 12:39	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c81e0d3cbab5 [^] Maturity status: Test

(0101508) hudsonbot (developer) 2018-01-03 12:39	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c81e0d3cbab5 [^] Maturity status: Test

Issue History
Date Modified	Username	Field	Change
2017-11-16 13:40	gorkaion	New Issue
2017-11-16 13:40	gorkaion	Assigned To	=> gorkaion
2017-11-16 13:40	gorkaion	Modules	=> Core
2017-11-16 13:40	gorkaion	Triggers an Emergency Pack	=> No
2017-11-28 17:17	caristu	Note Added: 0100791
2017-11-28 17:18	caristu	Note Edited: 0100791	View Revisions
2017-11-28 17:22	caristu	Note Edited: 0100791	View Revisions
2017-11-28 17:36	hgbot	Checkin
2017-11-28 17:36	hgbot	Note Added: 0100793
2017-12-01 11:32	hgbot	Checkin
2017-12-01 11:32	hgbot	Note Added: 0100886
2017-12-01 11:32	hgbot	Status	new => resolved
2017-12-01 11:32	hgbot	Resolution	open => fixed
2017-12-01 11:32	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/0247affd1bb7dbd9a6e0e265ee6aefd45d0a1211 [^]
2017-12-01 11:53	gorkaion	Review Assigned To	=> alostale
2017-12-19 08:01	alostale	Note Added: 0101112
2017-12-19 08:01	alostale	Status	resolved => closed
2017-12-19 08:01	alostale	Fixed in Version	=> 3.0PR18Q1
2018-01-03 12:39	hudsonbot	Checkin
2018-01-03 12:39	hudsonbot	Note Added: 0101493
2018-01-03 12:39	hudsonbot	Checkin
2018-01-03 12:39	hudsonbot	Note Added: 0101508
2018-09-20 13:39	caristu	Relationship added	related to 0039273