How to download install configure PostgreSQL 16 and pgadmin on Windows Server 2022 | 2024 updated

hello guys in this video we will see how to download and install postal 16 on Windows Server 2022 open browser go to post SQL official website that is pol. click on download then select the windows now click on download the installer see because we don't have download here so if you click on here it will redirect to EDB website see Enterprise DV Edition so the latest proc equal is 16.3 so for Windows you have to click on this drop down button so click on it wait download will be started here see download has been started and its size is 365 megabytes wait until this download completes say CPD see download is completed you can't show in folder or open folder maximize it go to downloads see here we have the poess equal 16.3 Windows x86 exe file double click on it to install it click on next see this will be the location to install the poster equal 16 if you want to change you have to click on this browse button and change otherwise you are okay with that one click on next we have to select the components like poster SQL it is the default one we must select PG admin stack Builder and command line tools so I don't want install stack builder then click on next see this will be the data directory location you want to change you have to click on this brows button otherwise click on next then provide the password for super user that is post cive you have to remember this user and password then click on next see the default port for post sare is 5432 if you want to change you have to change here but for single standal okay so click on next local settings I'm go I'm going with the default one that is server settings then click on next see this is the summary of the poess equal pre-installation click on next if you are okay with all the settings then click on next otherwise if you want to change go back by clicking on back I'm okay with the settings then click on next now click on next to start the installation click on it see installation has been started see installation has been completed click on finish now if we click on start button see h we have the poster equal 16 folder we click on this drop down we have the psql shell click on it see Server is Local Host hit enter database we have the post enter same username as post then provide the password that we have given and hit enter let us verify list of the databases see here we have the three default databases comes with post SQL installation that is post template Z and template one you want to verify the ver of the postal server give the select version and put semicolon at the end of the statement and hit enter see we have install postal 16.3 you want to create database run the command create database AR schools let us verify again back SL L see new database AR schools is added you want to switch to this new database and create some tables use the back/ C and provide the database name then hit enter see now you are now connected to database AR schools as user first CL let us create a table we have successfully created give the back SL DT see we have the table student let us verify the data in this table it will give the Zero Records or zero rows see Zero r that so let us insert some data into this table insert into student set one more row just give the arrow to get the previous command insert one more row but this time we are giving the same s number it will throw error see un constraint violation error so we have to give the unique number unique value for this s number other than the existing data in the table and hit enter see we have inserted successfully let us insert let us let us check the data in the table see we have three rows you want to see list of users give this SL and see we have only one user that is post which is the super user let us create a user create user James with password see the password is James at the 123 not the quotations hit enter now verify again /d now if you want to connect psql from the command PRP if you run the psql it will throw error see BSL is not is not recognized as an internal or external command so for to avoid that one go to the installation directory program files process equal 16 bin copy this part then this PC right click properties then Advanced system settings then environment variables here in path edit click on new paste it hit enter click on Okay click on okay close this one now close this CMD now open again CMD now type psql see now it is asking us to provide the password okay before it was throwing error so to connect post equal from the command from we have to use hyph psql hyphen U then username post address then hyphen P this typo so you iph Local Host then hit enter Then provide the password of post user see we have successfully connected let us verify table databases okay this is the way to connect psql or post SQL from the command PR okay you want to restart poster SQL service go to services. MSC let me maximize press P see here we have the poess equal 16 see the service status is running if you want to stop right click on it stop or click on this stop button select the service and click on stop or click on this stop link or click on the stop button okay all three options are same so let us stop it now try to open psql shell click on it provide the password see it won't ask us the password because it is stopped see press Q to quit now start it again right click and click on start now we are able to open the psql shell click on psql shell see now it is asking password okay next one is open PG admin PG admin is the go tool for the poster SQL click on it click on PG admin 4 see this is the PG admin console if you want to add server you have to click on add new server or right click on servers then register then select the server see provide the name win22 pg16 name can be anything then here provide the connection Lo see post SQL is installed on local PC so I'm giving Local Host then port number 5432 maintenance database post address username also post address then provide the password not only username po we can give the new user also then click on Save see here expand it databases see new database is there you want to create database right click on databases and select the database then provide the name for the database test click on Save see new database is added even if you want to create database from the query tool right click on any database select the query tool create database OS Scopes admin select it and click on this execute button see new database is created right click on databases and refresh we will be able to see see new database is added even if you go to the psq Shell give the backlash shell see new database after school admin is added test also there okay so in this video we have seen how to download and install post SQL 16 then we have seen how to connect post SQL from the PG admin on Windows Server 2022 for more pql or Windows videos please subscribe my channel thank you

Channel: r2schools

Views: 134

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 Complete Tutorials, PostgreSQL download, Install PostgreSQL 16 on Windows Server, Install PostgreSQL 16 in Windows Server 2022, PostgreSQL 16.3

Id: xIMLebjf1nI

Length: 10min 58sec (658 seconds)

Published: Thu May 30 2024