Tag: PostgreSQL

Feed: Recent Announcements. AWS Database Migration Service (AWS DMS) has expanded functionality by adding support for Amazon Aurora Serverless (PostgreSQL-compatible edition) as a target. Amazon Aurora Serverless (PostgreSQL-compatible edition) is an on-demand, auto-scaling configuration where the database will automatically start up, shut down, and scale capacity up or down based on your application's needs. Using AWS DMS, you can now perform live migrations from any AWS DMS supported sources to Amazon Aurora Serverless (PostgreSQL-compatible edition) with minimal downtime ... Read More

Feed: Planet PostgreSQL. At most of the places I've worked, the primary language used was not what I gravitated to naturally. If you're going to ask for a language of choice personally, it's python. I appreciate the explicit nature, that it's often pseudocode that can execute and it has a rich ecosystem of libraries (though that’s most languages these days). But as much as anything I latched onto Django in its early days. If you're not familiar with Django it's a popular framework for web apps written in Python. What I loved about it in particular was one of its ... Read More

Feed: Planet PostgreSQL. Date: 23.11.2020 Tags:   postgresql    pspg    plpgsql_check    Category:   Interviews    Interviewed by: Andreas Scherbaum PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here. Please tell us about yourself, and where you are from. I am from the Czech Republic, and live in my home village in Central Czech. I am an independent developer, consultant and lecturer. My work is 100% related to Postgres - training, solving customer performance issues, ... Read More

Feed: Planet PostgreSQL. pgBackRest is a well-known powerful backup and restore tool. It offers a lot of possibilities. In this post, we’ll see how to setup a dedicated repository host to backup a PostgreSQL 3-nodes cluster. The repository host will be called backup-srv and the 3 PostgreSQL nodes in Streaming Replication: pg1-srv, pg2-srv, pg3-srv. All the nodes will be running on CentOS 7. If you’re familiar with Vagrant, here’s a simple Vagrantfile to initiate 4 virtual machines using those names: # Vagrantfile Vagrant.configure(2) do |config| config.vm.box = 'centos/7' config.vm.provider 'libvirt' do |lv| lv.cpus = 1 lv.memory = 1024 end nodes ... Read More

Feed: Planet PostgreSQL. Summarizing data against a fixed grid is a common way of preparing data for analysis. Fixed grids have some advantages over natural and administrative boundaries: ... Read More

Feed: Planet PostgreSQL. Author: Regina Obe  2020/11/20  in news ( release, 3.0.3, ) The PostGIS Team is pleased to release PostGIS 3.0.3. Best served with PostgreSQL 13.1, and GEOS 3.8.1 pgRouting 3.1.1 PostGIS 3.0.3 Details of this release can be found in NEWS file: https://git.osgeo.org/gitea/postgis/postgis/src/tag/3.0.3/NEWS which is also included in source tar ball and in this email. If you come across any issues, feel free to report via our ticket tracker https://trac.osgeo.org/postgis or mailing list with details as described here - https://postgis.net/support/. For security issues, send reports to security@postgis.net. View all tickets for 3.0.3 milestone. PostGIS 3.0.3 2020/11/20 Bug Fixes ... Read More

Feed: Planet PostgreSQL. Well, we've already discussed isolation and made a digression regarding the low-level data structure. And we've finally reached the most fascinating thing, that is, row versions (tuples).Tuple headerAs already mentioned, several versions of each row can be simultaneously available in the database. And we need to somehow distinguish one version from another one. To this end, each version is labeled with its effective "time" (xmin) and expiration "time" (xmax). Quotation marks denote that a special incrementing counter is used rather than the time itself. And this counter is the transaction identifier.(As usual, in reality this is more ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Yusuf Ali. By Yusuf Ali, Solution Architect & Delivery Lead – FujitsuBy Rob Evans, Application Transformation Product Manager – FujitsuBy Eric Payeur, Director – Head of Application Modernization, Mainframe Migration – FujitsuBy Serge Moro and Addy Dubhashi – AWS In the last two decades, the financial services market has been undergoing significant transformation driven by the competition of new market entrants, customer demand, and regulation. This transformation is powered by new technology, including cloud services. Furthermore, COVID-19 has brought severe disruption to traditional operations and raised the need of accelerated digital engagement and ... Read More

Feed: Planet PostgreSQL. This week Apple started delivering Macs using their own Apple Silicon chips, starting with a Mac SOC named the M1. M1 uses the ARM instruction set and claims some amazing acceleration for media workloads. I wanted to know how it would do running PostgreSQL, an app that's been running on various ARM systems for years. The results are great! ... Read More

Feed: Planet PostgreSQL. Author: Regina Obe  2020/11/19  in news ( release, 3.1, 3.1.0alpha3 ) The PostGIS Team is pleased to release the third alpha of upcoming PostGIS 3.1.0 release. This version is exposes some of the new performance and feature enhancements in not yet relesed GEOS 3.9 as well as numerous speed enhancements not requiring newer GEOS. Requires GEOS 3.6+ and PostgreSQL 9.6+. To use MVT you will need protobuf-c 1.1. or higher. Best served with PostgreSQL 13.1, GEOS 3.7 or higher is recommended. pgRouting 3.1.1 3.1.0alpha3 Details of this release can be found in NEWS file: https://git.osgeo.org/gitea/postgis/postgis/src/tag/3.1.0alpha3/NEWS Which is ... Read More