Tutorials > Postgress Pro .. Next Generation Of Servers
Postgress Pro .. Next Generation Of ServersDate: 3 February 2023 | Posted by: voska89 |
![]() Published 2/2023 MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz Language: English | Size: 651.77 MB | Duration: 1h 22m Be a professional server/database developer using the new 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 DOWNLOAD LINK Links are Interchangeable - No Password - Single Extraction See full article |