Below are ours server , xlog & archive details PRIMARY / MASTER: ================ postgres@tutorialdba_1:> ps -ef|grep postgres postgres 4436 1 0 Jun25 ? 00:05:04 /opt/10.6/bin/postgres -D /data postgres 4437 4436 0 Jun25 ? 00:00:00 postgres: logger process postgres 4439 4436 0 …
Ora2Pg is a free tool used to migrate an Oracle or MySQL database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database. ora2pg version 20.0 software : …
In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. Ora2Pg is a free tool used to migrate an Oracle or MySQL database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, …
In this tutorial, we will show you how to install PostgreSQL by using source code/RPM on your local system for learning and practicing PostgreSQL. PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can …
In this tutorial, we will show you how to install PostgreSQL by using source code on your local system for learning and practicing PostgreSQL. PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can …
In this tutorial, we will show you how to install PostgreSQL on your local system for learning and practicing PostgreSQL. PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can also run on other …
In this tutorial i will explained about how to enable archivelog in postgresql server WAL Archive log In PostgreSQL database system, the actual database ‘writes’ to an addition file called write-ahead log (WAL) to disk. It contains a record of …
To keep 7 days of logs, one log file per day named postgresql-Mon.log, postgresql-Tue.log, etc, and automatically overwrite last week’s log with this week’s log. logging_collector=on log_filename = ‘postgresql-%a.log’ log_directory = ‘log’ log_rotation_age = 1d log_truncate_on_rotation=on
In this blog we are telling about How to do oracle schema referesh from production to DEV & SIT environment. Right now we are taking backup of umar schema after that we can restore the schema to SIT & DEV …
I. TAKING TABLE STRUCTRE BACKUP WITH THEIR’S OBJECT FILE NAME : Below scripts helpful to take backup (DDL’s) of procedure, function & table definition with individual file system (object name) based on postgres schema . 1. Windows Script for taking …
unable to restart the postgres server after enabling archivelog , we are getting below error while restarting the postgresql database . Below steps are we followed to enable archiver. archive_mode =on # enables archiving; off, on, or always # (change …
In this blog we are going to upgrade the postgresql server from 9.5 to 11.3 . We are upgraded the postgres server by using pg_upgrade utility as well as logical backup method , you can follow anyone of the method …
# ./configure –prefix=/opt/postgresql/11.3/ checking build system type… x86_64-pc-linux-gnu checking host system type… x86_64-pc-linux-gnu checking which template to use… linux checking whether NLS is wanted… no checking for default port number… 5432 checking for block size… 8kB checking for segment size… …
In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. After installing ora2pg tool, we will see how to configure and to run it to migrate our data. We are using an oracle 12C …
This script can be used to check on postgres apache,mysql, or whatever service you want. This is not meant to be a SOLUTION to services that are crashing, but rather a notification and a temporary restart until you can solve …
Login with Google