Postgress Pro .. Next Generation Of Servers

What you'll learn
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
Requirements
you will learn all about PostgressPro . no prior knowledge required
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.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 PostgressPro installation part 1
Lecture 3 PostgressPro installation part 2
Lecture 4 PostgressPro configuration
Lecture 5 PostgressPro create user
Postgress database developers


Homepage