Postgres Archive

25 Jan 2014

how to install pgadmin3 on centos 6.2

Summary: In this post i am trying to explain how to install pgadmin3 on centos server. I have install pgadminIII on cenots 6.2 successfully. I faced a dependency issue during installation and resolve it. procedure are listed
14 Jan 2014

Install Sphinx 2.0.2 with Postgresql support on Redhat 5.6 Cloud Server

Summary: In this article i will explain how to install sphinx 2.0.2 the updated version on Redhat 5.6 cloud server with postgresql support. As i have already explain in previous articles about command and configurations file. So
14 Jan 2014

Error PostgreSQL connection limit exceeded for non-superusers resolved

Summary: When You transferred the Database from one server to another and try to connect from your client you will have issue to connect to postgres server that PostgreSQL connection limit. We have discuss the issue in
14 Jan 2014

How to Install Sphinx 2.0.2 on CentOS-5.2 PostgreSQL

Summary: We have explain in earlier articles how to install sphinx on ubuntu and then configure it with postgresql. In this article I am going to explain how to install sphinx 2.0.2 on CentOS. Follow the Steps
14 Jan 2014

How to Create Database Backup and restore using pg_dump postgresql

Summary: I tried to explain how to create database backup with pg_dump and restore the database in posgresql. To create dump file as a backup from postgresql follow the simple commands below: Pg_dump is an easy way
13 Jan 2014

create postgres database and user from command line

Summary: In this article I tried to explain how to create database, database user in postgresql through terminal commands. These are some basic steps to follow for newbie how to use postgres database! 1:- Create database: First
13 Jan 2014

How to use Sphinx with Postgresql on ubuntu 10.10

Summary: In Previous article we have explain how to install sphinx search on ubuntu with postgresql support and in this article we are trying to explain how to use the sphinx search with postgresql. Step-1. Create database in
13 Jan 2014

how to install Sphinx Search on Ubuntu 10.10 with PostgreSQL

 Summary: Sphinx is GPL v-2 Commercial Licensing full-text search engine. I have tried to explain how to install sphinx on ubuntu server with Postgresql Database. Sphinx is used for creating big data indexes. The supporting Databases are
12 Jan 2014

Manually Creating Backup Postgresql From Terminal CentOS

Summary:In this post i have tried to explain, how to take a manual database backup postgresql from terminal through commands. Environment: Operating System: CentOS-6.3 Data-Base: Postgresql-8.4 Follow the steps listed below. Step-1: Connect to your server through