Saturday, July 9, 2016

postgres: How to install posgresql-server with yum on Linux

If you have a RedHat/CentOS/OracleLinux distro of Linux, then yum should be available as your package manager. Here are the notes I have to get PostgreSQL server up running.

bash> yum info postgresql-server
bash> # Verify that's the version you want to install

bash> # Ready to install
bash> sudo su -
bash> yum -y install postgresql-server
bash> service postgresql initdb

bash> # Startup the server manually
bash> service postgresql start

bash> # Make server startup at system reboot
bash> chkconfig postgresql on

bash> # Verify postgres DB is working
bash> su - postgres -c psql
postgres=# \du
postgres=# \q

bash> # We are done, exit root user shell
bash> exit

If you can't find service or chkconfig commands, then check to ensure you have have /sbin in your $PATH.


  1. This comment has been removed by the author.

  2. Hii your blog is looking good.Thanks for sharing this information and keep posting.
    For web design & development service contact Multisoft digital technologies, They have
    Web Development in Hebbal

  3. Very good article,Thank you
    For sofa renovation contact thesofastore they gives best
    Best Sofa Repair Services in Bommanahalli,Bangalore

  4. Nice blog with good content, thanks for sharing.
    For sofa repair work contact thesofastore gives
    Best Sofa Repair Services in Jayanagar,Bangalore

  5. I'm a fan of this essay because of the excellent writing and the properly researched subject. I was so captivated by this book that I was unable to put it down. I'm amazed by your talent and work. Huge gratitude. I just went to a blog that was Best Online Random Number Generators. Visit random number generator to read the entire article and post your comments.