This lab walks you through the creation and testing of an Amazon RDS database. We will create an RDS PostgreSQL database and test the connection.
Duration: 90 minutes
AWS Region: US East (N. Virginia)
Difference between PostgreSQL and MySQL database
PostgresSQL is an object-relational database management system whereas MySQL is a relational database management system.
PostgreSQL is only supported by Windows, Mac OS X, Linux, and BSD but not by UNIX, z/OS, Symbian, AmigaOS. Whereas MySQL is supported by the following operating system, Windows, Mac OS X, Linux, BSD, UNIX, z/OS, Symbian, AmigaOS.
PostgreSQL is a product of the Global Development Group while MySQL is the product of Oracle Corporation.
PostgresSQL provides complete backup online, On the other hand, MySQL, mysqldump, and XtraBackup tools provide backup.
PostgreSQL provides data domain objects while MySQL does not offer data domain objects.
Windows and Mac users need to download and install from https://dbeaver.io/download/
1. Create RDS Database Instance.
2. Connecting to Amazon RDS PostgreSQL Database on a DB Instance.
3. Connecting from local Linux/IOS/Windows Machine
4. Execute Database Operations