(Postgres) the most powerful, open source object-relational database
system, which runs on all major operating system and fully ACID
compliant, is now heavily used by Government and Industries. A
vast majority of enterprise applications developed by the Government of
Kerala, including the much appreciated KSEB relies on Postgres. A number
of cases are reported on plans for migration to Postgres as a major
initiative based on the recent Open Source policies of central and state
governments. This requires a major capacity building efforts on
Postgres within various departments of government.
mandated to ensure appropriate capacity building and ecosystem
mentoring in open source technologies to support the major initiatives
of the Government of Kerala is organizing a five day intensive workshop
on Postgres for government employees and startups.
Call for Nominations & Selection process
all government departments to nominate one or two persons (Database
administrators, systems administrators, or developers with working
knowledge of database usage) as per the prerequisite given below:
have a working knowledge of SQL. Using the command line interface to a
Linux system and some basic UNIX shell programming experience is needed
to complete all of the replication workshop exercises.
nominated candidates shall undergo a pre-work / evaluation (based on
database skills) on 9th November. The final selection for workshop shall
be based on the performance in this evaluation.
Finally selected candidates shall undergo the workshop at ICFOSS premises from 13th till 17th, November, 2017.
shall undergo an evaluation on 17th, November, 2017 and successful
candidates shall receive a certificate on Postgres Immersion Level I,
jointly certified by ICFOSS and 2nd Quadrant. while others will only
receive a participation certificate.
Introduction to PostgreSQL 9 Database Administration
Connecting & Troubleshooting
PgAdmin III Overview
Understanding Database Object Types
Permissions & Security
MVCC and VACUUM
Data Migration & Test Environments
Help & Support
Advanced Development & Performance Summary
Server Architecture & Caching
MVCC, VACUUM and HOT
Locking & Concurrency
Database design alternatives
Advanced Development Summary
Workload Analysis, Benchmarking and Profiling
SQL Performance Tips & Tricks
PostgreSQL 9 Replication & Recovery Concepts
pg_dump and restore options
PITR Backup and Recovery
High Availability options
Managing clusters using repmgr
File based Log Shipping
Introduction to Slony & Londiste
Sharding and Scale Out
Participants must have a working knowledge of SQL. Using the
command line interface to a Linux system and some basic UNIX shell
programming experience is needed to complete all of the replication
Who should attend
Database administrators, systems administrators, or developers with working knowledge of database usage.