Tag: MD5

Feed: Planet PostgreSQL. © Laurenz Albe 2021Since v10, PostgreSQL has provided support for scram-sha-256 for password hashing and authentication. This article describes how you can adapt your application safely.Why do we need scram-sha-256?PostgreSQL uses cryptographic hashing for two purposes:The actual database password is a hash of the clear text password entered by the user. This prevents a thief from using a stolen password on other systems.During password authentication, the client has to hash the (hashed) password with a random salt provided by the server. The password check is successful if the server receives the correct hashed response from the client.Now, ... Read More

Feed: Planet PostgreSQL. Deploying PostgreSQL for High Availability with Patroni, etcd and HAProxy – Part 2 In the first part of this blog we configured an etcd cluster on top of three CentOS 7 servers. We had to tweak the operating system configuration in order to have everything running smoothly. In this post we’ll see how to configure Patroni using the running etcd cluster as a distributed configuration store (DCS) and HAProxy to route connections to the active leader. Patroni Configuration The patroni configuration is a yaml file divided in sections with each section controlling a specific part of the ... Read More

Feed: AWS Architecture Blog. This post was co-written by FactSet’s Cloud Infrastructure team, Gaurav Jain, Nathan Goodman, Geoff Wang, Daniel Cordes, Sunu Joseph and AWS Solution Architects, Amit Borulkar and Tarik Makota. At FactSet, their goal for cloud platform on AWS Cloud is to have high developer velocity alongside enterprise governance. They wanted application teams to have a frictionless experience that balances agility, governance, and ease of use. They achieved it using micro-accounts, where each AWS account is allocated for one project and is owned by a single team. By using the AWS account as an isolation boundary, each application ... Read More

Feed: Planet PostgreSQL. While migrating to PostgreSQL, some of the users may be curious about the type of replication offered by PostgreSQL. Some might want to know if they have to pay any additional enterprise license in order to achieve this requirement. This is because, a few commercial databases require a customer to take an enteprise license to setup replication. But, PostgreSQL, like advanced Open Source databases, automatically offers several types of replication methods built-in. This means, we never have to consider taking any additional license or an enterprise solution and stay away from vendor lock-in while using PostgreSQL. In ... Read More

Feed: Planet PostgreSQL. Bloating in database is created when tables or indexes are updated, an update is essentially a delete and insert operation. The diskspace used by the delete is available for reuse but it is not reclaimed hence creating the bloat. Same is the case with PostgreSQL database, frequent UPDATE and DELETE operations can leave a lot of unused space in table or index relation files on disk. Over the time this space can build up and cause the performance degradation for both tables and indexes. This buildup is referred to as bloated tables or indexes. This blog will look into ... 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

Feed: Planet PostgreSQL. Yes, this post is about connection queueing, not just pooling. Because “connection pooling” – pre-created connections as a pool – is a much-celebrated feature. Almost every discussion on connection pool/pgBouncer starts with the overhead of establishing a new connection to PostgreSQL… and how pre-created connections in the pool can save the world. But there is a non-celebrity feature in pgBouncer (not denying others) that can address some of the real big operational challenges. It is the connection queueing. Many new PostgreSQL users don’t know there is something like this. In this blog post, I am planning to ... Read More

Feed: R-bloggers. Author: George Pipis. [This article was first published on R – Predictive Hacks, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. In many cases, there is a need to split a userbase into 2 or more buckets. For example: UCG: Many companies that run promotional campaigns, in order to quantify and evaluate the performance of the campaigns, create a Universal Control Group (UCG) which is a random sample of the userbase ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; Hello, Puppet friends! It’s been a few months since we rolled out the latest major version of the Puppet platform, bumping PuppetDB, Puppet Server and Puppet Agent to “7.0.0.” First, we’d like to extend our gratitude to our vibrant Puppet community, who helped us immensely in locating and fixing some annoying bugs that managed to sneak through the release. We promptly provided follow-up releases, so be sure to check out the latest available versions for your operating system. Even though we strived to make most of the changes backwards-compatible, there are some breaking ... 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 briefly see how to setup a dedicated repository host to backup an Advanced Server 3-nodes cluster. The repository host will be called backup-srv and the 3 Advanced Server 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 = ... Read More