How To Download And Install PostgreSQL 16 + pgAdmin 4 + pgAgent || Windows 2024 PostgreSQL

[Music] hello and welcome to my channel I Akram and you're watching knowledge 360 in this video I'll show you how to download and configure postgress SQL 16 on your system for this I'm using Windows OS as per your requirement you can also choose your OS so let's come to this uh download page I'll share this Link in the video description you can open it from there this is the official website from where we download the installer so the we can see that the latest version which is 16.2 for pogress SQL version is available now and we can download as for a requirement so since I I'm using Windows OS so I'll download for Windows OS so to save the time I have already already downloaded it so it is here of 360 to MB and now I'll start it okay right click and open now the installer is started also in this video I will show you how to you download the pz agent as well which is used for scheduling your jobs whatever jobs we are scheduling through postgress SQL it is done through PG agent so PG agent doesn't come by default with the post SQL we need to choose that so for that uh as of now for me I'll keep it as it is the default path but you can also change your path from here okay so for now I'll keep it as it is the default one and click on next also this is important step if uh you want to set up additional tools as I told I want to set up P agent as well because for my purpose I need that to okay so I'll leave all this selected now click on next I'll select I'll keep this path as it is the default PA now I'll keep I'll I'll set the password the password I usually set it is root r o t you can set as per your requirement or the password policy whatever it suggest good for you then next the port number you need to remember that uh which on which port number you want to install the server this is the postgress SQL Server when you uh try to access uh the postgress SQL database through API so you need to give other Port so by default for database it is 5432 in other case you can you have to change the port to 5433 or 54 31 something else other than this one otherwise you will have conflict okay I leave it as it 5432 now next and I'll leave it as default again next so this this is the summary page whatever I have uh did the configuration now I'll proceed to install it click on next and now the installer is ready it takes some time for uh installing to save the time I'll skip this installation process if you like my videos please don't forget to subscribe my channel to get the notifications for latest videos also if the videos are being helpful to you also like the video so that it reaches uh more audience in the YouTube so now here comes one important step see you can see here the stack Builder checkbox is checked that means I want that because I want to execute sorry install and uh download and install additional tools so I'll keep it as it is and then I'll click on finish it will open the stack Builder now for which Port I want to download and install those things I'll select my server postgressql 16 on port number 5432 I'll select that and then I'll click on next so the list of application will be available whatever the applications are okay so here are there now in addon and Tool and utility is we have this things and for now I want PG agent only so I'll check this one and in the database server these are the options available but as of now I don't need them in the database server if you see always the latest version gets installed okay through the installer but also if you want to install the previous versions like 15.6 14.11 like that Al you also you can do those things by clicking clicking on checkbox and those servers will also be downloaded okay and there are some other things also some registration things are there and uh special extensions are there and for web development also we have few things so out of all of those things I need only PG agent as I told in the beginning I need it for scheduling my any uh stored procedure call or function called whatever uh the things I do in Oracle what happens it comes with Oracle server itself we don't need to uh download any schedular uh explicitly but in po SQL we need to do that okay so in my upcoming programs or videos I need PG asent the schedular so for that I'll download that now I'll click on next so uh only this thing I'm downloading I'll change my download location I'll select postgress SQL here here I'll I'll download this file now click on next okay now I'll not skip the installation because I want to install with the server with this installer only also if I close this then I need to do explicitly here okay so I'll not do that I'll install with this only now I click on next okay the PG agent setup is ready here now I click on next then next I skipped this upgrade mode because I'm not upgrading I'm installing for the first time if you are upgrading like changing uh to new version then you can consider this one without removing the existing PG agent okay so this is the Local Host username is post gra the the default user of postgress database then comes the password rout that I have set for this port number and the server during installation of the postgress SQL Server then I click on next okay the password I can give here now it's ready to install this will not take much time it will be done immediately okay it seems it's done okay so this is done I'll click on okay now I'll click on finish and also finish now I'll come here and I search PG admin here is the PG admin for I'll open it bz admin tool is uh to access the database uh we can also have other tools like DB and other whatever tools are available in the market but uh the official tool is this one PG admin that comes with the installer itself we don't need to install this explicitly we can do but it's not required it comes with the installer only postgress SQL okay the PG admin has started now now I can connect to the server okay it comes with POS F uh it has pogress SQL 15 because I had already installed pogress SQL 15 in my system but for now I need poq 16 database only so the password that I had set I can click on okay okay so I have connected to the database and now I can perform any SQL query as you can see I can right like we know in postra SQL we don't need to write from Dual okay the time stamp is return and the pent that I had installed it is here as of now there is no job created and if we want to create job we can do this okay that will we'll see in the next video how to create PG agent jobs and also we'll see uh different kind of configurations that are required when we install POG SQL for the first time so subscribe my channel and like the video so that it can reach for more audience so let's meet in the next video thank you take care

Channel: Knowledge 360

Views: 789

Keywords: How To Download And Install PostgreSQL 16 pgAdmin 4 pgAgent Windows 2024, How To, 2024, Download PostgreSQL 16, Install PostgreSQL 16, Download pgAdmin 4, Install pgAdmin 4, Download, Install, PostgreSQL 16, pgAdmin 4, pgAgent, Windows, knowledge 360, akram sohail, postgres, install postgres, how to postgres, windows postgres, pgadmin, pgadmin 4, pgadmin postgres, postgresql database, install, database

Id: 7xzW6pseLko

Length: 9min 58sec (598 seconds)

Published: Sat Mar 02 2024