How to Install PostgreSQL 15 on Windows 10 [ 2023 Update ] Complete guide | pgAdmin 4
How to Install PostgreSQL 15 on Windows 10 [ 2023 Update ] Complete guide | pgAdmin 4
Hello Everyone! Today in this video I am going to step-by-step guide you on How to install PostgreSQL 15 for Relational DataBase Management System (RDBMS) on Windows 10. Windows (64-bit). Then we will install pgAdmin 4 for using PostgreSQL in a Graphical User Interface (GUI). You can also use PostgreSQL Command-line Interface if you wish.
The PostgreSQL installers created by EnterpriseDB are designed to make it quick and simple to install PostgreSQL on your computer. The installer provides: - A distribution-independent PostgreSQL installation. - The popular open-source PostgreSQL administration tool, pgAdmin. - The StackBuilder package manager (used to download and install drivers, tools, and applications to complement your PostgreSQL installation).
In my previous video, I’ve shown How to install Eclipse IDE on your Windows 10/11. Link: • How to install Eclipse IDE on Windows…
Geeky Script (\r@GeekyScript) is Computer Science - Educational Videos Creator 🎉 You can support by buying a coffee ☕️ here — https://www.buymeacoffee.com/geekyscript
✻ I really hope you find this video useful. ♥
✻ Please click on the CC button to read the subtitles of this video.
Now our main question is How to Install PostgreSQL \u0026 pgAdmin 4 on Windows 10? So let’s begin…
Step 1. First You need to download PostgreSQL. For that, just follow the following link. https://www.postgresql.org/download/w… This page will lead to the PostgreSQL download on Windows 10. So just click on download and it will start downloading automatically.
Step 2. After downloading just double-click on the installation file for installing Postgresql on your Windows 10 OS. 64 bit. In my video, I have shown you step by step on how to install Postgresql. Just follow that if you are facing any issues.
Step 3. Now after installing PostgreSQL on your Windows 10 OS, it’s time to launch our app pgAdmin 4 gui. Then you need to give the password. You should give the password that you have used during the installation of your PostgreSQL on your windows 10/11 64bit os.
Step 4. After your password is verified you should get to see the pgAdmin graphical user interface (GUI). So here just create a new database to check if everything is just working fine.
Step 5. After creating a new database now it’s time to create a new table where we will store data. So follow my video to know how to create a table on the PostgreSQL database.
So that’s all my friends! In my following videos, I’m looking forward to posting videos on how to connect your PostgreSQL with eclipse ide and how to run java applications by connecting with PostgreSQL. Thanks a lot once again for watching this video! Do Subscribe :)
Topics addressed in this tutorial: How To Download And Install PostgreSQL and pgAdmin On Windows 10 64 bit OS Install PostgreSQL on Windows 10 How to Install PostgreSQL and Get Started Install pgAdmin 4 on Windows 10 How to Install pgAdmin 4 and Get Started PostgreSQL installation windows 10
--------------------------------------------------------------------------- MY RELATED VIDEOS: ✻ All about Android Studio: • How to install Android Studio on Wind… ✻ All about PostgreSQL: • How to Install PostgreSQL \u0026 pgAdmin 4… ✻ All about MongoDB: • How to install MongoDB on Windows 10 … ✻ All about MySQL: • How to Install MySQL on Windows 10 [ … ✻ All about WordPress: • How to Install WordPress in Xampp (Lo… ✻ All about Java Spring: • Spring Framework | Spring setup in Ec… ✻ All about Maven: • Maven project in NetBeans [ 2021 Upda… ✻ All about eBook: • How to Create an Ebook for FREE
--------------------------------------------------------------------------- THANK YOU so much for watching! Please make sure to LIKE and SHARE the video and SUBSCRIBE to the channel for more such videos :)
--------------------------------------------------------------------------- CONNECT WITH ME ON: ✻ Website: https://geekyscript.com/ ✻ LinkedIn: https://www.linkedin.com/in/geekyscript/ ✻ Twitter: https://twitter.com/GeekyScript ✻ Email: [email protected] ✻ YouTube channel: / geekyscript --------------------------------------------------------------------------- Song: Jarico - Island Music promoted by #BackgroundMusicWithoutLimitations Watch: • Free Background Music For Youtube Vid… Free Download: https://bit.ly/3n3snwj ---------------------------------------------------------------------------
Content
0.18 -> hello everyone I will come here to my Channel
today I'm going to show you how to install Pro
4.92 -> skill on a Windows operating system so let's begin
now to install postgresql you need to First simply
12.48 -> go to favorite browser and indirect disc bar
you need to just simply search with post Gray
17.58 -> SQL download and hit enter and you will
be getting this www dot postgresql.org
26.4 -> as our first search result here you need to
just simply click on this download button
33.72 -> and you'll be getting this official site of
postgresql and depending upon what operating
38.64 -> system you use Linux Mac OS windows or you
know this operating system you should be
44.22 -> downloading your postgres SQL now here I am using
Windows so I'll simply click on these windows
51.42 -> and it will redirect you to this Windows installer
and here you can see that there are so many
57.18 -> versions available for postgres but uh version
15 is also released so which is not updated yet
63.42 -> it will be they're going to update very soon so
to download the 15th version you need to click
69.54 -> on this download the installer and it will going
to redirect to this page so here you can see that
76.38 -> all versions are available for download okay
and from here the latest version is 15 and you
82.44 -> can see these are all operating system so from
here I'm going to choose the windows so I'll
86.94 -> just simply click on this download button for
version 15. so I'll just simply click on that
92.58 -> and it will going to redirect to this EDB site
and it is going to start downloading our post case
98.58 -> SQL now since I have already downloaded it I just
simply cancel it and I'll just simply minimize my
103.92 -> browser and if I go to my download directory you
can see that latest version of prosecus SQL 15 is
109.8 -> rightly downloaded over here and the file size
is 313 MB okay so after downloading you need to
115.74 -> just simply double click on the installer foreign
administrative privileges just simply click on yes
124.14 -> and you can see that our postgres SQL installation
wizard is rightly opening okay so let's minimize
130.44 -> our download directory and this is our postgres
SQL installation wizard so just simply click on
137.04 -> next this is where the postgres installed
actually going to happen so they're going
143.46 -> to create this uh postgres SQL folder and the
version 15. so everything is fine just simply
149.4 -> keep this default and click on next so here
you can see that they also going to install
154.14 -> our postgres SQL Server which is like the main
thing and then they're also going to you know
158.76 -> install the GUI component which is our basically
PG admin 4 version 4 and they're also going to
166.02 -> install stack Builder and command line tools
everything is pretty much important I'm going
170.94 -> to show you some of these items so for that just
stay tuned uh to this video and click on next
179.64 -> so here is our data directory so in our you know
I have shown you that we're going to create this
184.68 -> version 15 folder so after that they're also going
to create this data folder so where all our data
190.32 -> going to be reside okay so keep this default
click on next and here you need to you know type
196.44 -> a password this is very important step to remember
this password you will need this every time while
202.56 -> logging in in your you know postgres SQL okay so
remember this password so you know just simply
208.62 -> type all that and just click on next and this is
our port number this is also very important 5432
215.22 -> is you know that default port number for postgres
SQL so this is also will need like when you will
221.82 -> try to communicate with your code to the back
end so you'll need this port okay to establish
227.46 -> the connection so this port number is also very
important okay so now just simply click on next
234.84 -> and in advance option you can choose
the locally for now I'll just simply
240.6 -> keep this default I later also you can do
not a big deal just simply click on next
247.02 -> and see it's almost ready to be installed just
simply click on next you added it to be installed
252.48 -> next and our installation has rightly began so
this installing postgres SQL will take some time
258.24 -> you know some minutes three to four minutes
I would say so after that I'll be coming back
263.28 -> yeah so we'll come back and now we can clearly
see that our postgres is almost installed and
270.48 -> it is asking that whether we'd like to you
know check this stack Builder and proceed
275.64 -> so you know you don't need stack Builder right
now it's going to install some drivers so I'll
281.28 -> just show you once so if you just simply check
this and click on finish you will see here like
286.62 -> you can install these drivers so for now
you can skip this part and just you know
292.14 -> simply click on cancel so that you know you
don't need a stack Builder right now so about
298.74 -> post case SQL is ready to install along
with our PG admin so I'll just simply
303.84 -> you know search here PG admin and you'll be
getting this PG admin 4 over here so let me
310.74 -> just simply click on that to you know launch
our postgres or when a PG admin GUI interface
321 -> and you can see that our you know PG admin
GUI interface is rightly open remember the
326.58 -> password you have given so you need to type
that same password and just simply click on
331.14 -> OK to you know get into our PG admin so let's
maximize it and this is basically the interface
337.86 -> of our PG admin so here is our server so
if you just simply click on this drop down
343.44 -> again it will ask for that password same password
so you need to retype that again and you can save
349.68 -> this password so that you don't need to you know
type that uh again and again so just simply click
354.78 -> on OK server is connected so you can see that
post guess 15 which is the latest version is
361.38 -> rightly there then our database is also there
so if you just simply expand our database you
367.32 -> can see they have already created a database
called postgres okay so here I am going to show
372.72 -> you how we can easily create a new database so
for that you need to just simply click on this
377.4 -> database and right click and create and database
so here let's give the database name as a new DB
386.04 -> like it's totally your wish you will be giving
your database name if you switch to you know SQL
392.1 -> tab you can see the code beneath it okay creation
of the database so let's switch to General tab so
400.56 -> you can just simply use this GUI interface
on creating the new DB just click on Save
408.12 -> and there you go our new DB is rightly
created over here so if you expand our schemas
415.44 -> you will be able to see like there are so many
things like Aggregates you know different things
420.84 -> and the main thing is it is table is there okay
so views are also there view is like little you
427.68 -> know high level for now let's stick to tables only
so here is our table if you expand it here you'll
435.48 -> be able to see all columns and all once a table
gets created so for that you can create table
441.3 -> by just simply right clicking and you can create
table from here as well but I am going to you know
445.98 -> show you how you can easily create scripts and all
so you need to you know click on the database then
452.28 -> right click and then you need to just simply
you know click on this create script over here
457.86 -> so once you create that it will going to you know
open a new tab over here and here is basically
463.02 -> our query section so here you can do everything
pretty much like I'll just simply hit a couple of
469.08 -> times enter and I can you know create our table
over here so I'll just simply type create table
476.76 -> persons let's say and I'll be simply
giving a couple of columns for now
485.4 -> person ID int and I'll be you know giving
a full name okay for now just demo purpose
499.98 -> 255 so here is our script here is our script for
creation creating of a table so just simply click
510.12 -> on this run button and there you go it has you
know rightly executed successfully so if you
516.48 -> go to table and if you refresh first this and
click on this drop down you can see that our
523.26 -> person stable rightly created so if you create
more tables it will going to show that you can
527.82 -> expand column also you can see that disk to column
we have created is rightly there okay and you can
533.76 -> do several things like you can insert data in the
table you can you know Fetch and can you can do
540.12 -> like pretty much everything like you you do in
you know SQL so you can do all that over here
546.48 -> in this query window okay so that's basically all
about this video friends thank you very much for
551.94 -> watching this video If you you know want more
videos on postgres SQL then please do drop a
557.1 -> comment in our comment sections I'll be happy
to make those videos so that's basically all
561.96 -> about this video friends thank you very much
for watching this video and God bless you all
![How to Install PostgreSQL 15 on Windows 10 [ 2023 Update ] Complete guide | pgAdmin 4](https://img.howtoclicks.com/vi_webp/0n41UTkOBb0/sddefault.webp)