PostgreSQL Database Administration Certified Associate V9 SC-PSQLDA9

PostgreSQL Database Administration Certified Associate V9 SC-PSQLDA9

The PostgreSQL 9 Database Administration Certified Associate certification validates a range of skills and competencies specific to the PostgreSQL 9 version. Based on the provided syllabus, the specific skills validated include:

1. Basic Knowledge of PostgreSQL 9:
   • Understanding the fundamental features of PostgreSQL 9, including its robustness, security, ease of use, extensibility, performance, concurrency, and scalability.
   • Initial connection and configuration of the PostgreSQL 9 server.
   • Enabling access for network and remote users.
   • Using graphical administration tools and the psql query and scripting tool.
2. Exploring and Monitoring the Database:
   • Identifying and locating server files and logs in PostgreSQL 9.
   • Evaluating the server version and uptime.
   • Enumerating and assessing databases and their extensions on the PostgreSQL 9 server.
   • Quickly estimating the number of rows in a table using functions specific to PostgreSQL 9.
   • Understanding object dependencies within the database.
3. Installation and Configuration:
   • Installing modules from PGXN, manual packages, and source code specifically for PostgreSQL 9.
   • Using and managing installed extensions in PostgreSQL 9.
4. Server Control:
   • Starting and stopping the PostgreSQL 9 server safely and quickly.
   • Reloading configuration files and restarting the server efficiently.
   • Controlling connections and user sessions, including preventing new connections and restricting users to one session each.
   • Designing and managing multitenancy schemas using PostgreSQL 9 features.
   • Running multiple servers on one system and setting up a connection pool.
5. Database Administration:
   • Managing tablespaces, including adding and removing tablespaces, and optimizing tablespace-level tuning for PostgreSQL 9.
   • Moving objects between tablespaces and accessing objects in other PostgreSQL and foreign databases.
   • Creating and managing updatable views and materialized views specific to PostgreSQL 9.
6. Backup and Recovery:
   • Planning and executing logical and physical backups for PostgreSQL 9.
   • Implementing recovery strategies, including point-in-time recovery and recovery of dropped or damaged tables and databases.
   • Improving the performance of backup and recovery operations.
   • Using advanced tools like Barman for hot physical backups and recovery in PostgreSQL 9.

These skills ensure that the certification holder has a solid and practical understanding of PostgreSQL 9 database administration, including installation, configuration, monitoring, control, optimization, backup, and recovery of databases specific to PostgreSQL version 9.