Re: Jahia postgresql problem. catalina.out

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=E9gano 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