Sammlung von Newsfeeds

LDAP

PostgresqlHelp - 29. August 2024 - 7:22

Introduction to LDAP

Purpose

The Lightweight Directory Access Protocol (LDAP) is a directory service protocol that runs on a layer above the TCP/IP stack. It provides a mechanism used to connect to, search, and modify Internet directories.

How directory service works?

The LDAP directory service is based on a client-server model.

LDAP stores data in tree structure. When LDAP client connects to an LDAP server and requests information or performs an operation, the server performs the operation or provides the information.

Directory Entries

Andreas Scherbaum: PostgreSQL Hacking Workshop - August 2024

Neues vom PostgreSQL Planet - 29. August 2024 - 0:00

On August 8th and August 15th, the first two “PostgreSQL Hacking Workshops” took place. Robert Haas previously asked on Discord for topics, and the highest vote was for “PostgreSQL Optimizer Methodology”. The invited attendees are expected to watch the video before, and bring questions to the workshop.

Keith Fiske: Announcing an Open Source Monitoring Extension for Postgres with pgMonitor

Neues vom PostgreSQL Planet - 27. August 2024 - 16:00

Crunchy Data is pleased to announce a new open source pgMonitor Extension. Crunchy Data has worked on a pgMonitor tool for several years as part of our Kubernetes and self-managed Postgres deployments and recently we’ve added an extension to the tool set.

Two primary scenarios motivated the creation of the pgMonitor extension :

Umair Shahid: PostgreSQL is a viable alternative to Oracle – here is why…

Neues vom PostgreSQL Planet - 27. August 2024 - 13:23

Why pay $100,000 for something you can achieve in $5,000? That’s the main question. Oracle is a long-standing giant in the DBMS world, offering a feature-rich platform but at a steep price, often catering to large enterprises with extensive budgets. PostgreSQL, on the other hand, is open source with a liberal license and zero licensing fees.

Tomas Vondra: [PATCH IDEA] Using COPY for postgres_fdw INSERT batching

Neues vom PostgreSQL Planet - 27. August 2024 - 12:00

In an earlier post I mentioned I plan to share a couple patch ideas, suitable for new contributors. This is the first one, about using COPY protocol for postgres_fdw batching. This would replace the current implementation, based on prepared statements. Let me share a couple thoughts on the motivation and how it might be implemented.

Tudor Golubenco: Postgres webhooks with pgstream

Neues vom PostgreSQL Planet - 27. August 2024 - 2:00
A simple tutorial for calling webhooks on Postgres data and schema changes using pgstream.

Deepak Mahto: Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 5 : Correlated IN Clause Transformation

Neues vom PostgreSQL Planet - 26. August 2024 - 23:36

Welcome to Part 5 of our series exploring the exciting new features anticipated in the official PostgreSQL 17 release. In this series, we delve into newly features and discuss how they can benefit database developers and migration engineers transitioning to the latest version of PostgreSQL.

Grant Fritchey: AWS RDS PostgreSQL Restore to a Point in Time

Neues vom PostgreSQL Planet - 26. August 2024 - 18:05

One of the single biggest reasons to go with a Platform as a Service (PaaS) offering like AWS RDS are the things it does for you, like making it really easy to restore to a point in time. Let’s take a look at it. Restore to a Point in Time When connect up to the […]

The post AWS RDS PostgreSQL Restore to a Point in Time appeared first on Grant Fritchey.

Gabriele Bartolini: CNPG Recipe 12 - Exposing Postgres outside Kubernetes with Service Templates

Neues vom PostgreSQL Planet - 26. August 2024 - 9:38

In this article, I’ll introduce you to the new service template feature in CloudNativePG 1.24, which greatly simplifies the creation of services such as LoadBalancer to expose PostgreSQL outside of your Kubernetes cluster - particularly useful for streamlining Database-as-a-Service (DBaaS) deployments. I’ll walk you through setting up this feature on your laptop using kind and cloud-provider-kind, ensuring you can easily test and implement these capabilities in your own environment.

Radim Marek: Beyond Simple Upserts with MERGE in PostgreSQL

Neues vom PostgreSQL Planet - 25. August 2024 - 2:00

Understanding how comfortable someone is with databases and SQL often comes down to the features they use. In PostgreSQL, one such feature that distinguishes more advanced users is the MERGE command, introduced in version 15 and expanded in version 17 (in beta at the time of writing this article). Before MERGE, developers typically relied on INSERT ... ON CONFLICT DO UPDATE for upserts—a method introduced in PostgreSQL 9.5 that has since become a staple in many developers' toolkits.

