# Configuring Postgresql **URL:** \ **Category:** Rasa Open Source\ **Created:** [April 9, 2022, 3:51pm UTC](https://forum.rasa.com/t/configuring-postgresql/52502 "2022-04-09T15:51:54Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Vedha27](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/vedha27/32/15355_2.png) [@Vedha27](https://forum.rasa.com/u/Vedha27)\ **Post date:** [April 9, 2022, 3:51pm UTC](https://forum.rasa.com/t/configuring-postgresql/52502/1 "2022-04-09T15:51:54Z")
![Capture 1.1](https://europe1.discourse-cdn.com/flex013/uploads/rasa/original/3X/0/b/0b6c1c1418ff62e86f40d9809a72d24597b6062c.png) ![Capture 1](https://europe1.discourse-cdn.com/flex013/uploads/rasa/original/3X/c/f/cf95a183c8ca843bb8a13c2f910a0e4d8447f1d5.png) Can’t able to configure postgresql database in RASA open source. How to configure a database. please someone elaborate with steps. Thank you. ---
**Author:** ![itsjhonny](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/itsjhonny/32/20201_2.png) [@itsjhonny](https://forum.rasa.com/u/itsjhonny)\ **Post date:** [April 9, 2022, 7:05pm UTC](https://forum.rasa.com/t/configuring-postgresql/52502/2 "2022-04-09T19:05:31Z")
hi 😃You can try this in your endpoint.yml? ```auto tracker_store: type: SQL dialect: "postgresql" url: "host to database server" db: "name of database" username: "user to login" password: "123" ``` ---
**Author:** ![Vedha27](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/vedha27/32/15355_2.png) [@Vedha27](https://forum.rasa.com/u/Vedha27)\ **Post date:** [April 10, 2022, 3:57am UTC](https://forum.rasa.com/t/configuring-postgresql/52502/3 "2022-04-10T03:57:03Z")
![Capture 2](https://europe1.discourse-cdn.com/flex013/uploads/rasa/original/3X/0/6/063b9e48a0d6eac2334c1c1d32e16c42afde950a.png)I have tried the commands in endpoint. The server has been up but it showing the following error. Please look into it. Thank you ---
**Author:** ![itsjhonny](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/itsjhonny/32/20201_2.png) [@itsjhonny](https://forum.rasa.com/u/itsjhonny)\ **Post date:** [April 10, 2022, 4:45am UTC](https://forum.rasa.com/t/configuring-postgresql/52502/4 "2022-04-10T04:45:42Z")
Did you remove this parte? ```auto query: driver: my-driver ``` ---
**Author:** ![Vedha27](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/vedha27/32/15355_2.png) [@Vedha27](https://forum.rasa.com/u/Vedha27)\ **Post date:** [April 10, 2022, 5:08am UTC](https://forum.rasa.com/t/configuring-postgresql/52502/5 "2022-04-10T05:08:09Z")
![Capture 2](https://europe1.discourse-cdn.com/flex013/uploads/rasa/original/3X/1/2/127b0ef3fdc1bb35df97cd18b5c84e8a4a600657.png)I have removed the driver part but still can’t able to start the server. What I am missing? I have attached the screenshot, pls look into it. Thank You. ---
**Author:** ![itsjhonny](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/itsjhonny/32/20201_2.png) [@itsjhonny](https://forum.rasa.com/u/itsjhonny)\ **Post date:** [April 10, 2022, 2:21pm UTC](https://forum.rasa.com/t/configuring-postgresql/52502/6 "2022-04-10T14:21:16Z")
“Erro while attempting to bind address (‘0.0.0.0’,5005) …” If the port in your rasa is already active(in use) in another program, you should use another port or kill the active process to make the port free. To be honest, i think its running normally. This error is referencing the last try to up server 😃Check your database. Rasa create table named “events” if not… you can kill the program running in 5005 port with the command ```auto linux/mac: kill -9 $(lsof -t -i:5005) ``` i dont know how to do that in windows but i think you can fallow this steps: [spring boot - Windows Kill Process By PORT Number - Stack Overflow](https://stackoverflow.com/questions/55311842/windows-kill-process-by-port-number) Try again to up rasa after the stop service running 5005 port an alternative is try to run Rasa in a diferente port like ```auto rasa run -m models --enable-api -p 5006 --endpoints endpoints.yml ``` Rasa default port is 5005 but with parameter -p 5006, its start on 5006 port ---
**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:** [April 10, 2022, 6:49pm UTC](https://forum.rasa.com/t/configuring-postgresql/52502/7 "2022-04-10T18:49:02Z")
@Vedha27 try this thread solution hope it will work: [Rasa deployment to Google chat - #13 by nik202](http://forum.rasa.com/t/rasa-deployment-to-google-chat/47103/13) ---
**Author:** ![Vedha27](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/vedha27/32/15355_2.png) [@Vedha27](https://forum.rasa.com/u/Vedha27)\ **Post date:** [April 11, 2022, 1:52pm UTC](https://forum.rasa.com/t/configuring-postgresql/52502/8 "2022-04-11T13:52:39Z")
![Capture 2](https://europe1.discourse-cdn.com/flex013/uploads/rasa/original/3X/3/e/3e7896c4b8de79f9c935b4b964a84a645348e36e.png)Hey Thanks man your method has worked and the server has been up. But I can’t able to store any specific information like I have mentioned it in the screenshot. What should be done to store specific input of the user? ---
**Author:** ![Vedha27](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/vedha27/32/15355_2.png) [@Vedha27](https://forum.rasa.com/u/Vedha27)\ **Post date:** [April 11, 2022, 1:54pm UTC](https://forum.rasa.com/t/configuring-postgresql/52502/9 "2022-04-11T13:54:40Z")
Yeah man, It works but I can’t able to store specific input of any user messages. How can I save specific user Input. ---
**Author:** ![itsjhonny](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/itsjhonny/32/20201_2.png) [@itsjhonny](https://forum.rasa.com/u/itsjhonny)\ **Post date:** [April 11, 2022, 2:42pm UTC](https://forum.rasa.com/t/configuring-postgresql/52502/10 "2022-04-11T14:42:11Z")
Nice! 😃 In this case, i think you need to create a custom action to make database insert > **[Default Actions](https://rasa.com/docs/rasa/default-actions/)** look this topic, maybe can help you 😊 > [@Storing the conversation as columns in database](http://forum.rasa.com/t/storing-the-conversation-as-columns-in-database/23770): > > Hi , I need help on below scenario, User : I am sick Chat bot : Please tell the problems you are facing… (\*utter\_asksymptoms) User : I am having headache since yesterday so i need to extract the entities from the above user response and store it in as separtae columns value in sql db table pls help on how to do this ---
**Author:** ![Vedha27](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/vedha27/32/15355_2.png) [@Vedha27](https://forum.rasa.com/u/Vedha27)\ **Post date:** [April 13, 2022, 6:01am UTC](https://forum.rasa.com/t/configuring-postgresql/52502/11 "2022-04-13T06:01:02Z")
Thanks man. I am looking into it. Will update you when I get any results and also Please help me if I get any error 🙂