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.

Open in Present mode · Setup overview · Try the playground

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

▶ Watch on YouTube

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: WARNING: Console code page (437) differs from Windows code page (1252) 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.

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.

Everything green?

sql.theshiraverse.com

Tell me in the comments. Milte hain agli video mein. Next: meet RetailMart, a quick overview of the database you will load.