# Rasa Tracker Store: Postgres SQL access from other machine

**URL:** <https://forum.rasa.com/t/rasa-tracker-store-postgres-sql-access-from-other-machine/27125>\
**Category:** \[Deprecated\] Rasa X Community Edition\
**Created:** [April 7, 2020, 5:59am UTC](https://forum.rasa.com/t/rasa-tracker-store-postgres-sql-access-from-other-machine/27125 "2020-04-07T05:59:26Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![syam](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@syam](https://forum.rasa.com/u/syam)\
**Post date:** [April 7, 2020, 5:59am UTC](https://forum.rasa.com/t/rasa-tracker-store-postgres-sql-access-from-other-machine/27125/1 "2020-04-07T05:59:26Z")

</div>

Hi,

I’ve deployed my Rasa X on a Linux server following closely Docker-Compose quick install guide [here](https://rasa.com/docs/rasa-x/installation-and-setup/docker-compose-script/)

Now, I want to access my conversation that is tracked in Postgres SQL from other machine outside the Linux server. Is there a guide to do that?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![stephens](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/stephens/32/1632_2.png) [@stephens](https://forum.rasa.com/u/stephens)\
**Post date:** [April 8, 2020, 9:08pm UTC](https://forum.rasa.com/t/rasa-tracker-store-postgres-sql-access-from-other-machine/27125/2 "2020-04-08T21:08:28Z")

</div>

Welcome Syamil,

Postgres is available at port 5432. To enable access, open the port in the `docker-compose.override.yml`. You may need to create this file (you can do this directly in the `docker-compose.yml` but the override file is recommended):

```auto
version: "3.4"

services:
  postgres:
    ports:
      - "5432:5432"

```

Restart with `docker-compose restart` and you should be able to hit the Postgres server at 5432.

You can also setup the server to send you a copy of all of the conversations via the RabbitMQ event broker. To do that you would replace the ` queue: ${RABBITMQ_QUEUE}` line in the `endpoints.yml` to:

```auto
   queues:
     - ${RABBITMQ_QUEUE}
     - my_rasa_log

```

You can now get a copy of the tracker events as they happen by reading your own `my_rasa_log` message queue from rabbit.

---

<div class="post-metadata">

**Author:** ![Papa](https://avatars.discourse-cdn.com/v4/letter/p/9d8465/32.png) [@Papa](https://forum.rasa.com/u/Papa)\
**Post date:** [August 16, 2021, 10:00am UTC](https://forum.rasa.com/t/rasa-tracker-store-postgres-sql-access-from-other-machine/27125/3 "2021-08-16T10:00:49Z")

</div>

Hi @stephens, please help me, i want to connect to my postgres daba to extract all my conversation data. Can you give me the command that i can use to do it. I really need your help. thank you in advance. I have installed rasa using docker-compose installation.

---

<div class="post-metadata">

**Author:** ![stephens](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/stephens/32/1632_2.png) [@stephens](https://forum.rasa.com/u/stephens)\
**Post date:** [August 16, 2021, 4:09pm UTC](https://forum.rasa.com/t/rasa-tracker-store-postgres-sql-access-from-other-machine/27125/4 "2021-08-16T16:09:37Z")

</div>

Try the `rasa export` command described [here](https://rasa.com/docs/rasa/command-line-interface/#rasa-export)

---

<div class="post-metadata">

**Author:** ![Papa](https://avatars.discourse-cdn.com/v4/letter/p/9d8465/32.png) [@Papa](https://forum.rasa.com/u/Papa)\
**Post date:** [August 17, 2021, 3:35pm UTC](https://forum.rasa.com/t/rasa-tracker-store-postgres-sql-access-from-other-machine/27125/5 "2021-08-17T15:35:19Z")

</div>

Thank you @stephens for replaying.

---

<div class="post-metadata">

**Author:** ![nik202](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/nik202/32/16098_2.png) [@nik202](https://forum.rasa.com/u/nik202)\
**Post date:** [August 17, 2021, 3:38pm UTC](https://forum.rasa.com/t/rasa-tracker-store-postgres-sql-access-from-other-machine/27125/6 "2021-08-17T15:38:27Z")

</div>

@Papa are you able to solve this? If I get you right, you want to connect a Postgres Database to docker compose installation? Or you just want to store the bot/user conversation in database?

---

<div class="post-metadata">

**Author:** ![Papa](https://avatars.discourse-cdn.com/v4/letter/p/9d8465/32.png) [@Papa](https://forum.rasa.com/u/Papa)\
**Post date:** [August 18, 2021, 12:24pm UTC](https://forum.rasa.com/t/rasa-tracker-store-postgres-sql-access-from-other-machine/27125/7 "2021-08-18T12:24:50Z")

</div>

@nik i am now able to connect to database but i also want to extract my conversations data into csv format. for now i am not able for the last one. If you know how to do this please help me. thank you !
