Postgress Pro .. next generation of servers
Learn all about PostgresPro, its benefits, installation, database creation, and configuration. Discover how it outperforms basic PostgreSQL, with features like backup, restore, incremental backup, server monitoring, and detailed logging. Perfect for Postgres database developers.
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
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.
Who this course is for:
- Postgress database developers
