Deprecated: Return type of Ai1wm_Recursive_Directory_Iterator::hasChildren($allow_links = true) should either be compatible with RecursiveDirectoryIterator::hasChildren(bool $allowLinks = false): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php on line 57
Deprecated: Return type of Ai1wm_Recursive_Directory_Iterator::rewind() should either be compatible with FilesystemIterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php on line 35
Deprecated: Return type of Ai1wm_Recursive_Directory_Iterator::next() should either be compatible with DirectoryIterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php on line 42
Deprecated: Return type of Ai1wm_Recursive_Extension_Filter::getChildren() should either be compatible with RecursiveFilterIterator::getChildren(): ?RecursiveFilterIterator, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-extension-filter.php on line 47
Deprecated: Return type of Ai1wm_Recursive_Extension_Filter::accept() should either be compatible with FilterIterator::accept(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-extension-filter.php on line 37
Deprecated: Return type of Ai1wm_Recursive_Exclude_Filter::getChildren() should either be compatible with RecursiveFilterIterator::getChildren(): ?RecursiveFilterIterator, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-exclude-filter.php on line 41
Deprecated: Return type of Ai1wm_Recursive_Exclude_Filter::accept() should either be compatible with FilterIterator::accept(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-exclude-filter.php on line 37
Deprecated: Return type of Ai1wm_Recursive_Newline_Filter::accept() should either be compatible with FilterIterator::accept(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-newline-filter.php on line 28
Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896
Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896
Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896
Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896
Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896
Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896
Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896
Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896
{"id":29697,"date":"2023-02-20T08:48:17","date_gmt":"2023-02-20T08:48:17","guid":{"rendered":"https:\/\/greaterinsights.in\/staging1\/?page_id=29697"},"modified":"2023-12-01T10:37:38","modified_gmt":"2023-12-01T10:37:38","slug":"postgresql-dba","status":"publish","type":"page","link":"https:\/\/greaterinsights.in\/staging1\/postgresql-dba\/","title":{"rendered":"PostgreSQL DBA"},"content":{"rendered":"\t\t
Master the basics of Postgres Administration from installation to creating the database, clusters and servers as you learn with our expert. Through our practical oriented PostgreSQL DBA training, be able to use sophisticated features of Postgres database such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online\/hot backups,the query planner\/optimizer, and write ahead logging for fault tolerance.In our Cloudlabs, practice installing PostgreSQL, configuring it, defining roles and privileges, and adding security measures. Get hands on practice on advanced databases operations from SQLDump, restore, replication of the database to migrating Oracle to Postgres DB and upgrade it. Be able to professionally optimize, monitor and maintain the Postgres DB.<\/span>Be the PostgreSQL DBA your organization wants<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
At the end of the training, participants will be able to:<\/h3><\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Install and setup PostgreSQL<\/li>
Create databases and database structures<\/li>
Insert and manipulate data in a PostgreSQL database<\/li>
Define roles, their attributes and role memberships<\/li>
Select the encryption method and setup security for the database<\/li>
Perform Backup and Recovery, SQL Dump, and Restore<\/li>
Upgrade the Postgres DB<\/li>
Migrate the Oracle DB to Postgres<\/li>
Maintain, monitor and optimize the PostgreSQL database<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t