Radim Marek: Beyond Simple Upserts with MERGE in PostgreSQL

Neues vom PostgreSQL Planet - 25. August 2024 - 2:00

Understanding how comfortable someone is with databases and SQL often comes down to the features they use. In PostgreSQL, one such feature that distinguishes more advanced users is the MERGE command, introduced in version 15. Before MERGE, developers typically relied on INSERT ... ON CONFLICT DO UPDATE for upserts—a method introduced in PostgreSQL 9.5 that has since become a staple in many developers' toolkits.

cary huang: How to Utilize PostgreSQL’s JSONB APIs as a Simple JSON Parser for Your Extension

Neues vom PostgreSQL Planet - 23. August 2024 - 21:19
Introduction

In your PostgreSQL extension development based on the C language, you may come across a need to work with structured data like JSON. Naturally, you would probably introduce a third-party JSON parsers such as cJSON or libjannson in your extension. While they are powerful, easy to use and offering many features, it may be unnecessary if we weren’t fully utilizing the advanced features of these libraries. Many times, we just want to read a particular value from JSON or simply iterating through it.

Tomas Vondra: Importing Postgres mailing list archives

Neues vom PostgreSQL Planet - 23. August 2024 - 12:00

A couple weeks ago I needed to move my mailing list communication to a different mailbox. That sounds straightforward - go to the community account and resubscribe to all the lists with the new address, and then import a bit of history from the archives so that the client can show threads, search etc.

The first part worked like a charm, but importing the archives turned out to be a bit tricky, and I ran into a bunch of non-obvious issues. So here’s how I made that work in the end.

Gülçin Yıldırım Jelínek: If pg_dump is not a backup tool, what is?

Neues vom PostgreSQL Planet - 23. August 2024 - 2:00
pg_dump was a utility for backing up a PostgreSQL database, not anymore

Hayato Kuroda: PGConf.dev 2024 - New logical replication features in PostgreSQL 17

Neues vom PostgreSQL Planet - 22. August 2024 - 3:00

The PostgreSQL Development Conference 2024 was held earlier this year for the community to nurture the further expansion of PostgreSQL. Fujitsu's OSS team was delighted to give 2 talks in this year's exciting line-up that highlights topics on PostgreSQL development and community growth, featuring stories from users, developers, and community organizers.

Marat Bogatyrev: Handling Cancellation Request

Neues vom PostgreSQL Planet - 20. August 2024 - 18:38
Introduction

PgBouncer is a popular connection pooler for PostgreSQL that helps optimize database performance by reducing the number of open connections and improving overall efficiency. It’s widely used in database clusters as a link between the client and the server and often works alongside different load balancers. However, in some cases, issues with cancellation requests can arise. Let’s explore when this problem occurs and how it can be solved.

Rafia Sabih: Authentication monitoring in PostgreSQL

Neues vom PostgreSQL Planet - 20. August 2024 - 15:21
How about a situation when you want to log all the login attempts made to your PostgreSQL server. Yes, one way would be to read your log files and find out all the information related to login attempts and then transfer to them some other file, etc. to further use this information. Now, this is one way of doing it but it might pose some challenges like time and memory consumption in reading from those long files, additionally this is going to incur a lot of I/O which might be a serious issue when you are on cloud.

semab tariq: PostgreSQL Internals Part 4: A Beginner’s Guide to Understanding WAL in PostgreSQL

Neues vom PostgreSQL Planet - 20. August 2024 - 14:22

In this blog, we'll dive into the concept of Write-Ahead Logging (WAL) in PostgreSQL, discussing its importance and examining the internal structure of WAL files.

The post PostgreSQL Internals Part 4: A Beginner’s Guide to Understanding WAL in PostgreSQL appeared first on Stormatics.

Tomas Vondra: How to pick the first patch?

Neues vom PostgreSQL Planet - 20. August 2024 - 12:00

Picking the topic for your first patch in any project is hard, and Postgres is no exception. Limited developer experience with important parts of the code make it difficult to judge feasibility/complexity of a feature idea. And if you’re not an experienced user, it may not be very obvious if a feature is beneficial. Let me share a couple simple suggestions on how to find a good topic for the first patch.

Andrei Lepikhov: Postgres query re-optimisation in practice

Neues vom PostgreSQL Planet - 19. August 2024 - 3:01

Today's story is about a re-optimisation feature I designed about a year ago for the Postgres Professional fork of PostgreSQL.

Seiten