Category: PostgreSQL compatible

July 2023: This post was reviewed for accuracy. PostgreSQL is one of the most popular open-source relational database systems. With more than 30 years of development work, PostgreSQL has proven to be a highly reliable and robust database that can handle a large number of complicated data workloads. PostgreSQL is considered to be the primary […]

Companies are experiencing exponential data growth year-over-year. Scaling the databases and the hardware infrastructure to keep up is becoming more and more challenging. If your workloads just are not suitable for non-relational data stores, how do you overcome the scaling challenges without spending tons of money in managing the underlying infrastructure? Amazon RDS for PostgreSQL and Amazon […]

An Oracle to PostgreSQL migration in the AWS Cloud can be a complex multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. This blog series covers the environment and configuration setups for your source Oracle database, the AWS Database Migration (AWS DMS) service, and the target PostgreSQL […]

July 2023: This post was reviewed for accuracy. Migrating and operating a database includes layers of complexity and thorough planning. Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL compatibility can help you manage a variety of use cases. While migrating from Oracle to PostgreSQL, it’s very common to come across Oracle Autonomous Transactions. This […]

If you’re migrating from Microsoft SQL Server to Amazon Aurora PostgreSQL, you might have discovered that the SQL agent jobs cannot be easily moved. The job agent tools are not supported for Aurora PostgreSQL. You can overcome this limitation though, by using AWS Step Functions to replace a SQL agent job. In this blog post […]

New Innovations has built a business around shared ideas and beliefs that all point to a larger purpose—empowering medical educators and administrators to provide quality medical education. Intelligence is advancing to the point where there is no separation between task and technology, and the result is that medical trainees and educators can be relieved of mundane administrative duties. Our partners in medical education work with us so that one day this ideal future becomes a reality.

The future is not far away, and thanks to AWS and Amazon Aurora PostgreSQL, our company has been able to build an infrastructure that scales to meet our customers’ demands. AWS Database Migration Service (AWS DMS) made our transition to Aurora PostgreSQL a seamless experience for both our customers and our software developers, while minimizing the risk. We used AWS DMS to fully migrate 700+ instances of Microsoft SQL Server to Aurora PostgreSQL. In addition, Amazon RDS Performance Insights now gives us excellent visibility into our database layer and allows us to respond quickly to any abnormalities.

Born on AWS InfoScout was born on AWS, being along for the journey since its inception in 2011. It all started with a single Amazon EC2 instance to collect receipts uploaded from friends and family. Seven years later, we now manage 150+ AWS instances to support our mobile applications, data pipelines, machine learning models, and […]

Replication, failover, resilience, disaster recovery, and backups—it can be challenging to achieve any or all of these in a traditional or non-cloud-based architecture. In addition, they sometimes require a considerable re-engineering effort. Due to the high implementation and infrastructure costs that are involved, some businesses are compelled to tier their applications so that only the […]

Many enterprises are considering migrating their Oracle databases to PostgreSQL because of the close compatibility between the platforms and the enterprises’ desire to reduce licensing costs. Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL compatibility make it easy to set up, operate, and scale PostgreSQL deployments in the cloud in a cost-efficient manner. AWS […]

Amazon Aurora provides endpoints for the primary DB instance (the cluster endpoint) and for Read Replicas (the reader endpoint). Aurora updates the cluster endpoint automatically so that it always points to the primary instance. The reader endpoint load balances read operations across all available Read Replicas. Amazon Aurora Replicas typically have less than 100 ms […]