# Not creating database when using SQLTrackerStore with Docker

**URL:** <https://forum.rasa.com/t/not-creating-database-when-using-sqltrackerstore-with-docker/24140>\
**Category:** Rasa Open Source\
**Created:** [January 29, 2020, 7:47pm UTC](https://forum.rasa.com/t/not-creating-database-when-using-sqltrackerstore-with-docker/24140 "2020-01-29T19:47:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![eugenelin89](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/eugenelin89/32/1626_2.png) [@eugenelin89](https://forum.rasa.com/u/eugenelin89)\
**Post date:** [January 29, 2020, 7:47pm UTC](https://forum.rasa.com/t/not-creating-database-when-using-sqltrackerstore-with-docker/24140/1 "2020-01-29T19:47:06Z")

</div>

New to Rasa, followed instruction in [Using PostgreSQL as Tracker Store](https://rasa.com/docs/rasa/user-guide/running-rasa-with-docker/#using-postgresql-as-tracker-store).

Getting the error:

> 2020-01-29 19:22:00,531 [DEBUG] Attempting to connect to database via ‘postgresql://postgres@postgres/rasa’.  
> 2020-01-29 19:22:00,862 [ERROR] Could not create tables: (psycopg2.OperationalError) FATAL: database “rasa” does not exist

Here is my the tracker\_store section in endponts.yml:

> tracker\_store:  
> type: sql . dialect: “postgresql”  
> url: postgres  
> db: rasa  
> username: postgres

Here’s my docker compose:

> version: ‘3.0’  
> services:  
> rasa:  
> image: rasa/rasa:latest-full  
> ports:  
> - 5005:5005 . volumes:  
> - ./:/app  
> command: run --log-file out.log --debug  
> action\_server:  
> image: rasa/rasa-sdk:latest  
> ports:  
> - 5055:5055  
> volumes:  
> - /home/eugene/chat/actions:/app/actions  
> postgres:  
> image: postgres:latest

Thanks!

Eugene

---

<div class="post-metadata">

**Author:** ![eugenelin89](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/eugenelin89/32/1626_2.png) [@eugenelin89](https://forum.rasa.com/u/eugenelin89)\
**Post date:** [January 30, 2020, 8:13pm UTC](https://forum.rasa.com/t/not-creating-database-when-using-sqltrackerstore-with-docker/24140/2 "2020-01-30T20:13:25Z")

</div>

> [@eugenelin89](#):
>
> [ERROR] Could not create tables: (psycopg2.OperationalError) FATAL: database “rasa” does not exist

Solved by adding the following to endpoints.yml in the tracker\_store section:  
login\_db: postgres

---

<div class="post-metadata">

**Author:** ![Arjaan](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/arjaan/32/5754_2.png) [@Arjaan](https://forum.rasa.com/u/Arjaan)\
**Post date:** [January 31, 2020, 12:57am UTC](https://forum.rasa.com/t/not-creating-database-when-using-sqltrackerstore-with-docker/24140/3 "2020-01-31T00:57:32Z")

</div>

Hi @eugenelin89,

Great to hear you got it fixed.

Have you already looked at Rasa X, to help collect conversations that you can then annotate to create more training data?

I like to point you to this [Quick Installation using Docker-compose](https://rasa.com/docs/rasa-x/installation-and-setup/docker-compose-script/) for installing Rasa X.

This installs all the containers for both Rasa X and for Rasa Open Source, and it is using Postgresql as the database.

---

<div class="post-metadata">

**Author:** ![rasafan](https://avatars.discourse-cdn.com/v4/letter/r/b2d939/32.png) [@rasafan](https://forum.rasa.com/u/rasafan)\
**Post date:** [February 23, 2020, 1:46pm UTC](https://forum.rasa.com/t/not-creating-database-when-using-sqltrackerstore-with-docker/24140/4 "2020-02-23T13:46:33Z")

</div>

Thanks @eugenelin89 , this helped me.

Did you ever had my issue?

> [@PostgreSQL error "type object got multiple values for keyword argument 'host'"](http://forum.rasa.com/t/postgresql-error-type-object-got-multiple-values-for-keyword-argument-host/25167):
>
> Any idea why I’m getting this errror? I’ve followed: [Event Brokers](https://rasa.com/docs/rasa/api/event-brokers/#sql-event-broker) event\_broker: type: SQL host: 127.0.0.1 port: 5432 dialect: postgresql username: myuser password: mypassword db: mydatabase