Posts

Brief Introduction of PostgreSQL Database

Introduction: PostgreSQL, often referred to as Postgres, is a powerful and widely-used open-source relational database management system (RDBMS). It is renowned for its robustness, reliability, and extensive feature set. In this article, we will delve into the key aspects of PostgreSQL, exploring its architecture, features, benefits, and use cases. Architecture and Core Features: PostgreSQL follows a client-server model, where multiple clients can connect to a single PostgreSQL server simultaneously. Its architecture consists of a backend process (server) that manages data storage, query processing, and transaction management, while the clients interact with the server using various programming interfaces. Core features of PostgreSQL include: ACID compliance: PostgreSQL ensures Atomicity, Consistency, Isolation, and Durability, making it suitable for critical applications that require data integrity. Extensibility: It supports the creation of custom data types, functions, and operators...
Post a Comment
Read more

Ora2pg Mirgation Tool

Image
 Introduction Ora2pg tool is open source tool used for migration of oracle databases to PostgreSQL database. This tools works at schema level, meaning that it does not convert/ migrate whole oracle database to PostgreSQL, instead it converts/ migrates one schema at a time. Hence if you have a database having four different schema/ users, you have to run this tool for each schema separately.  Ora2pg can be used in variety of scenarios like severe engineering of oracle databases to migration of large scale databases, or migrating data of oracle tables to PostgreSQL. It is user friendly and does not require any expertise to migrate your oracle databases to PostgreSQL. It only requires some configurations in its two configuration files and then run couple of commands to migrate the oracle schema to PostgreSQL. Features Migrate schema which objects (tables, views etc). Export partitions and their sub-partitions. Export data of tables Support for exporting Oracle BLOB obje...
Post a Comment
Read more

Oracle vs PostgreSQL Comparison

   The War has began Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. What’s causing this massive shift? This all is happening due to rise of open source databases. One database in particular is causing a huge dent in Oracle’s market share – open source PostgreSQL. When comparing the two solutions, things to consider are: How easier to use it is, How easily you can setup and administer database How much this database fulfills your requirements How much performance efficient it is How much you have to pay for it How much support is available over the internet How much availability it gives to you Is your data secure inside this database And many more….. Below table compares both databases feature wise and gives a good hint to ...
Post a Comment
Read more

How to Install PostgreSQL on Linux

   Installation of PostgreSQL on Linux In this article, you will learn how to install PostgreSQL on Linux using rpm packages. Most Linux platforms such as Debian, Oracle Linux, Red Hat / CentOS, SUSE, and Ubuntu have PostgreSQL integrated with their package management. It is recommended that you install PostgreSQL this way since it ensures a proper integration with the operating system including automatic patching and other update management functionality. In this tutorial, we’ll show you how to install PostgreSQL on Oracle Linux version 8.2 Installation using RPMS: Below URL can be used to download rpms of PostgreSQL version 15.1 for Linux platforms. https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-8.2-x86_64/ For smooth installation, below listed rpms are required: postgresql15-devel-15.1-1PGDG.rhel8.x86_64.rpm  postgresql15-contrib-15.1-1PGDG.rhel8.x86_64.rpm  postgresql15-libs-15.1-1PGDG.rhel8.x86_64.rpm postgresql15-server-15.1-1PGDG.rhel8.x86_64.rpm...
Post a Comment
Read more

How to Upgrade PostgreSQL on Linux

How to Upgrade a PostgreSQL Database     In this article, we will explain , How to upgrade from postgres 13 to postgres 15.1 version. This will be considered as major upgrade. Minor upgrade is like upgrading from 9.5 version to 9.7 version. For minor upgrade, You just need to upgrade the rpms. Which We will do that in another article. Database Upgrade Steps: 1. Download Latest RPMs Below URL can be used to downlaod rpms for PostgreSQL version 15.1 for Linux x86_64 Platforms https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-8.2-x86_64/ Our required rpms are listed below:   postgresql15-libs-15.1-1PGDG.rhel8.x86_64.rpm postgresql15-devel-15.1-1PGDG.rhel8.x86_64.rpm postgresql15-15.1-1PGDG.rhel8.x86_64.rpm    postgresql15-contrib-15.1-1PGDG.rhel8.x86_64.rpm  postgresql15-server-15.1-1PGDG.rhel8.x86_64.rpm  Make sure to install the rpms in below sequence only. Otherwise you will dependency errors. [root@postgredb pg_13]# yum localinstall   ...
Post a Comment
Read more

Introduction to PostgreSQL

Image
  Introduction to PostgreSQL PostgreSQL is a flexible open-source object relational database management system. DB-engine ranks PostgreSQL as number 4 in its list (including both open source and proprietary) as of Jan 2023. PostgreSQL can handle a huge variety of use cases, from single machines to data warehouses to web services with many concurrent users. PostgreSQL is strongly supported by its global development group of companies and individual contributors. PostgreSQL's unusual name causes some readers to stop and try to spell it, especially those who pronounce SQL "sequel". The PostgreSQL developer spelt it "post-gress-q-l". It is also often abbreviated as "Postgres". PostgreSQL allows users to define new types based on formal SQL types, allowing the database to understand complex data itself. For example, you can define an address to combine strings of things such as street numbers, cities, and countries. From this point you can easily create a t...
1 comment
Read more