---
title: "Can't start Collect when connecting to PostgreSQL"
url: "https://openforis.support/questions/1013/cant-start-collect-when-connecting-to-postgresql"
tags: ["collect"]
status: "answered"
score: 0
answer_count: 4
asked: "2017-01-19T18:23:39"
last_activity: "2017-01-25T12:13:01"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# Can't start Collect when connecting to PostgreSQL

Asked by Tobias on 2017-01-19

Dear Community,

I am trying to change from SQLite to PostgreSQL. After applying the steps given in the manual (with the additional manual steps of creating a database and schema "collect") I am still not able to open collect. I have tried to change the port and I have deactivated my firewall, as well as I have changed the seetings in the postgres files (postgres and pg_hba), but it still does not work. The response it get is: localhost page can't be found (HTTP ERROR 404) Do you know what the problem could be? 

Thanks in advance,


Tobias


## Answer (score 0, by Stefano (OF) on 2017-01-19)

Link: https://openforis.support/questions/1013/cant-start-collect-when-connecting-to-postgresql/1015

Hi Tobias,  
Can you share with us the Collect log file? You can find it in C:\opt\openforis\collect\tomcat\webapps\collect\logs\collect.log  
It will give us some more information about the problem. What version of PostgreSQL are you using?  
Thanks,  
Open Foris Team


## Answer (score 0, by Tobias on 2017-01-19)

Link: https://openforis.support/questions/1013/cant-start-collect-when-connecting-to-postgresql/1016

I will send you the file via mail. What is the address?


## Answer (score 0, by Stefano (OF) on 2017-01-19)

Link: https://openforis.support/questions/1013/cant-start-collect-when-connecting-to-postgresql/1017

We will contact you to your private email address.  
Thanks,  
Open Foris Team


## Answer (score 0, by Stefano (OF) on 2017-01-25)

Link: https://openforis.support/questions/1013/cant-start-collect-when-connecting-to-postgresql/1020

Dear Tobias,  
We found a problem running Collect up to version 3.12.8 using the latest version of PostgreSQL (9.6). The problem is due to a non-backwards change in PostgreSQL that caused the problem you had.  
Please update Collect to the latest version (3.12.9) and you shouldn't have again the same problem.  
Many thanks,  
Open Foris Team