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 many platforms including Linux, FreeBSD, Solaris, Microsoft Windows, and Mac OS X.
In this howto, I will show the quick steps on how to start, stop, restart and check the status of the PostgreSQL database server on linux CentOS 6.2 server. This steps may working on other version such as CentOS 5.1, CentOS 5.2, CentOS 5.3, CentOS 5.4, CentOS 5.5, CentOS 5.6, CentOS 5.7, CentOS 6.0 and CentOS 6.1.
Start PostgreSQL server :
[root@centos62 ~]# /etc/rc.d/init.d/postgresql start Starting postgresql service: [ OK ]
Stop PostgreSQL server :
[root@centos62 ~]# /etc/rc.d/init.d/postgresql stop Stopping postgresql service: [ OK ]
Restart PostgreSQL server :
[root@centos62 ~]# /etc/rc.d/init.d/postgresql restart Stopping postgresql service: [ OK ] Starting postgresql service: [ OK ]
Check PostgreSQL server status :
[root@centos62 ~]# /etc/rc.d/init.d/postgresql status postmaster (pid 6129) is running...