Having Difficultly connecting to PostgreSQL

[Gren]

Have tried to set up Jira on my Windows 10 Pro 64-Bit PC but connecting to PostgreSQL has proved tricky.  I'm not a DBA but a development project manager so I am a little out of my skillset.  I've followed the instructions Atlassian provide but receive 'trying to get encrypted password from XML and decrypt it' - see above - this retries but fails and it seems to have set me up to use H2 not PostgreSQL.   I've attached the start-up log file and two files describing what I did to set PostgreSQL and Jira up - bound to be something stupid - please let me know if you know what I need to do to fix it.  

[Gren · Accepted solution]

Well, think I've just progressed from PM to DBA!  After a day of what felt like a life and death struggle I've set everything up and it works!  Problem was with the database connection - probably predictably enough.  Make sure you test the database connection when you run config.bat  https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-postgresql-938846851.html - it's quite happy to accept an error as an entry if you just save and don't test and once its given up on the connection then it gets rid of everything you configured and sets up the config file for H2 so you need to go back and set it up again.  Also worth considering that you don't need to set a user up for postgreSQL, you can use the default one of postgres.