Sammlung von Newsfeeds

Bruce Momjian: Using Non-Login Roles

Neues vom PostgreSQL Planet - 18. Mai 2020 - 16:15

When we talk about database roles, most people immediately think of login roles, which allow people to log in. However, another user management feature is the ability to create non-login roles, formerly called groups.

Andreas 'ads' Scherbaum: Dimitri Fontaine

Neues vom PostgreSQL Planet - 18. Mai 2020 - 16:00
PostgreSQL Person of the Week Interview with Dimitri Fontaine: Hi! My name is Dimitri Fontaine and I’m French, currently living in the greater Paris area. When I’m not sitting in front of a computer for work, I like to be with my kids. We play board games, have fun chats, watch movies together… well or at least try to find a single movie that we would each enjoy watching… I also play the guitar.

Pavel Stehule: pspg - two new feature

Neues vom PostgreSQL Planet - 17. Mai 2020 - 19:54
I wrote two new features to pspg.

First feature is a option --skip-columns-like. Now, it can be used only for browsing csv or tsv documents. When this option is used, then specified columns (specified by substring of name) are not displayed. It can be useful for psql PostGIS data. More time some GEO data has not sense to display. If you have wide table with lot of columns, then can be nasty to write list of columns every time. Example

export PSPG="--skip-columns-like='geom$'

David Z: Build PostgreSQL and Extension on Windows

Neues vom PostgreSQL Planet - 15. Mai 2020 - 23:55
1. Overview

PostgreSQL is an open-source RDMS and running across many platforms including Linux (all recent distributions), Windows, FreeBSD, OpenBSD, NetBSD, Mac OS X, AIX, HP/UX, IRIX, Solaris, Tru64 Unix, and UnixWare. There are many discussions about how to build Postgres and extensions from source code on a Linux-like environment, but sometimes, a developer may want to quickly setup a Windows environment to check a feature for cross-platform support.

Richard Yen: How to Spot an Impostor: Working with PostgreSQL's SSL Modes

Neues vom PostgreSQL Planet - 15. Mai 2020 - 23:00

Many organizations are prioritizing projects to tighten security around their applications and services after the slew of breaches that made headlines over the past few years. The use of SSL/TLS has proliferated, and remains an important component to any software deployment. Unsurprisingly this is true for databases, and the PostgreSQL community is continuing to augment its alraedy-reliable security for the world’s most powerful open-source database.

cary huang: Benefits of External Key Management System Over the Internal and How they Could Help Securing PostgreSQL

Neues vom PostgreSQL Planet - 15. Mai 2020 - 22:56
1. Introduction

Data and user security have always been important considerations for small to large enterprises during the deployment of their database or application servers. PostgreSQL today has rich support for many network level and user level security features. These include TLS to secure database connections, internal user authentication, integration with external user authentication services such as RADIUS, LDAP and GSSAPI, and TLS certificate based user authentication …etc.

Bruce Momjian: Draft of Postgres 13 Release Notes

Neues vom PostgreSQL Planet - 15. Mai 2020 - 15:45

I have completed the draft version of the Postgres 13 release notes, containing 181 items. The release notes will be continually updated until the final release, which is expected to be in September or October of this year. Beta testing will start in the next few weeks.

Devrim GÜNDÜZ: yum users: some -devel RPMs require a new repository

Neues vom PostgreSQL Planet - 14. Mai 2020 - 21:32
The PostgreSQL Global Development Group has released an update to all supported versions today -- so RPMs also got updated.

How to compile and run a C program in Linux

PostgresqlHelp - 14. Mai 2020 - 12:02

PostgreSQL is written in C, so installing PostgreSQL software is nothing but compiling and running all the C-Programs in your source code.

To work with PostgreSQL internals it is highly recommended to learn the basics of C programming.

How to create and compile a C Program on Linux

Create a C program called first.c

[root@prim final]# cat first.c #include<stdio.h> int main(void) { printf("Hello! This is a test prgoram.\n"); }

