# Using atlassian-connect-express with postgres

**URL:** <https://community.developer.atlassian.com/t/using-atlassian-connect-express-with-postgres/14500>\
**Category:** Jira Cloud\
**Tags:** postgres, jira-cloud\
**Created:** [February 6, 2018, 10:22pm UTC](https://community.developer.atlassian.com/t/using-atlassian-connect-express-with-postgres/14500 "2018-02-06T22:22:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jan.revis](https://sea1.discourse-cdn.com/atlassiandeveloper/user_avatar/community.developer.atlassian.com/jan.revis/32/322_2.png) [@jan.revis](https://community.developer.atlassian.com/u/jan.revis)\
**Post date:** [February 6, 2018, 10:22pm UTC](https://community.developer.atlassian.com/t/using-atlassian-connect-express-with-postgres/14500/1 "2018-02-06T22:22:45Z")

</div>

I have been developing connect addons for a while, but am trying out atlassian-connect-express for the first time. I am unable to install the addon when using postgres as my store and sequelize for my adapter. The installation times out, and I receive no feedback through the console.

My store is defined in my config.json as follows:

```
    "store": {
        "adapter": "sequelize",
        "type": "postgres",
        "database": "dbname",
        "url":"postgres://127.0.0.1/dbname?user=admin&password=password"
    }

```

The database is in a docker container running on my local machine. Database is dbname, user is admin.

The addon installs successfully if I use the sqlite3 adapter. Is there anything I need to do to have the addon work with postgres.

---

<div class="post-metadata">

**Author:** ![jan.revis](https://sea1.discourse-cdn.com/atlassiandeveloper/user_avatar/community.developer.atlassian.com/jan.revis/32/322_2.png) [@jan.revis](https://community.developer.atlassian.com/u/jan.revis)\
**Post date:** [February 7, 2018, 12:43am UTC](https://community.developer.atlassian.com/t/using-atlassian-connect-express-with-postgres/14500/2 "2018-02-07T00:43:44Z")

</div>

I finally solved my own problem. The issue was the connection url. The correct format would be  
postgres://admin:password@127.0.0.1/dbname

---

<div class="post-metadata">

**Author:** ![rwhitbeck](https://sea1.discourse-cdn.com/atlassiandeveloper/user_avatar/community.developer.atlassian.com/rwhitbeck/32/35781_2.png) [@rwhitbeck](https://community.developer.atlassian.com/u/rwhitbeck)\
**Post date:** [February 7, 2018, 1:51am UTC](https://community.developer.atlassian.com/t/using-atlassian-connect-express-with-postgres/14500/3 "2018-02-07T01:51:32Z")

</div>

Thanks for coming back with your solution!

---

<div class="post-metadata">

**Author:** ![stevemac](https://sea1.discourse-cdn.com/atlassiandeveloper/user_avatar/community.developer.atlassian.com/stevemac/32/37404_2.png) [@stevemac](https://community.developer.atlassian.com/u/stevemac)\
**Post date:** [June 23, 2019, 5:38am UTC](https://community.developer.atlassian.com/t/using-atlassian-connect-express-with-postgres/14500/4 "2019-06-23T05:38:48Z")

</div>

@jan.revis @rwhitbeck  
I’m facing the same issue. I have replicated the settings in the ‘store’ object above. It seems to work for production, but not development - the ‘/installed’ route times out. My DB is on a seperate server.