Tag: PostgreSQL

Feed: Planet PostgreSQL. © Laurenz Albe 2021PostgreSQL commit ee28cacf61 has added new options for the target_session_attrs connection parameter. This article explores how the new options can be used to simplify high availability and horizontal scaling solutions.What is target_session_attrs?The PostgreSQL client shared library libpq has support for connection strings to more than one database server: psql 'host=server1.my.org,server2.my.org port=5432,5432 dbname=mydb user=myself' In the URL connection string format, that would look like psql 'postgresql://myself@server1.my.org:5432,server2.my.org:5432/mydb' Then the client will first try to connect to server1.my.org, and if it cannot reach that server, it will try to connect to server2.my.org.This is useful in combination with ... Read More

Feed: Planet PostgreSQL. 1. Overview PostgreSQL supports many System Information Functions, such as Session Information Functions, Access Privilege Inquiry Functions, Schema Visibility Inquiry Functions, System Catalog Information Functions, Transaction ID and Snapshot Information Functions, etc. However, you may want build some special functions and integrate them into the PostgreSQL. This blog is going to walk through the steps about how to build your own System Information Functions into PostgreSQL. 2. Analyze the requirement Since there are so many functions built-in PostgreSQL already, you should perform some research and analysis before you decide to create a new one. In this blog, ... Read More

Feed: Planet PostgreSQL. 1. Introduction As an experienced PostgreSQL user, you may have a lot of experience in setting up streaming replication in your database clusters to make multiple backups of your data. But have you wondered how the standby is able to correctly determine if a tuple sent from the primary should be visible to the user or not. In the case where a transaction contains multiple subtransactions, how does the standby determine the visibility in this case? You might say… well it is PostgreSQL so it will just work… This is true. If you are someone who is ... Read More

Feed: Planet PostgreSQL. 03 Mar 2021 Are you tired of this syntax in PostgreSQL? SELECT jsonb_column->'key' FROM table; UPDATE table SET jsonb_column = jsonb_set(jsonb_column, '{"key"}', '"value"'); The select part is actually fine. But for updates, especially for complex updates, it could be pretty verbose and far from being ergonomic. What would you say to this syntax instead? SELECT jsonb_column['key'] FROM table; UPDATE table SET jsonb_column['key'] = '"value"'; With subscripting it looks more concise and probably even familiar for developers due to its “pythonic” style. If you like this syntax more I have good news for you, recently a patch implementing ... Read More

Feed: Microsoft Azure Blog. Author: Erin Chapple. As our customers move beyond immediate crisis needs, such as enabling remote work, many are accelerating cloud adoption to increase competitive advantage and stay more digitally resilient. Enabling an agile, scalable, high-performing, and reliable infrastructure is critical to long-term success. Microsoft is committed to continuous innovation in Azure IaaS capabilities to help customers achieve these goals. Today, we are announcing new updates to our Azure infrastructure portfolio that help address a wide range of customer needs. Increase agility with access to more choices and flexibility Being responsive to rapidly changing business requirements is ... Read More

Feed: Planet PostgreSQL. In this post I will show you how I discovered that the backend was putting data into a new table (generate_plist) but the website was still using the ports.pkg_plist column. The result was stale data being shown on the website (for older ports) or no data at all (for newer ports). How long? Since Oct 2017, because that’s when configure_plist showed up on the website. Nobody noticed until recently. I can only guess that I made the backend changes with intent to change the frontend later. I should have created myself a ticket. Why was the change ... Read More

Feed: Redis Labs. Author: Amiram Mizne. This morning, Microsoft and Redis Labs jointly announced the general availability of Azure Cache for Redis, Enterprise tiers. The service has been in public preview since last October, and is already serving customers with production Redis workloads. The GA release is now enhanced with previews of active geo-replication (with up to 99.999% availability), and disk persistence with recovery while being rolled out to an increasing number of Azure regions.  Enterprise tiers: highlights The following Enterprise and Flash tier capabilities are now generally available: Open source Redis 6.0: faster, more secure, and easier to useZone ... Read More

Feed: Recent Announcements. You can initiate a minor version upgrade manually by modifying your DB cluster, or you can enable the "Auto minor version upgrade" option when creating or modifying a DB cluster. Enabling auto minor version upgrade means that your DB cluster is automatically upgraded after AWS tests and approves the new version. For more details, see Automatic Minor Version Upgrades for PostgreSQL. Please review the Aurora documentation to learn more.   Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better ... Read More

Feed: Redis Labs. Author: Steve Naventi. The shift toward online digital conferences has prompted Microsoft to reconvene Ignite about six months early this year. Scanning the data and analytics announcements, the overriding theme is of extending the reach of the portfolio of Azure data platforms.For data and analytics, the headlines on this go-round include a new Azure Managed Instance for Apache Cassandra; support for a MongoDB 4.0 API in Azure Cosmos DB; the general availability of Azure Synapse Link for Cosmos DB; and some enhancements to Azure Cache for Redis offering. And Microsoft is introducing new tools for data warehouse ... Read More

Feed: Planet PostgreSQL. To make it easier for our readers to install PostgreSQL on Ubuntu, we have compiled a quick guide to getting started. Don’t worry, it’s not too hard. You will learn:How to download PostgreSQLHow to install PostgreSQL on UbuntuHow to create a database instanceHow to ensure the service is runningCreating your first tableNote that this is an introduction. If you are looking to create a PostgreSQL High-Availability cluster, we recommend checking out some of our other content.Preparing the systemFor this demonstration I have created a virtual machine using VirtualBox on my local machine. We use Ubuntu 20.10 in ... Read More