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

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 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.
Start PostgreSQL server :


[root@kosecurity.in~]# /etc/rc.d/init.d/postgresql          start
Starting postgresql service:                                                     [ OK ]


Stop PostgreSQL server :


[root@kosecurity.in~]# /etc/rc.d/init.d/postgresql           stop
Stopping postgresql service:                                                   [ OK ]


Restart PostgreSQL server :


[root@kosecurity.in~]# /etc/rc.d/init.d/postgresql   restart
Stopping postgresql service:                                            [ OK ]
Starting postgresql service:                                              [ OK ]


Check PostgreSQL server status :


[root@kosecurity.in~]# /etc/rc.d/init.d/postgresql       status
postmaster (pid 6129) is running…


Posted By Nijakat Ali

Be the first to comment

Leave a Reply

Your email address will not be published.


*