Sammlung von Newsfeeds

Lætitia AVROT: Can't connect to Postgres

Neues vom PostgreSQL Planet - 30. März 2020 - 19:42
This is kind of frustrating… You’ve been at it for the best part of the day and you can’t figure it out. You already tested that Postgres was running and that you were attempting to connect to the right port and you checked the host several times but you still can’t connect to Postgres! I won’t give you a full review of all possible causes, because they are too many and I’m pretty sure I will forget some, but here ar some clues for you.

David Z: PostgreSQL GSSAPI Authentication with Kerberos part-3: the status of authentication, encryption and user principal

Neues vom PostgreSQL Planet - 30. März 2020 - 17:15
1. Overview

In previous two blogs, we explained how to setup Kerberos, and how to configure PostgreSQL to support GSSAPI user authentication. This blog will be focusing on how to check GSSAPI authentication, encryption and user principal information when given different connection options.

Andreas 'ads' Scherbaum: Sarah Conway Schnurr

Neues vom PostgreSQL Planet - 30. März 2020 - 16:00
PostgreSQL Person of the Week Interview with Sarah Conway Schnurr: I am from Southern California, where I’ve spent most of my free time hiking in the beautiful local deserts and pursuing many creative endeavors. Primarily, I am a software engineer & front-end website developer at Crunchy Data, a violin teacher & violin/viola performer, as well as a creator of zero-waste and all-natural homemade goods. I am also the co-parent of four beautiful cats, as well as the many adoptive fosters, strays, and friendly neighborhood cats that my husband and I visit on our daily walks.

movead li: PostgreSQL_WAL_Evolution_Part_II

Neues vom PostgreSQL Planet - 30. März 2020 - 5:10

This is the second part of the topic, the more historical version is described in the previous part, and here is the vitality of wal in PostgreSQL which born replication、logical replication and more performance related configure, let’s continue to redo it.

1. Replication(V9.0)

Replication is implemented here, and many corresponding GUC are added for replication. Corresponding to warm standby, replication can also be called hot standby, which helps to achieve the data synchronization using WAL record between the primary and the standby.

movead li: PostgreSQL_WAL_Evolution_Part_I

Neues vom PostgreSQL Planet - 30. März 2020 - 5:10

WAL is one of the most important parts of PostgreSQL., WAL records all the database activity. Hense we can regard wal as a change roadmap of the history of PostgreSQL database, and the crash recovery, logical replication etc aren’t possible without WAL. The following picture describes the various wal related GUC (based on PG12) involved in the production and use of wal logs. It is very important for us to know the meaning of each parameter to optimize database performance and configure high availability cluster..

Dan Langille: creating a Nagios check on a PostgreSQL table

Neues vom PostgreSQL Planet - 29. März 2020 - 20:53
When I started this, I thought it was be straight forward and take only a few hours at most. It turned into multiple hours over two days. This is part two of a two-part post. The first part dealt with changing a database column from time to timestamp. In this post: PostgreSQL 12.2 Nagios 3.5 [...]

Dan Langille: Changing a column type

Neues vom PostgreSQL Planet - 29. März 2020 - 19:46
The plan for today was not decided until after I got out of bed. I sat down with coffee and looked through the list of tasks. I found one which appealed: monitor the cache_clearing_ports & cache_clearing_dates tables This is part one of a two-part story. The first part deals with fixing a database table before [...]

Pavel Stehule: pspg 2.7.0 with inotify support

Neues vom PostgreSQL Planet - 27. März 2020 - 21:10
Long time I am playing with psql and I try to enhance and fix some limits of this client. I like it. The work with this client is pretty fast, and with pspg the result's browsing is almost comfortable. But still there is disadvantage - is not possible to see result and query in one time, and isn't possible to work with more results in one time. But with new inotify support these limits are removed. You can create file that will be used as input/output buffer. Then you can start pspg against this file with --inotify option.

Hans-Juergen Schoenig: pg_show_plans: Watching execution plans in PostgreSQL LIVE

Neues vom PostgreSQL Planet - 27. März 2020 - 10:00

After 20 years in professional PostgreSQL support and consulting we are finally able to answer one of the most frequently asked questions: “How can I see all active query plans?” Ladies and gentlemen, let me introduce you to pg_show_plans, an extension which does exactly that. pg_show_plans is Open Source and can be used free of charge as a standard PostgreSQL extension.

David Z: PostgreSQL GSSAPI Authentication with Kerberos part-2: PostgreSQL Configuration

Neues vom PostgreSQL Planet - 26. März 2020 - 19:01
1. Overview

