Hi Javier, there is no standard procedure defined for migrating existing HSQL database to PostgreSQL. You can export your Jahia virtual site from Jahia instance, running on HSQL, and import it on a fresh installation of Jahia, configured for PostgreSQL.
Kind regards Sergiy Javier Turégano wrote: > OK, giving the right privileges to jahia user was the point. Now Jahia is > working ok with the remote postgresql db. > > What I am dubting if the process of migration from the hsql to the > postgres was right. First i have character coding issues, maybe HSQL and > postgres were not working in the same locale configuration. Has anybody > migrated from HSQL to Postgres succesfully? I think our process is not the > right one. > > By the other hand I am getting the next error in the catalina.out log: > > org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch > update > > I dont know exactly where can the problem come form. > > _______________________________________________ install_list mailing list [email protected] http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list
