Check your SQL setup on Windows

Four tools installed. One page to check all of them, and the fixes for the six most common problems.

Jo video mein bola, yahan nukte mein likha hai.
What I said in the video, written here as key points.

▶ Watch the video

Open in Present mode · Setup overview · Try the playground

Windows › Manual › Verify

Check everything together

psqlPostgreSQL

📝

codeVS Code

🌿

gitGit

🖥️

pgAdmin 4connects

Ek baar sab check kar lo. One check for all of it.

You installed four things. This page checks them all, together, in one Command Prompt window.

Step 1

Three commands

Command Prompt– □ ×

C:\> psql --version psql (PostgreSQL) <version> C:\> code --version 1.x.x C:\> git --version git version 2.x

Three version numbers. If any is missing, open a new window and try again.

Open a new Command Prompt and run:

psql --version
code --version
git --version

All three should print a version number. If one says "is not recognized", see the problems table below.

Step 2

Connect to your database

Command Prompt– □ ×

C:\> psql -U postgres Password for user postgres: postgres=# postgres=# \q

See postgres=#? You are connected.

Type psql -U postgres, enter your password, and look for the postgres=# prompt. Type \q to leave. Then open pgAdmin 4 from the Start menu and check that your server opens and shows databases.

If something goes wrong

All the fixes

`psql` is not recognized	Add `C:\Program Files\PostgreSQL\<version>\bin` to PATH, or reinstall with Command Line Tools ticked.
Forgot postgres password	pgAdmin 4, right-click the server, Properties, change it.
PostgreSQL service stopped	Services.msc, find postgresql, right-click, Start.
`code` is not recognized	Reinstall VS Code with Add to PATH ticked.
`git` is not recognized	Reinstall Git with Git from the command line selected.
pgAdmin connection error	Service must be running. Use `localhost` and port `5432`.

Tip: reboot your PC if any command is not recognized. Ghabrana nahi.

psql is not recognized: add C:\Program Files\PostgreSQL\<version>\bin to PATH, or reinstall with Command Line Tools ticked.
Forgot postgres password: pgAdmin 4, right-click the server, Properties, change it.
PostgreSQL service stopped: Services.msc, find postgresql, right-click, Start.
code is not recognized: reinstall VS Code with Add to PATH ticked.
git is not recognized: reinstall Git with Git from the command line selected.
pgAdmin connection error: the service must be running. Use localhost and port 5432.

Tip: reboot your PC if any command is not recognized.

Your turn

Everything green?

sql.theshiraverse.com

Tell me in the comments. Milte hain agli video mein. Next: load the RetailMart database.

Free SQL course and the Setup page, which maps every step. Join the WhatsApp Community, the Channel or Discord.