90. PostgreSQL DBA: How to download install and configure PostgreSQL 16 on Windows

hello guys in this video we will see how to download install and configure processing for latest version that is 16 on Windows operating system go to push the SQL official website that is positive sequel dot OS hit enter this is the official website for poster SQL also see here the message poster SQL 60 release on 14th September 2023 click on download then select the windows then you have to click on this download installer see we have the poster SQL version operating system types okay you can download from 9.3 to 16. this is this is the latest version so you have to click on this download button once we click done download button it automatically starts download if it won't starts downloading then you have to click on this click here in my case it has started downloading go to downloads see I have already downloaded the first SQL 16 so I'm canceling this one in your case wait until process equals 16 download completes now click on this post is equal Windows dot exe file if you receive user account control pop-up click on S C this is the setup wizard so click on next and this is the installation directory if you want to change you can click on this browse button then provide the path then click on next now we have to select the components first one is process equals or it is the default we have to select widget before front digital php4 you have to select stack Builder stack Builder is used to download and install additional tools like post yes and other tools command line tools it is going to install PG Dom PG based backup PG restore PG bench and other tools select all these check boxes and click on next this is the data directory if you want to change you can change otherwise click on next provide the password for postgres and also this is the super user you have to remember this password and the username is first place click on next C here we have to provide the port number the default code number is 5432 provide the port number as 5432 but in my case I have given y four three four because I have other versions installed so give 5 4 3 2 then click on next select the local settings I am going with the defaults then click on next see this is the pre-installation summary like installation directory server installation directory data directory port number first database super user and other tools information click on next click on install see we have successfully you start question SQL 16 version unmentors if you want to Launch stack Builder you have to check this checkbox otherwise uncheck it but keep the checkbox as this and click on finish then it will launch this stack Builder installation Setup Wizard select the database from the drop down click on next it is going to download applications see here we can select the applications suppose font install Cas then you have to click on next the same way database service you want to install any one of them how to select because but it is already installed so click on web development if you want to install Prime HTTP or anything you have to select one you have to click on next then you have to click on install wait it is going to connect to server run it will download and install see it is trying to connect to the server successfully downloaded click on next I click on next then click on next see you have successfully installed cost us you can close click on finish so we have successfully installed process equivalent First Years package now click on start then all applications then postness sequel see see we have the forces equal folder click on it expand this one then click on this tsql server name that is localhost database also first phase which is the default database comes with process equal installation it enter what is same provider password which we have given at the time of installation see we have successfully connected to postal SQL let's verify the version select what is it C because we start was just equals 16 are windows now and this post is equal from the PGM wait until the speech admin application opens this is the password for not for the database right click on servers right click on servers then select resistor and click on server server then provide name as poster SQL 16 name can be anything but in connection you have to provide the post name or IP address so I am giving local first then we have to provide support now but you guys have to give the same code again I am telling you the port numbers whatever you have given at the time of ministration the default vote is 543 so if you five four three two okay this is the database this is the username and provide the password for PCOS pick up save expand databases see I don't have any databases this is the default database run select version command click on this run button or press F1 from YouTube Let Me see we got the same output as here okay let me create a database just try click on databases then select creator select database I am giving database name and artists and this is the owner definition if you want provide template or tablespace information how to provide if you want Grant privileges you have to click on these labels at present I'm not going to Grant anything this is a script you can simply copy the script and execute just click on Save is successfully created right click on you can refresh C we have database created we can verify from here also by running the comments slash see new database is created we can also create database from here also okay okay database and database here I am giving database now test one two three put the semicolon until create database is successful by going to please admin right click on refresh see new database is created successfully let's see let's see how to start stop and restart process your service on Windows go to services.msc we have the process SQL service it is returning forget about these two I have the world order version does if you want to restart right click on click on restart if you want to stop you have to click on stop r sell the service you want to study how to click on this button you want to pass equal to so if you want to stop you go to click on this one in the same way you can think this hyperlinks so in this video we have seen how to download install and configure process equal 16 version on Windows operating system the process is same for Windows 10 Windows level or Windows servers for more physical server which is Please Subscribe my channel thank you

Channel: r2schools

Views: 5,885

Keywords: Download PostgreSQL for Windows, Download PostgreSQL 16 for Windows, PostgreSQL 16 Installation guide, PostgreSQL Installation guide, PostgreSQL 16 Installguide for Windows, PostgreSQL installation tutorial, PostgreSQL Install tutorial, PostgreSQL Tutorials, PostgreSQL Tutorials for beginners, PostgreSQL Tutorials for beginner, PostgreSQL Training Videos, PostgreSQL Complete Tutorials, PostgreSQL download, Install PostgreSQL 16 on Windows 10, Install PostgreSQL 16 in Windows 11

Id: 82o6HH3Qn_4

Length: 10min 17sec (617 seconds)

Published: Fri Sep 15 2023