How to Upgrading PostgreSQL 9.2 to 12

Postgresql 9 to 12

24 June 2022   0 Comment

That’s a Tutorial for upgrading the PostgreSQL9 database on CentOS 7 server. In order for your database to be properly patched, secured, and have all the DB features your applications need, you are supposed to upgrade your database. The upgrade process in this article installs another PostgreSQL engine alongside the old one and migrates the […]

Read More

How to use Ora2pg for Oracle to Postgres Migration

ora2pg oracle to postgres

15 June 2022   0 Comment

We will review Ora2pg, great open source solution for migrations to PostgreSQL. All companies have requests to migrate their small databases to postgres. Ora2pg is a great utility full of features. Prerequisites Oracle clientOracle DatabasePostgres DatabasePerl modules DBI DBD:Oracle DBD:PG Latest version of ora2pg Establish You can install oracle client for first connection Or rpm […]

Read More

How To Install PostgreSQL 12 Streaming Replication Master/Slave(Synchronous / Asynchronous) on the CentOS 7

PostgreSQL Streaming Replicatiıon master slave Installation big dba

2 February 2021   0 Comment

Using High Availability is a requirement for companies all over the world. Stream Replication as the replication method, PostgreSQL Stream Replication is asynchronous by default, so it is possible to do some operations on the primary node that have not yet been copied to the standby server. This means there is some potential possibility of […]

Read More

How to Installation PostgreSQL 12 on Redhat and Centos 6,7 Linux


25 November 2019   1 Comment

PostgreSQL 12 An open-source object is a relational, highly scalable, SQL-compliant database management system. PostgreSQL was developed at the University of California at the Berkeley Computer Science Department. This article will help you install PostgreSQL 12 on a CentOS / RHEL 7/6 system. CentOS’s default repositories contain postgresql packages, so we can install them seamlessly […]

Read More