In previous blog, we have setup Kerberos, added all required principals and verified each principal. This blog will explain all the necessary configuration, i.e. postgresql.conf, pg_hba.conf and pg_ident.conf, in PostgreSQL for user authentication using GSSAPI with Kerberos.

PostgreSQL Configure Make and Make install Explained

PostgresqlHelp - 26. März 2020 - 13:57

What does the below code snippet really mean in PostgreSQL while installing software?

make install

We will understand it in this post.

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

We will do that with an example.,

How to compile and run a C program in Linux?
  1. Create a program called first.c

Hamid Akhtar: Optimizing SQL – Step 1: EXPLAIN in PostgreSQL – Part 1

Neues vom PostgreSQL Planet - 26. März 2020 - 11:43

This is my first blog in a series of SQL optimization blogs. So expect some basic information in here along with some nice insights. My aim is to help you walk through a complete process of understanding and optimizing queries for improved performance. A PostgreSQL server attempts to find the most effective way of building a result set for the query. The first step in that direction is the ability to understand what the “EXPLAIN” command is. 

Fernando Laudares Camargos: A Tale About Migrating a PostgreSQL Database Between Different DBaaS Providers

Neues vom PostgreSQL Planet - 25. März 2020 - 16:18

We recently helped migrate a production PostgreSQL database running on a given DBaaS platform… to another DBaaS platform. When it comes to vendor “lock-in”, some providers are easier (and even friendlier) to deal with than others, but it is never a straightforward process.

Laurenz Albe: Embedded SQL in C for PostgreSQL with ecpg

Neues vom PostgreSQL Planet - 25. März 2020 - 9:00

© Laurenz Albe 2020


Embedded SQL is by no means a new feature — in fact it is so old-fashioned that many people may not know about it at all. Still, it has lots of advantages for client code written in C. So I’d like to give a brief introduction and talk about its benefits and problems.

cary huang: Logical Replication Between PostgreSQL and MongoDB

Neues vom PostgreSQL Planet - 24. März 2020 - 18:59
1. Introduction

PostgreSQL and MongoDB are two popular open source relational (SQL) and non-relational (NoSQL) databases available today. Both are maintained by groups of very experienced development teams globally and are widely used in many popular industries for adminitration and analytical purposes. MongoDB is a NoSQL Document-oriented Database which stores the data in form of key-value pairs expressed in JSON or BSON; it provides high performance and scalability along with data modelling and data management of huge sets of data in an enterprise application.

Muhammad Usama: Atomic commit and Atomic visibility for PostgreSQL. Explained!

Neues vom PostgreSQL Planet - 24. März 2020 - 16:11

There is a lot of interest and discussions lately in the PostgreSQL world to make it a scale-out solution. Among other possible solutions, one of the most promising ones is to implement the sharding using FDW and table partitioning for distributing the data on multiple servers. As of now, PostgreSQL can only fetch the data from FDW in serial and that is one thing that needs to be improved to increase the performance.

Peter Eisentraut: Developing PostgreSQL for Windows, Part 3

Neues vom PostgreSQL Planet - 24. März 2020 - 15:53
Let’s wrap this up. In part 1 of this blog series, I explained the different Windows build targets supported by PostgreSQL. In part 2, I showed how to test patches for Windows compatibility and how to easily spin up a Windows environment for testing and simple development. Now, in this third and final part, we’ll […]

Paul Ramsey: Tile Serving with Dynamic Geometry

Neues vom PostgreSQL Planet - 24. März 2020 - 14:24

In our previous posting on tile serving, we showed off how pg_tileserv can use database functions to generate tiles by querying existing tables with user parameters.

We can also use functions to build geometry on the fly without input from tables. For example, hexagons!

Christoph Berg: Announcing

Neues vom PostgreSQL Planet - 24. März 2020 - 12:08

Users had often asked where they could find older versions of packages from I had been collecting these since about April 2013, and in July 2016, I made the packages available via an ad-hoc URL on the repository master host, called "the morgue". There was little repository structure, all files belonging to a source package were stuffed into a single directory, no matter what distribution they belonged to.

Pavel Stehule: small update of ncurses-st-menu

Neues vom PostgreSQL Planet - 24. März 2020 - 5:20
ncurses-st-menu is small library over ncurses for pulldown and menubar menu. Stripped size of library has 43kB, so it is not extra light, but it is in category smaller libraries. One use case, that I would to support, is using in smaller application on smaller devices. For this purpose this library supports scrollable menu now. When the content of menu is longer then display, then the content will be scrollable - so cursor will be visible every time.