Install PostgreSQL 9 on CentOS. This post will cover installing and basic configuration of PostgreSQL 9. CentOS. We will install PostgreSQL 9 using the PostgreSQL. To add the apt repository, first create the file etcaptsources. On Ubuntu Systems On Ubuntu 1. On Ubuntu 1. 6. 0. On Ubuntu 1. 4. 0. On Debian Systems On Stretch 9. On Jessie 8. x. On Wheezy 7. Install Postgres In Red Hat Linux 7' title='Install Postgres In Red Hat Linux 7' />You can login to a remote Linux server without entering password in 3 simple steps using sskykeygen and sshcopyid as explained in this article. Then import the repository signing key, and update the system package lists like this. O https www. ACCC4. CF8. asc sudo apt key add. Add Postgre. SQL Key. Install Postgre. SQL Server. Once you have added the Postgre. SQL apt repository in your respective Linux distribution, now install Postgre. SQL server and client packages as follows sudo apt install postgresql 9. Install Postgresql Database Server. Important Unlike in RHELCent. OSFedora where you have to manually initialize the database system, in UbuntuDebian, it is initialized automatically. Therefore simply proceed to start database server as described in the next section. The Postgre. SQL data directory varlibpostgresql9. Start and Enable Postgre. SQL Server. With the database server initialized, start Postgre. SQL service and enable Postgre. SQL service to auto start on system boot like this. On System. D. On Sys. Vinit. Start and Enable Postgre. SQL Database. Verify Postgre. SQL Installation. After installing Postgre. SQL database system on your server, verify its installation by connecting to postgres database server. The Postgre. SQL administrator user is named as postgres, type this command to access the user system account. Verify Postgre. SQL Database. To set a password for the postgre database administrator user, use this command postgres password postgres. Set Password for Postgre. SQL Admin. To secure the postgre user system account, use the password command below. Enter new UNIX password. Retype new UNIX password. Set Password for Postgre User. For more information, go to the Postgre. SQL Homepage https www. Lastly, also read through these articles about popular database management systems Installing Maria. DB 1. 0. 1 in Debian Jessie and Running Various Maria. DB Queries. How to Change a Default My. SQLMaria. DB Data Directory in Linux. How to Install and Secure Maria. DB 1. 0 in Cent. OS 7. How to Install and Secure Maria. DB 1. 0 in Cent. OS 6. Install Mongo. DB Community Edition 3. Linux Systems. Thats all for now To share any thoughts with us, make use of the feedback form below. Remember to always stay connected to Tecmint. Install Postgres In Red Hat Linux 7© 2017