top of page
25553.jpg
EÄŸitim ve Workshoplar
PostgreSQL EÄŸitimleri
1902.i039.011.P.m004.c30.cloud services isometric icons-08.jpg

PostgreSQL Administration (5 days)

  • Understand the PostgreSQL architecture

  • Installing PostgreSQL from source

  • Create databases

  •  Learn command line interface: psql

  • Understand backup and restore 

  • Create a hot standby database

  • Understand the optimizer, statistics and vacuum

  • Understand monitoring tools

  • Upgrades in PostgreSQL

postgresqlyoneticisi.gif

Monitoring PostgreSQL (2 days)

  • Database Statistics

  • The Statistics Collector

  • Database Statistic Tables

  • Operating System Process Monitoring

  • Current Sessions and Locks

  • Log Slow Running Queries

  • Disk Usage

oracledanisman.gif

Backup and Recovery  (3 days)

  • Backup Types

  • SQL Dump

  • Cluster Dump

  • Offline Copy Backup

  • Continuous Archiving

  • pg_basebackup

  • Point-In Time Recovery

  • pg_upgrade

sqlservervt.gif

Configuration PostgreSQL (3 days)

  • Setting PostgreSQL Parameters

  • Access Control

  • Connection Settings

  • Security and Authentication

  • Settings

  • Memory Settings

  • Query Planner Settings

  • WAL Settings

  • Log Management​

bottom of page