ODK Aggregate on Postgresql

Support
1

ODKers,

Is setting up Aggregate on postgresql such a pain (was hoping to try and review performance between postgres and mariaDB)?

I have been trying this out for a few weeks with no success. I even installed pgAdmin to easily work on GUI but all seem not succeed.

Any success story of ODK Aggregate running on postgres to share?

Paul

2

I run Aggregate on PostgreSQL and MySQL on macOS and Ubuntu. What platforms are you using? What specific problems are you having?

3

I am running CentOs 7. Running the sql file wasn't easy but I succeed on pgAdmin. However, when I put the war file on webapps folder the instance doesn't load. I will get the Catalina.out logs and share.

2 Likes
4

Hi, @paul_macharia!

when I put the war file on webapps folder the instance doesn't load

If you get a popup saying "You don't have permission for this action. Error: Invalid request", it's because you have some cookies problem. You can try to access aggregate on incognito mode or clean your browser's history.

If this is not what's happening, you should have an error report in Tomcat's catalina.out log file. Could you check and attach it here, please?