How to Start, Stop, Restart PostgreSQL Database Server on Linux CentOS 6.2 Server

Share this Article :

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 post, i will show the quick steps on how to start, stop, restart and check the status of 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.

Also Read :   How to Check or Test Reverse DNS on Linux and Windows

Start PostgreSQL server :

[[email protected] ~]# /etc/rc.d/init.d/postgresql start
Starting postgresql service:                               [  OK  ]

Stop PostgreSQL server :

[[email protected] ~]# /etc/rc.d/init.d/postgresql stop
Stopping postgresql service:                               [  OK  ]

Restart PostgreSQL server :

[[email protected] ~]# /etc/rc.d/init.d/postgresql restart
Stopping postgresql service:                               [  OK  ]
Starting postgresql service:                               [  OK  ]

Check PostgreSQL server status :

[[email protected] ~]# /etc/rc.d/init.d/postgresql status
postmaster (pid  6129) is running...

Leave a Reply