CARE Risk Solutions is a multinational company that provides a comprehensive suite of risk management solutions for the banking, financial services, and insurance (BFSI) sectors. EDB Products and Services Postgres Advanced Server 12, Postgres Enterprise Manager, Backup and Recovery Tool, Failover Manager, Migration assessment, and Migration toolkit. The Challenge With their customers running on...

In this article, I will cover some fundamental practices to get the best out of PostgreSQL logs. This blog is not a hard and fast rule book; readers are more than welcome to share their thoughts in the comments section. To get the best value out of it though, I ask the reader to think about how they want to use their PostgreSQL database server logs:

Sometimes you need to determine which table a file on disk corresponds to. You have a path full of numbers like base/16499/19401 and you want to make sense of it.

Roberto Giordano is the head of Database Services for the Capital Markets division at the London Stock Exchange. In this talk from Postgres Vision 2020, he discusses lessons and challenges of his journey pioneering the use of open source database technologies at the LSEG over the last decade. He takes an open and honest look at what has been achieved so far, and makes insightful predictions about what the future of database and open source may look like.

Groups within the U.S. Army benefit from EDB’s decades of PostgreSQL experience. EDB supports a wide range of U.S. Army missions, including modeling and simulation, satellite communications, research initiatives, biometric identification, forward deployed tactical deployments, and lifecycle management. EDB has worked with the U.S. Army for over 10 years, and it remains one of our largest customers across the globe.

For more than a decade, the U.S. Navy has selected EDB to deliver the capabilities that push PostgreSQL further. We support several U.S. Navy missions, including Naval Surface Warfare Center (NSWC) programs, acoustics research, oceanographic data collection/processing, and global tactical command and control systems of record.

EDB supports Maryland’s Total Human services Integrated Network (MD THINK), building on PostgreSQL to help them do more and go faster in their cloud environment. MD THINK is an innovative, cloud-based platform that allows multiple state agencies to share and manage data in one convenient place. The State expects significant cost savings via the consolidation of application hosting and data center services.

In this talk from Postgres Vision 2020, Abhinav Sagar, Senior Database Consultant, and Premnath Jangam, Senior Database Administrator, from CSG International discuss the various methodologies, procedures, and techniques involved in successfully migrating data from Oracle and DB2 to PostgreSQL. Topics include steps to consider before and after migration, the time it takes to migrate, data compatibility, and much more.

Amidst database modernization and an increasing emphasis on customer-centricity, IKEA Retail Group made an important business decision to improve operations and cut downtime by moving to PostgreSQL.

Docker is quickly becoming the preferred method for deploying modern applications, but running a PostgreSQL cluster in containers is not yet prevalent. In this talk from Postgres Vision 2020, Jerry Eshbaugh, Sr. DevOps Team Leader, Federal Emergency Management Agency (FEMA), discusses the benefits and technical challenges around running PostgreSQL in production-from the first team to ever deploy containerized EDB in a mission critical production environment.