PostgressPro: Next Generation of Servers
Be a professional server/database developer using the new generation of servers
Databases,PostgressPro,Development,Data Science
Lectures -5
Duration -1 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
If you are a database developer and you put performance as goal to achieve with your DB design...then using PosgressPro is your excellent tool.
In this course we will learn all about the PostgressPro :
How many versions of the PostgressPro, and main differences between these versions.
- Usage benefits.
- Structure & structure components.
- Syntax to install.
- How to run the PosgressPro server after installation.
- How to create databases.
- How to create users .
And how to do some configuration like setting the firewall , setting the server config file postgresql.conf , and how to connect users to the server using the pg_hba.conf file.
We will highlight which aspects that will perform better and easier through using the PostgressPro in comparison with the basic Postgresql server that we used to use in previous years.
One of the main features that will perform better is the backup,restore and incremental backup of the data , this will be achieved through the use of the pg_probackup utility that is designed to run with the PostgressPro.
Monitoring the server activity is easier now with PostgressPro through the use of pg_activity utility , where developer can spot the deadlocks activities that slows the performance.
Logging reports is more detailed in PostgresPro through the use of pgbadger utility.
Goals
- what is PostgresPro.
- what benefits of using PostgresPro.
- how to install, run and create databases with PostgresPro.
- how to configure firewall, netplan, server file , client file and how to create sudo users.
Prerequisites
- You will learn all about PostgressPro. no prior knowledge required
![PostgressPro: Next Generation of Servers PostgressPro: Next Generation of Servers](https://d3mxt5v3yxgcsr.cloudfront.net/courses/14510/course_14510_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
PostgresPro
5 Lectures
-
Introduction 09:24 09:24
-
PostgressPro installation part 1 13:27 13:27
-
PostgressPro installation part 2 10:26 10:26
-
PostgressPro configuration 32:51 32:51
-
Create User 15:25 15:25
Instructor Details
![Mohammed Al Saadi](https://www.tutorialspoint.com/assets/profiles/607269/profile/200_1638027-1677222902.jpeg)
Mohammed Al Saadi
I'm focused mainly on :
1- Postgresql database : Installation from a customized source code & encryption of the DB cluster with data-at-rest encryption .
2- Security of data & connections : the database encryption , SSL Certificates(ROOT,Intermediate,trust-chain, Server & Client) & also creating SSLSockets for both the server & the client using customized provider such as Bouncy Castle with FIPS mode.
3- GUI building using JavaFX & Jfoinex .
4- The Ubuntu Server both installation & configuration (creating users,firewal, netplan networking).
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)