Accessing PostgreSQL (on wsl2) from DBeaver (on Windows) fails: "Connection refused: connect"
What I'm trying is to use Postgres and access it from DBeaver.
- Postgres is installed into wsl2 (Ubuntu 20)
- DBeaver is installed into Windows 10
According to this doc, if you access an app running on Linuc from Windows, localhost can be used.
However...
Connection is refused with localhost. Also, I don't know what this message means: Connection refused: connect.
Does anyone see potential cause for this? Any advice will be appreciated.
Note:
- The password should be fine. When I use
psqlin wsl2 and type in the password,psqlis available with the password - I don't have Postgres on Windows' side. It exists only on wsl2
Solution
I found a solution by myself.
I just had to allow the TCP connection on wsl2(Ubuntu) and then restart postgres.
sudo ufw allow 5432/tcp
# You should see "Rules updated" and/or "Rules updated (v6)"
sudo service postgresql restart
I didn't change IPv4/IPv6 connections info. Here's what I see in pg_hba.conf:
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
- How to enforce uniqueness across two columns within the scope of a third?
- pg_dump and pg_restore across different major versions of PostgreSQL
- hasMany called with something that's not an instance of Sequelize.Model
- PostgreSQL unterminated quoted identifier
- Multi-row insert with pg-promise
- SQL getting the data by timestamp interval
- Insert inserted id to another table
- docker compose psql: error: FATAL: role "postgres" does not exist
- Counting business hours between timestamps
- "row is too big (...) maximum size 8160" when running "grant connect on database"
- How to cast type bytea to double precision
- Transform timestamp to local time for a given timezone during 'COPY .. TO ..'
- Better way than multiple SELECT statements?
- How to call a stored procedure(PostgreSQL) with Spring JPA?
- Why does 'now()'::timestamp return the current timestamp in PostgreSQL?
- Get TZ abbrev for given timestamp and TZ name
- Avoid checks for each row, replace query by function?
- Get average for "last month" only
- Select values in given sequential numbers
- Sum time differences across multiple timezones in PostgreSQL
- Unexpected results from SQL query with BETWEEN timestamps
- Disadvantages of using date_trunc
- Will changing column from timestamp to timestamptz lock the table?
- Subtract hours from the now() function
- Postgresql 8.4 update query syntax error in plpgsql function
- Return rows based on timestamp respective to their time zone
- time zone confusion in relational databases
- Default timestamp format and fractional seconds
- SQL in postgres convert datetime for recurring event to future datetime
- Query on a time range ignoring the date of timestamps