1-0-1 Training on PostgreSQL Database Administration
This course is meant for advnaced level for PostgreSQL database Administration.
Prerequisites to perform the hands on and prepare for interview?
FREE PREVIEWAssignment on Prerequisites for the hands on course
About the Trainer Led Postgresql database Admin course
FREE PREVIEWecho command in linux
cat command in Linux with examples
Find command in Linux
grep command in Linux
vi editor in linux
telnet command in linux
chmod and chown in linux
sed command in linux
sudo command in linux
Monitor Log Files in Real Time: tail unix command
Basic Linux Commands to Check Hardware and System Info
Getting started : Install First PostgreSQL-16 on Ec2 Instance
How to recycle PostgreSQL service and when is it required ?
Launch RDS for postgesql 15 and connect via ec2 and pgadmin to postgresql
Launch Aurora -PostgeSQL 16 and connect via Ec2 and pgadmin to Aurora -PostgreSQL
Service account of PostgreSQL on an EC2 Instance
PostgreSQL.conf file in PostgreSQL ?
What is pg_hba.conf file ?
What is cluster in postgresql ?
Roles in PostgreSQL ?
Schema in PostgreSQL
Tablespaces in PostgreSQL
WAL Files in PostgreSQL?
Vacuuming Fundamentals
cluster table in postgresql
Troubleshooting issues with Vacumming in postgresql
How To Install PostgreSQL 16 on Ubuntu
How to cleanup wal files and replication slot in pg
Bloating in postgresql
Reindexing in postgresql
Password file in PostgreSQL
Install postgres 14 on Ec2 Ubuntu and connect with pgadmin running on your laptop
How to setup and troubleshoot Remote connectivity issue of postgresql running on 2 Ec2 instances ?
How to Remotely connect with postgres managed instance RDS@postgresql
How to Remotely connect with postgres managed instance Aurora@postgresql with pgadmin running on local system?
Remote connectivity of postges running on docker with pgadmin running on local system
3 Node Streaming Replication in PostgresQL-14
repmgr : Postgresql Replication Manager for PostgreSQL Cluster
How to promote a standby server with repmgr ?
Repmgr failover and change of roles in replication ( 1 Primary and 2 standby )
Switchover with repmgr
Logical Replication
pglogical extension setup for Logical replication
Migrating PostgreSQL from EC2 to RDS using pglogical replication
PostgreSQL Streaming Replication With Slots
Replicate tables in RDS ( 2 instances) for PostgreSQL using logical replication
Pgbackrest( Backup and restore)
Backup Postgres using pgBackRest running on dedicated host
Replication setup using using pgBackRest running on dedicated host & postgres on separate host
pgloader
Barman backup and restore via streaming protocol
Archiving in postgresql
Archiving WAL and Perform Point in Time Recovery in postgresql
Backup and Restore a PostgreSQL with pg_basebackup with Tablespaces
pg-upgrade to upgrade postgres12 to postgres15
pg-upgrade to upgrade postgres12 to postgres15( lower major verions to higher version ) with --link option
Upgrade PostgreSQL from EC2 to RDS using pglogical replication
Upgrade RDS@ PostgreSQL @Aurora PostgreSQL database using the pglogical ?
Upgrading Data via pg_dumpall upgrade postgres12 to postgres15 (vm)
Steps to upgrade using AWS DMS
Steps to upgrade using AWS DMS + ongoing changes
sysbench benchmarking tool
pgbench benchmarking tool for postgres on VM and RDS
Migration of PostgreSQL running on VM to RDS via pg_dump and pg_restore
Migrating PostgreSQL Databases to Amazon RDS using logical replication ( publisher and subscriber model.)
Migrating PostgreSQL Databases using pgcopydb
Migrating to RDS postgresql using copy command
Migrate PostgreSQL from Local to RDS postgres using pgadmin
Troubleshooting RDS/PostgreSQL on VM Connectivity issue
pgpool-11 Load balancer and connection pooling
pgbouncer Load balancing
Migrate PostgreSQL database using export and import to Azure postgresql
Migrate PostgreSQL database using pg_dump and pg_restore to Azure postgresql
Assignment on PostgreSQL-16 on Ubuntu22.04 Ec2
Assignment on pg_hba.conf file
Assignment on Aurora for PostgreSQL + Ec2
Assignment on Postgresql.conf
Assignment on PostgreSQL 16 and 13 on Ubuntu 22.04
Assignment on benchmarking Ec2 and RDS
delete wal files in postgresql
pg_stat_statement in postgresql
pg_stat_activity to analyze and perform diagnostics on active SQL queries
pgBadger - a fast PostgreSQL log analysis report
PGCollector - Complete Postgresql database analysis report
pgCluu :PostgreSQL performance monitoring and auditing tool.
Impact of missing index in postgreSQL
Getting started with explain analyze
pg_index_watch
What is auto_explain in postgresql
Hypothetical or virtual index in postgres
Parameter group in RDS PostgreSQL
Setup 2 Node streaming replication on pg15 Manually via replication slot
Setup 2 Node streaming replication on pg15 Manually via replication slot ( Bind with repmgr)
Setup 3 Node )2+1) streaming replication on pg15 Manually via replication slot ( Bind with repmgr)
Postgresql-15 Replication & Automatd Failover by Repmgr ( 4 Nodes with 3 data &1 Witness )
What is Barman (Backup and Recovery Manager)