How to set up PostgreSQL server for new Collect?

  • Asked
  • Active
  • Viewed 7192 times
0

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

2

Accepted answer

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

1

Accepted answer

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

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.