PostgreSQL

CentOS vs Rocky Linux Benchmark with PostgreSQL

In December 2020, you might have seen an article from CentOS about shifting their focus towards CentOS stream, which is the upstream version of the RHEL. CentOS also mentioned that the version 8 would be EOL (end of life) by the end of the 2021. This means that it will no longer receive any updated fixes from it’s …

CentOS vs Rocky Linux Benchmark with PostgreSQL Read More »

Announcing Credcheck extension to enforce username and password checks in PostgreSQL

PostgreSQL includes robust security standards around all aspects such as authentication, authorization, accounting and auditing. User management and role based segregation that satisfy enterprise standards can be implemented at ease. Similarly, organizations may be willing to enforce certain compliance around the password standards such as the minimum upper case characters or minimum number of numbers and special characters …

Announcing Credcheck extension to enforce username and password checks in PostgreSQL Read More »

Ora2PG now supports oracle_fdw to increase the data migration speed

It has been 20 Years since i have been maintaining the Ora2Pg project, an Open Source software for Oracle to PostgreSQL migrations. The first version of Ora2Pg released on 9th May, 2001. Since then, there have been several features related to schema conversions and data migrations. Over a period of time, i have witnessed several tens of thousands …

Ora2PG now supports oracle_fdw to increase the data migration speed Read More »

Global Temporary Table in PostgreSQL

One of the common problems while migrating from Oracle to PostgreSQL is the need of Global Temporary Tables in PostgreSQL (GTT). There is no PostgreSQL equivalent for global temporary tables. Due to this reason, I have originally started the developed of an extension called : PGTT, to reduce the overall efforts involved while migrating from Oracle to PostgreSQL. …

Global Temporary Table in PostgreSQL Read More »

Porting Array length from Oracle PLSQL to PostgreSQL PLPGSQL

Migrating Oracle PL/SQL code to PostgreSQL PL/pgSQL requires a deeper understanding of the behavior in both Oracle and PostgreSQL databases. It is not only the syntax but also the behavior that is very important. Else, upon porting the PL/SQL code to PL/pgSQL, we may encounter some strange application behaviors that are difficult to trace. We would like to …

Porting Array length from Oracle PLSQL to PostgreSQL PLPGSQL Read More »

CHAR(1) to Boolean transformation while migrating to PostgreSQL

PostgreSQL supports a wide variety of data types when compared to a few commercial databases like Oracle. For performance benefits, it may be wise to choose the optimal data types supported in PostgreSQL, instead of choosing the same ones as the source, while migrating from another database. In this article, we are going to discuss one such case …

CHAR(1) to Boolean transformation while migrating to PostgreSQL Read More »

How difficult is to create a database software like PostgreSQL ?

Recently on twitter, i have seen a poll by Qovery asking how hard is it to create a database like PostgreSQL. With no surprise, people mostly voted it as “Very hard”. However, the word “like” in this question is very ambiguous, as rightly said in one of the comments by Dave Cramer, who is one of the very …

How difficult is to create a database software like PostgreSQL ? Read More »

pgBackRest – The Best Postgres Backup Tool with a very active community

A reliable backup tool with an ability to perform a point in time recovery (PITR) is a usual enterprise need. Postgres includes a backup tool called pg_basebackup for full backups. It is great for a database of a few hundreds of GBs in size but currently lacks the support for parallel, incremental and differential backups. This makes it …

pgBackRest – The Best Postgres Backup Tool with a very active community Read More »

Setting up Streaming Replication in PostgreSQL 13 and Streaming Replication Internals

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, …

Setting up Streaming Replication in PostgreSQL 13 and Streaming Replication Internals Read More »

Handling Global Associative Arrays in PostgreSQL

While migrating from Oracle to PostgreSQL, most of the developers ask about the options available in Handling Global associative arrays in PostgreSQL. It might get challenging if the variables need to be accessible in the Exception block. To avoid developers from finding it difficult while performing conversions of PL/SQL from Oracle to PostgreSQL, we are writing this blog …

Handling Global Associative Arrays in PostgreSQL Read More »

Scroll to Top