0

enter image description here i added screenshot as one is in wsl and one in window terminal as both have same commands but one(WSL) has 8 schemas and the othe one(window) has 6

My project runs on WSL (Windows Subsystem for Linux), and I have PostgreSQL installed on Windows. I can successfully access the database data when I conduct migrations using the WSL console. However, the tables and schemas are not displayed when I attempt to access the same database using pgAdmin4 on Windows. The problem still exists even after I changed listen_addresses = '*' in the PostgreSQL.conf configuration file to permit connections from any IP address. Actions I've Done:

  1. On Windows, PostgreSQL was installed.

  2. In the postgresql.conf file,

    listen_addresses = '*'

was configured.

  1. The pg_hba.conf file was modified to let connections from any IP:

    host all all 10.255.255.0/24 md5

    host all all 0.0.0.0/0 md5

  2. restart the PostgreSQL service after these changes.

  3. verified using psql to confirm that the database could be accessed via the WSL interface.

0 Answers0