- I'm running DSS in VirtualBox.
- I'm running PostgreSQL in WSL2 (Ubuntu for Windows).
I was guiding myself to learn to make a connection to postgresql with this tutorial:
Specifically, I did this part from the tutorial exactly as explained:
psql -h localhost
CREATE DATABASE dku;
CREATE SCHEMA dku_churn;
CREATE USER matthieu WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_churn TO matthieu;
CREATE SCHEMA dku_tshirt;
CREATE USER dku_tshirt_admin WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_tshirt TO dku_tshirt_admin;
And I verified that the database and users were created, however still an error appears when I try to make the connection (image attached) in Dataiku.
Do I need to modify firewall rules?
I checked and both Ubuntu (WSL2) and VirtualBox use 127.0.0.1, but I'm not sure if I understood right that part.
Operating system used: Windows