pg_dump issue while taking postgresql database dump

You might have face below issue or exception when you are taking dump of postgresql server.

pg_dump: server version: 9.4.4; pg_dump version: 9.2.13
pg_dump: aborting because of server version mismatch


In this case follow the below steps to resolve the issue.

Step 1: Install the postgresql new version.
yum install postgresql94

#This will add missing packages.


Step 2: Execute the pg_dump command with new version.
/usr/bin/pg_dump94 -h <hostname> -U <username> -W<db-name>   > file.sql
prompt for password