topic Moving data to external PostgreSql Server in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/moving-data-to-external-postgresql-server/m-p/12338#M5411 <HTML><HEAD></HEAD><BODY><P>Hi. I need&nbsp; move the data from the PostgreSql 9.3 running in the same server of Alfresco Share 5.0.c to an external database server. The internal server is running Postgres 9.3 and the new server has the Postgres 9.6.&nbsp; After a dump/restore, I need insert this entry in global-proprierties to Alfresco start:</P><P></P><P>db.schema.update=false</P><P></P><P>If I dont add this entry, Alfresco not start and I see in my logs:</P><P>2017-02-14 13:42:03,298&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://10.80.15.164:5432/alfresco, UserName=alfresco, PostgreSQL Native Driver<BR />2017-02-14 13:42:03,298&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.PostgreSQLDialect.<BR />2017-02-14 13:42:03,385&nbsp; ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed<BR />&nbsp;org.hibernate.exception.SQLGrammarException: could not get table metadata: JBPM_ACTION<BR />&nbsp;&nbsp; &nbsp;at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)</P><P></P><P>May occours dangerours problems if I leave the auto-update disabled ? Or how to solve this issue ?</P><P>Best regards.</P></BODY></HTML> Tue, 14 Feb 2017 17:16:20 GMT marcio 2017-02-14T17:16:20Z Moving data to external PostgreSql Server https://connect.hyland.com/t5/alfresco-forum/moving-data-to-external-postgresql-server/m-p/12338#M5411 Hi. I need&nbsp; move the data from the PostgreSql 9.3 running in the same server of Alfresco Share 5.0.c to an external database server. The internal server is running Postgres 9.3 and the new server has the Postgres 9.6.&nbsp; After a dump/restore, I need insert this entry in global-proprierties to Alfresco Tue, 14 Feb 2017 17:16:20 GMT https://connect.hyland.com/t5/alfresco-forum/moving-data-to-external-postgresql-server/m-p/12338#M5411 marcio 2017-02-14T17:16:20Z Re: Moving data to external PostgreSql Server https://connect.hyland.com/t5/alfresco-forum/moving-data-to-external-postgresql-server/m-p/12339#M5412 <HTML><HEAD></HEAD><BODY><P>Problem solved.</P><P>Replaced the file postgresql-9.3-1102-jdbc41.jar to postgresql-9.4.1212.jar (downloaded from <A class="link-titled" href="https://jdbc.postgresql.org/download.html" title="https://jdbc.postgresql.org/download.html" rel="nofollow noopener noreferrer">PostgreSQL JDBC Download</A>) in folder /opt/alfresco-install/tomcat/lib/</P></BODY></HTML> Thu, 16 Feb 2017 11:48:36 GMT https://connect.hyland.com/t5/alfresco-forum/moving-data-to-external-postgresql-server/m-p/12339#M5412 marcio 2017-02-16T11:48:36Z