---
title: "How to set up PostgreSQL server for new Collect?"
url: "https://openforis.support/questions/1228/how-to-set-up-postgresql-server-for-new-collect"
tags: ["openforis", "collect"]
status: "accepted"
score: 0
answer_count: 2
asked: "2017-04-27T19:27:33"
last_activity: "2017-04-28T03:51:18"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2021. Some rights reserved under creative commons license."
---

# How to set up PostgreSQL server for new Collect?

Asked by dhunganamilan on 2017-04-27

Hello Everyone,
I had set up PostgreSQL to store the data in my old Openforis Collect. Since the new update/install of the Collect I couldn't find any of my work in Collect interface that was previously in PostgreSQL. As new Collect becomes entirely different than the previous one, could anyone suggest me how to set up PostgreSQL to store my database in the latest version? 

Regards
Milan


## Accepted answer (score 2, by Lauri (OF) on 2017-04-28)

Link: https://openforis.support/questions/1228/how-to-set-up-postgresql-server-for-new-collect/1230

Hi Milan,

this should work. Go to this folder:
**C:\Users\USERNAME\OpenForis\Collect**
and take a safety copy of the original file **collect.properties**

Then change the settings to be as follows:

----
collect.http_port=8380

collect.db.jndiName=jdbc/collectDs

collect.db.driverClassName=org.postgresql.Driver

collect.db.url=jdbc:postgresql://localhost:5432/collect

collect.db.username=collect

collect.db.password=collect123

collect.db.initialSize=5

collect.db.maxActive=20

collect.db.maxIdle=5

------------
Then start Collect with the Launcher.

Regards, Lauri


## Answer (score 1, by Stefano (OF) on 2017-04-27)

Link: https://openforis.support/questions/1228/how-to-set-up-postgresql-server-for-new-collect/1229

Hi Milan,  
In the Collect installation folder there is a file called `collect.properties`. Please modify it and set the correct parameters to access your database.  
Many thanks,  
Open Foris Team