How to Install PostgreSQL on Ubuntu WSL & Connect with pgAdmin | Step-by-Step Guide

[@sriwworldofcoding]

If u are still facing error while connecting to Postgres database using pgAdmin : Unable to connect to server. connection failed: FATAL: password authentication failed for user "postgres" connection to server at "127.0.0.1", port 5432 failed: FATAL: password authentication failed for user "postgres" 1. Open WSL and switch to postgres user using command : sudo -i -u postgres 2. Open psql shell using : psql 3.Update the password of postgres user using: \password postgres 4. Enter the password as postgres and retype the same password Now u will be able to connect Postgres database using pgAdmin

[@lionelmockel3935]

than you, it seems to work!

[@sriwworldofcoding]

Please support by subscribing to my channel🙏

[@lionelmockel3935]

​@@sriwworldofcodingdone!

[@maximeaubry2613]

unfortunately, i still have this error

[@sriwworldofcoding]

Can u please tell what error u are facing

[@xiztspike81]

Thanks son much!, love you 🤗♥

[@sriwworldofcoding]

Please support by subscribing to my channel

[@melom806]

Doesn't work. I am only able to see postgre databases that are present in Windows and not in WSL.

[@sriwworldofcoding]

Hi.. May I know what error/issue u are facing exactly. Postgres is installed in wsl... Pgadmin is installed in windows to connect to postgres database

[@blessedepressed]

Спасибо брат помог

[@sriwworldofcoding]

Please support by subscribing to my channel 🙏🙏

[@lionelmockel3935]

Unable to connect to server: cnnection failed: connection to server at 127.0.0.1, port 5432 failed: password authentification failed for user "postgres" .... I think it has a problem with my username but how can I know what would be my username? Thank you

[@sriwworldofcoding]

Kindly follow the steps to setup connection to pgadmin in case of error : 1. Open WSL and switch to postgres user using command : sudo -i -u postgres 2. Open psql shell using : psql 3.Update the password of postgres user using: \password postgres 4. Enter the password as postgres and retype the same password Now u will be able to connect Postgres database using pgAdmin

[@blessedepressed]

hi bro, pls help me, evertime when i try to create db, i get endless loading, why???? PLS HELP ME(im sub:)

[@sriwworldofcoding]

Can u please elaborate what your actual error is.... Are u creating db using pgadmin Or postgres shell...

[@blessedepressed]

@@sriwworldofcoding Im press create db in pgadmin, insert db name and get endless loading, thx u for help!

[@Android-ff2ie]

@@blessedepressed привет, решил проблему?

[@andrewblaze6930]

psql server is not runnign actually in my wsl. and also im seeing some permission issues too "andrew@ANDREW-BLAZE:~$ sudo -u postgres psql -c 'SHOW config_file' could not change directory to "/home/andrew": Permission denied config_file ----------------------------------------- /etc/postgresql/14/main/postgresql.conf (1 row) ". finally in the pg admin it is saying unable to connect to the 127...... 5432.... password authentication failed can u help me?

[@sriwworldofcoding]

U can start running psql using command : sudo systemctl start postgresql default password to connect with postgresql is "postgres" itself. Please let me know if u are still facing the issue .

[@sriwworldofcoding]

Kindly follow the steps to setup connection to pgadmin in case of error : 1. Open WSL and switch to postgres user using command : sudo -i -u postgres 2. Open psql shell using : psql 3.Update the password of postgres user using: \password postgres 4. Enter the password as postgres and retype the same password Now u will be able to connect Postgres database using pgAdmin