PostgreSQL Administration
About this course
PostgreSQL, geliştiricilerin uygulama oluşturmalarına, yöneticilerin ise veri bütünlüğünü korumalarını ve hatalara karşı dayanıklı ortamlar oluşturmalarına yardımcı olan birçok özellikle birlikte gelir ve veri seti ne kadar küçük ya da büyük olursa olsun verilerinizi yönetmenize yardımcı olur
OUTLINE
Installing PostgreSQL Server and Client
Comparison of installation methods
Demonstration of installation
Administration Tools and Options
psql options
pg_env.sh
Configuring a PostgreSQL Cluster
Review components of a PostgreSQL cluster
Difference between Oracle & Postgres
What is Oracle
What is PostgreSQL
Comparison between Oracle & PostgreSQL
Total Cost of OwnerShip
Support
Productivity
Safety
Scalability
Updates
Handling Large Data Volumes
SQL in PostgreSQL
DDL
DML
Running queries in psql
PostgreSQL data types
Creating and using views
Cluster Security
Enabling remote connections to cluster
Host-based authentication (pg_hba.conf)
User Security
Creating users
Using and assigning user roles
User authentication
Backup and Recovery Methods
Selecting an effective backup approach
Continuous Archiving and Point-in-Time Recovery (PITR)
Setting up WAL archiving
Running a base backup
Recovery from a continuous archive
PostgreSQL Optimization
VACUUM
EXPLAIN
High Availability Configuration and Operation
Setting up streaming replication
Master-Standby replication
Triggering failover
Logical replication