Installing PostjreSQL 9.3.25, get stuck when running "config.bat" from the bin directory of Jira

[Thomas Murray]

I was able to get to main step 2 in this document.. https://confluence.atlassian.com/adminjiraserver070/connecting-jira-applications-to-postgresql-749382637.html

I have a current H1 demo database that I populate with a bunch of configuration, and I'm trying to move it to PostjreSQL 9.3.

When I run "config.bat" I get the error "No JRE_HOME or JAVAHOME environment variable is set - attempting to just run 'java' command  8 was unexpected at this time."

So I can't get the Jira Database Connector to open.  I have Java 8 u 221 installed.  Do I need a different version maybe?  Or should that environment variable be set manually?  Didn't see anything in the instructions.  Thanks

[Bunty · Accepted solution]

Set the Java path with the below commands and try:

export JAVA_HOME=/opt/atlassian/jira/jre/
export PATH="$JAVA_HOME/:$PATH"

[Thomas Murray]

I tried but it did not work.  However, the suggestion did being me to Acrobat and enivormental variables.  Since I'm using JRE (not JDK), I set the Environment variable for JRE_HOME to equal the Java RE folder.  I was then able to open the settings, and put in the corrent ones.  I was able to connect to the database.

I am at this time trying to figure out how to move the data that was populated in the H1 database during eval to the new database.  How can I do that?  I checked the jiradb that was setup in PostjreSQL, and when I ran a backup of the file (it shouldn't be big, maybe 50 test tickets, 3 agents, 60 customers), it came out to 1KB.  So there's a step I am missing here.  Anyone have a suggestion.

Thanks again for the asssistance.

[Thomas Murray]

Beside making a backup of the PostjreSQL DB (JiraDB, which I'm not sure has any data in it, maybe it still resides in the H1 DB that it was originally populated into), is there any way to make sure that all the data that was in the H1 demo database (which we adjusted a great deal to our own needs, and don't want to speand the 2 weeks we spent completely customizing it), gets moved to the jiradb in PostjreSQL 9.3?  2) which database it will be writing to in the future.  I populated all of the directions and the POSTjreSQL seems to be up and running.  Thank you.