Changing Repository DB to PostgreSql

I have tried this process several time without any success. Here is what I did

1. Ran the Repository creation wizard. I did check the database and saw the tables created.
2. Went to Option and change the Repository connection to the one I just created in step 1 then pressed reconnect and I get several errors (attached in the order they came out) then I finally get to the program and everything is wiped out.

So I reconnect to the Access repository and everything is fine. I have tried to restore the repository after changing it to PG but that didn't work so I'm assuming the repository backup are specific for the database type. While this is not a critical issue but would be nice to move to PG at some point


What am I doing wrong? Please advise

I'm using version 5.2.0.4

Why your repository connection name is blank?

Mike

I don't think it makes a difference. I have tried it with the name and got the same results.

Did you select correct database name in odbc DSN?

Mike

Oh yeah, it does connect to the database, drops all the tables and recreate them but after that nothing works

That not what I meant.

You did not publish anything about your ODBC settings

Mike