setting up Jira, Test Connection, getting" you have specified Database that is not empty...

[Andre Wiejacki]

I have setup a PostgreSQL database and I did not add any dbr.

[Nic Brough -Adaptavist-]

The error message is accurate - whatever database you have pointed Jira at contains some data.  You need to give it an empty database to work with.

[Andre Wiejacki]

Hi Nic Brough,

Thank you for reply.

I used CREATE Database command to create a NEW database. There are always some default tables created with CREATE command. I DID NOT use ANY OTHER commands, ex. create table, update table, insert, etc., so I expect any software accessing my NEW database to see it as  an EMPTY Database. This is obviously not a case with connecting to Jira. As I stated, Yes, my PostgreSQL database contains some "system data" but should not contain any "User added" data, so should be considered EMPTY. Maybe this will help to understand better my real issue here, not only to "confirm" an error message. I made some research on your blog prior to my publishing of this issue. I have found some other instances of Jira users getting the same message of "database not empty" following their activities. So I do not seem to be alone with this issue. Also, I have seen some "solutions to this problem: Create a DUMP of this current database with some "exotic" parameters  and re-load my "not EMPTY" database with this dump file that suppose to reset some indices to make my database "look empty". I was not sure that I wanted to go that direction. I am sure I am missing a point here. But where? On the PostgreSQL database or on the Jira side? Thank you for your assistance.  

[Nic Brough -Adaptavist-]

>I used CREATE Database command to create a NEW database.

Good, that is exactly what you need to do

>There are always some default tables created with CREATE command.

No.  There is not.  If you create a new database in PostGres, you get no tables in it until you create them.  When I look at the databases I have here, the empty ones really are empty.

What you need to do here is create a new database with nothing in it and point your Jira at it.

[Andre Wiejacki]

Hi Nic,

Thank you very much for your help. I will now concentrate on making sure that my database is really empty.

Thank you again.

Best Regards,

Andre