topic Re: Postgres Change Schema in Alfresco Archive

Postgres Change Schema

abbask — Thu, 28 Apr 2016 06:16:54 GMT

By default Activiti creates tables in the Public schema (in postgres). how can i change this setting to use some other schema e.g. "my-activiti-schema"

Re: Postgres Change Schema

hari — Thu, 28 Apr 2016 11:17:21 GMT

You can change the schema in activiti-app.properties which is present under tomcat>lib folder

Re: Postgres Change Schema

abbask — Fri, 29 Apr 2016 09:02:59 GMT

HI Hari,
Can you please tell me which property to create/modify?

Re: Postgres Change Schema

hari — Mon, 02 May 2016 07:18:47 GMT

I m sorry Abbas. I got your question wrong. Even I m unaware of that.
Lets wait for someone else's reply here.

Re: Postgres Change Schema

jbarrez — Tue, 03 May 2016 12:42:56 GMT

You can provide the schema in the jdbc url in recent versions of the postgres driver afaik.

Re: Postgres Change Schema

abbask — Wed, 04 May 2016 09:20:30 GMT

I have tried it using: http://<my_host>/<db_name>?currentpath=<schema_name>
but it does not work it creates tables in public schema only.

Re: Postgres Change Schema

jbarrez — Tue, 10 May 2016 09:48:33 GMT

should be currentSchema instead:

jdbcostgresql://localhost:5432/mydatabase?currentSchema=myschema