Not creating database when using SQLTrackerStore with Docker

New to Rasa, followed instruction in 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

Solved by adding the following to endpoints.yml in the tracker_store section:
login_db: postgres

1 Like

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 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.

Thanks @eugenelin89 , this helped me.

Did you ever had my issue?