How to Install PostgreSQL 9.2 on CentOS 6.3
This quick post shows the basic steps to install PostgreSQL Database Server (PostgreSQL 9.2) on CentOS 6.3. This steps has been tested using CentOS 6.3. However, It may works on…
How to Install phpPgAdmin for Managing PostgreSQL Databases on CentOS 6.2
phpPgAdmin is a web application, written in PHP and web-based administration utility for managing PostgreSQL databases. It handles all the basic functionality as well as some advanced features such as…
How to Change PostgreSQL Log Format on CentOS 6.2
In this post, i will show the quick step to change log format for PostgreSQL on linux CentOS 6.2 server. PostgreSQL is a Sophisticated open-source Object-Relational DBMS supporting almost all…
How to Configure PostgreSQL to Listen from Any IP Address on CentOS 6.2
PostgreSQL is a Sophisticated open-source Object-Relational DBMS supporting almost all SQL constructs, including subselects, transactions, and user-defined types. PostgreSQL is a powerful, open source object-relational database system that available for…
How to Start, Stop, Restart PostgreSQL Database Server on Linux CentOS 6.2 Server
PostgreSQL is a sophisticated open-source Object-Relational DBMS supporting almost all SQL constructs, including subselects, transactions, and user-defined types. PostgreSQL is a powerful, open source object-relational database system that available for…
Question : When i typing service postgresql start as root on linux CentOS 6.2 server, i got the following error message : [root@centos62 ~]# service postgresql start /var/lib/pgsql/data is missing….
How to Install PostgreSQL Database Server on Linux CentOS 6.2 Server
PostgreSQL is a Sophisticated open-source Object-Relational DBMS supporting almost all SQL constructs, including subselects, transactions, and user-defined types. PostgreSQL is a powerful, open source object-relational database system that available for…
How to Fix “ERROR : Could not find tsearch2.sql file” While Starting the PostgreSQL Database
I would like to share with you the simple step to fix below error when trying to start or configuring the postgresql database. This was tested on CentOS 5.5 x86_64…
How to Fix “An old version of the database format was found” While Starting PostgreSQL
I would like to share with you on how to fix “An old version of the database format was found” While Starting PostgreSQL server. This error usually happen after we…