How to install PostgreSQL (latest) without Admin Rights on Windows 11 OS

How to install PostgreSQL (latest) without Admin Rights on Windows 11 OS

In this tutorial we will see how to Install and Set up PostgreSQL on Windows for a normal user without Admin Privileges. Most of the IT corporations doesn't grant admin privileges to install software. But being a software engineer, we would always like to explore new technologies. Admin privileges should not become a barrier to install new tech stack or a software package and thus hamper the limitation to explore it. So let's see how to install PostgreSQL database without actually needing admin privileges.

This approach works for both Windows 10 & Windows 11 operating systems.

Contents:

00:00 Install PostgreSQL without admin rights
01:36 Add PostgreSQL binaries to the user Environment Variables
02:50 Initialize a PostgreSQL database server
03:49 Start a PostgreSQL database server from command prompt
04:15 Connect to a PostgreSQL server using pgAdmin 4
05:46 Create a database using pgAdmin4
06:16 Create a table using pgAdmin4
06:45 Stop or restart the PostgreSQL database server from command prompt

Resources:

#postgresql #pgadmin4 #windows11installation
------------------------------------------------------------------------------------------------

(っ◔◡◔)っ Share this video with your friends and colleagues and let them know you are up to date with latest tech-trends

Thanks 🙏

Follow us to keep updated with latest trends in Tech:

[victorganguly]

Really helpful Sir . Many many thanks for this tutorial . It is really helpful . Postgres works like a charm . 🙂👍👌✌👏

[helen]

Thank you so much!! Spent an entire afternoon searching for a solution and yours is the easiest and fastest one!!

[janipashasyed]

Server started but I am not seeing bin folder in pgadmin 4 folder, can you please guide me

[GabrielCaetanoMello]

i´m not able to change the env variables. Is that any workaround?

[jingchun]

After I did everything as you told, I enter psql -V in command prompt. it says 'psql' is not recognized as an internal or external command.