To compile this program, enter:

PostgreSQL Extension – Master Note

PostgresqlHelp - 14. Mai 2020 - 11:51

PostgreSQL is an open-source database management system. It is a great way to learn to program, design and debug.

One of the main features of PostgreSQL is Extensions.

Extensions of PostgreSQL can be an as small extension as pg_fincore, used to understand the OS cache of your PostgreSQL pages to the large projects like PostGIS and Citus data.

The PostgreSQL extension is a piece of script or code which enhances the functionality of your PostgreSQL server.

In this post, we are going to understand…

Jimmy Angelakos: Keep your libraries updated and nobody gets hurt

Neues vom PostgreSQL Planet - 14. Mai 2020 - 11:41
Don’t make people practice software archaeology – keep your system updated. Updates? One of the benefits of the open-source world is the unmatched ability to issue updates rapidly to correct bugs and security vulnerabilities. Software bug fixes keep streaming in: from recently introduced regressions, to long-standing bugs undetected for years, they are corrected by a […]

Laurenz Albe: Binary data performance in PostgreSQL

Neues vom PostgreSQL Planet - 14. Mai 2020 - 10:00

© Laurenz Albe 2020

A frequently asked question in this big data world is whether it is better to store binary data inside or outside of a PostgreSQL database. Also, since PostgreSQL has two ways of storing binary data, which one is better?

I decided to benchmark the available options to have some data points next time somebody asks me, and I thought this might be interesting for others as well.

Pavel Stehule: dbms_sql

Neues vom PostgreSQL Planet - 13. Mai 2020 - 19:31
Like lot of other people I had different plans to spring this year. Instead a walk to Santiago, I sit at home. On second hand it is time to finish some repairing on my house and write some code.

Bruce Momjian: Avoiding Cache Wipe, Synchronized Scans

Neues vom PostgreSQL Planet - 13. Mai 2020 - 14:45

Whenever you are dealing with a lot of data, it helps to cache it. Postgres does this using shared_buffers. However, one risk of caching data is that a large query that accesses a lot of data might remove frequently-accessed data from the cache; this is called cache wipe. To avoid this, Postgres limits the number of shared buffers used by data operations that are expected to access a lot of data.

Hans-Juergen Schoenig: PostgreSQL: Network latency does make a BIG difference

Neues vom PostgreSQL Planet - 12. Mai 2020 - 10:00

Database performance is truly important. However, when looking at performance in general people only consider the speed of SQL statements and forget the big picture. The questions now are: What is this big picture I am talking about? What is it that can make a real difference? What if not the SQL statements? More often than not the SQL part is taken care of. What people forget is latency. That is right: Network latency

Bruce Momjian: Why Do We Freeze?

Neues vom PostgreSQL Planet - 11. Mai 2020 - 23:30

You might have seen autovacuum running, and noticed that it sometimes performs freeze operations on transaction ids (32 bits) and multi-xacts (used for multi-session row locking).

Robert Haas: Don't Manually Modify The PostgreSQL Data Directory!

Neues vom PostgreSQL Planet - 11. Mai 2020 - 18:07
I was lucky enough to get a chance to give my talk Avoiding, Detecting, and Recovering From Data Corruption at PGCONF.IN in February, before everything got shut down. The conference organizers did an amazing job with the video, which shows both me speaking and the slides I was presenting side by side. That's the first time a PostgreSQL conference has done the video that way, and I love it.

Andreas 'ads' Scherbaum: Fabrízio de Royes Mello

Neues vom PostgreSQL Planet - 11. Mai 2020 - 16:00
PostgreSQL Person of the Week Interview with Fabrízio de Royes Mello: Hi, I’m Fabrízio. I was born and live in the southern part of Brazil, in a city called Bagé. It’s close to the border with Uruguay. I’m married and have four daughters. Also I have three cats, one dog and two mices. I love to spend time with my family and friends. I like watching movies, series and sports (soccer, martial arts, volleyball).