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