Blog

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 …

PostgreSQL COPY data to Text File In this post you can learn how to take the backup of particular table by using Postgres COPY command. Examples: Step1. First list down the table and and describe the table data  which one …

Following steps will be helpful to improve the performance of Postgres database : 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 process means …

In this post, I am sharing few important function for finding the size of database, table and index in PostgreSQL. Finding object size in postgresql database is very important and common. Is it very useful to know the exact size …

Here i expalined that””How to increase the performance  postgresql server and i written script for vacuum database and changing PostgreSQL performance  parameter cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.0 (Maipo) bash-4.2$ Checking the master and slave IP and …

Finding the Missing Records between two tables : I. creating table structure for excel sheet table data’s , table name as temp. II. Restore the Excel data on temp table then count the total records .  Steps for Postgres COPY : …

While Importing CSV files with text fields that contain double quotes using postgres COPY . By following steps you can neglect the double quotes at the time of using postgres COPY restoration 1. connecting windows server D: cd D:\PostgresPlus\9.4AS\bin psql …

In this blog will be helpful to solve the problem of data partition once full how to solve the problem with less down time and what are steps want to follow for data partition full . postgres data partition full …

In this blog will be helpful to schedule vacuum script for postgres database by using crontab and you can monitor the postgres database dead tuble rows  by following script as per the dead tuble you can shedule vacuum by daily …

vacuum_and_analyze.sh script vacuums and analyzes all the database of an instance. Script pick the instance on the basis of details provided in cronjobs_conf_5432.sh. If you have multiple instances, and you want to run vacuum_and_analyze.sh for those instances too, by tweaking …

It is one of the maintenance activity in postgres , once you moved your logs means you will get some more free space at data partition .simple logic is postgres logs is inside the data directory. following script will be …

In this script will be helpful to move & compress your archive files to some other partition  , it will be used at the time of bulk restore and  data partition full or archive partition full. it is one of …

In this blogs will be helpful to how to create database in Postgresql environment and how to do restore the database and what are the common errors you will be faced during database restoration  example for xlog full , not …

This is the Basic Key notes of PostgreSQL PEM (EDB Postgres Enterprise Manager) 1.  Hardware Pre-Requisites For optimum speed when monitoring servers and rendering dashboards, we recommend installing PEM on a system with at least: 4 CPU cores 8 GB …

what is the postgresql Streaming Replication (SR) ? Streaming Replication (SR) provides the capability to continuously ship and apply the WAL XLOG records to some number of standby servers in order to keep them current. This feature was added to …