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 …
Try following script , This script will take mysql database backup automatically and remove the old backup file which is over 3 days and once backup is completed means it will send mail confirmation If you know the mysql root password you …
This script can be used to check on mariaDB, apache2, 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 …
Respected Sir/madam, This is Nijamutheen , I have 6+ years of experience in PostgreSQL database administrator as well as PostgreSQL Architect , Linux admin , web hosting – apache server , Oracle ,mySQL, Mriadb, MSSQL & Server security as well …
The benefit of a synchronous PostgreSQL replication over an asynchronous is that in case of master PostgreSQL database server failure you are sure you did not lose any data. The database client connected to the master PostgreSQL database gets a …
I have a table name is nijam, that table contains 63017 records and have csv excel data contains 586128 records so want to append the data in nijam table for this task you have to following below steps Sample DATA …
Postgres by BigSQL includes the PostGIS extension, version 2.2 & 2.3, a powerful open source spatial and geographic data management package. PostGIS enables mapping, distance calculations, and geometry functions such as identifying if a point is within a polygon. Install …
In this shell script will be helpful for monitoring RAM usage,DISK size,how many queries is running more than 5 minutes in a postgres cluster and how many dead tuble is occurred particular database in cluster, How to create & run …
Difference between View vs Materialized View in database Based upon on our understanding of View and Materialized View, Let’s see, some short difference between them : 1) The first difference between View and materialized view is that In Views query …
Below steps will be helpful to improve your postgres database performance so faster than earlier. First you have to issue the top command then see the process which one process is taking more CPU utilization then note that PID, if that is postgres …
You can use INSERT INTO statement by selected specific table column or use * for selecting all column dblink also will server purpose even if it is remote database.. with condition X server is able to reach Y. # you can …
In this post, i will explain how to setup a streaming replication with PostgreSQL 10. I will explain how to install PostgreSQL 10 on your system and how to monitor the postgres replication server and how many ways is there …
PostgreSQL 10.3 installation steps: In this tutorial i will explain how to install postgreSQL 10 on Red Hat Enterprise Linux Server release 7.3 Beta (Maipo),How to make network configuration and linux partition for DATA,ARCHIVE,BACKUP, and how to configure postgreSQL cascading …
I am facing one issue. I have 3 IP. 1,2 are master and slave and 3 for pgpool. My application direct hit to 3 ,and 3 distribute the connection between master and slave. But in my web application have one …