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 […]

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 […]

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 […]

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 […]