Install Postgre. SQL 9 on Cent. OS David Ghedini. Install Postgre. SQL 9 on Cent. In this article, I am going to show how to install the latest PostgreSQL 10 database on Linux and BSD distributions. OS. This post will cover installing and basic configuration of Postgre. SQL 9. x on Cent. OS. We will install Postgre. SQL 9 using the Postgre. Ubuntu-11.10-pgAdmin3.png' alt='How To Install Postgresql In Linux Server' title='How To Install Postgresql In Linux Server' />If want to use PostgreSQL but youre unsure where to begin in terms of installation, setup, and management, this primer by Jack Wallen guides you through the. EnterpriseDB Corporate Headquarters 34 Crosby Drive Suite 201 Bedford, MA 01730, USA 1 7813573390 tel 1 9784671307 fax. How to install PostGIS and where to download PostGIS binaries. The next step, keep the port as default The next step, when asked for Locale, I have selected English, United States. It takes a while to install PostgreSQL on. SQL repository and yum. The same procedure can be used to install Postgre. SQL 9 on Red Hat and Fedora using the appropriate rpm. Optionally, well also see how to install Post. GIS. As the directory structure of Postgre. SQL has changed with the release of Postgre. How To Install Postgresql In Linux Server' title='How To Install Postgresql In Linux Server' />SQL 9, we will also look a look at how we can create symlinks to make life easier when installing software or modules that still expect the old directory structure. Finally, for Webmin users, we will see how to configuring Webmin to manage Postgre. SQL 9. I am using Cent. OS 6, but the same procedure works for Cent. OS 5. Finally, if you are using Webmin, we will also show how to configure Webmin to manage Postgre. SQL 9. With the release of Postgre. SQL 9, the directory structure of Postgre. SQL has changed. We will also creating symlinks if needed from the new Postgre. SQL 9 file locations to the previous Postgre. SQL 8 file locations. If you are looking trying to install Postgre. SQL 9 on c. Panel, please see my post here. Well use the simplest method to install, which is the postrgres repo rpms. Download and Install the Postgre. SQL Repository Download the latest production release for your distro here http yum. The repo rpms are 3. Since I am installing on Cent. OS 6 x. 64, I will need http yum. So, using wget wget http yum. Resolving yum. pgrpms. Connecting to yum. HTTP request sent, awaiting response. OK. Length 5. 12. K applicationx redhat package manager. Saving to pgdg centos. Ks in 0s. 2. 01. MBs pgdg centos. Now, install the repo. We now need to edit the Cent. OS Base. repo to exclude postgreql. To do, so we simply edit Cent. OS Base. repo and add excludepostgresql to the base and updates sections rootserver. Cent. OS Base. reporootserver. Cent. OS Base. repo. Cent. OS releasever Base. RPM GPG KEY Cent. OS 6. excludepostgresql Cent. OS releasever Updates. RPM GPG KEY Cent. OS 6. excludepostgresql Now, lets use yum list to check the packages that are now available. Loaded plugins fastestmirror. B 0. 0 0. 0. baseprimarydb 4. MB 0. 0 0. 9. extras 3. B 0. 0 0. 0. extrasprimarydb 1. B 0. 0 0. 0. pgdg. B 0. 0 0. 0. pgdg. B 0. 0 0. 0. updates 3. B 0. 0 0. 0. updatesprimarydb 3. MB 0. 0 0. 0. vz base 9. B 0. 0 0. 0. vz baseprimary 1. B 0. 0 0. 0. vz base 33. B 0. 0 0. 0. vz updatesprimary 1. B 0. 0 0. 0. Available Packages. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. Install Postgre. SQL 9. Using Yum. We can now install Postgre. SQL 9 using yum yum install postgresql. Loaded plugins fastestmirror. Determining fastest mirrors. Setting up Install Process. Resolving Dependencies. Running transaction check. Package postgresql. PGDG. rhel. 6 set to be updated. Package postgresql. PGDG. rhel. 6 set to be updated. Does Not Fully Support Microsoft Office Infopath Forms. Package postgresql. PGDG. rhel. 6 set to be updated. Package postgresql. PGDG. rhel. 6 set to be updated. Finished Dependency Resolution. Dependencies Resolved. Package Arch Version Repository Size. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. M. postgresql. 91 libs x. PGDG. rhel. 6 pgdg. PGDG. rhel. 6 pgdg. M. Transaction Summary. Install 4 Packages. Upgrade 0 Packages. Total download size 5. M. Installed size 2. M. Is this ok yN y. Downloading Packages. PGDG. rhel. 6. x. B 0. 0 0. 2. 24 postgresql. PGDG. rhel. 6. x. MB 0. 0 0. 1. 34 postgresql. PGDG. rhel. 6. x. B 0. 0 0. 0. 44 postgresql. PGDG. rhel. 6. x. MB 0. 0 0. 2. Total 8. Bs 5. 9 MB 0. Running rpmcheckdebug. Running Transaction Test. Transaction Test Succeeded. Running Transaction. Installing postgresql. PGDG. rhel. 6. x. Installing postgresql. PGDG. rhel. 6. x. Installing postgresql. PGDG. rhel. 6. x. Installing postgresql. PGDG. rhel. 6. x. PGDG. rhel. 6. postgresql. PGDG. rhel. 6. postgresql. PGDG. rhel. 6. postgresql. PGDG. rhel. 6. rootserver. Initialize and Start Postgre. SQL 9. 1. We can now initialize and Start Postgre. SQLNOTE when using Webmin, please see Configuring Webmin to Manage Postgre. SQL9 below. rootserver. Initializing database OK. Start the Postgre. SQL server. rootserver. Starting postgresql 9. OK. rootserver. If you encounter startup errors, check under varlibpgsql9. Set Postgre. SQL 9 Environment. The deault home directory for the user postgres is at varlibpgsql. The bashprofile for the user postgres will look like this. PGDATAvarlibpgsql9. This contains a path for the data directory, but no path for the executablebinary directory. To ammend this, add the path as below. PGDATAvarlibpgsql9. PATHPATH HOMEbin usrpgsql 9. PATHPlacing the binary directory in the path for postgres will allow you to invoke pgctl and other commands from the shell. Set postgres Password. The superuser postgres has no password set by default. To set the password, switch to postgres user. Connect as postgres to the postgres database and set the password for user postgres using alter user as below. Type help for help. Configure Postgre. SQL 9 pghba. conf File. Locate your pghba. On installation, your pghba. Put your actual configuration here. If you want to allow non local connections, you need to add more. In that case you will also need to make Postgre. SQL. listen on a non local interface via the listenaddresses. TYPE DATABASE USER ADDRESS METHOD. Unix domain socket connections only. IPv. 4 local connections. IPv. 6 local connections. Allow replication connections from localhost, by a user with the. Change the METHOD to md. TYPE DATABASE USER ADDRESS METHOD. Unix domain socket connections only. IPv. 4 local connections. IPv. 6 local connections. In order for the change to take effect, reload the pghba. As with any command, there are several ways you can reload the pghba. Method 1 From the shell using pgctl reload. Method 2 From psql using pgreloadconf. Type help for help. Method 3 From the shell using c switch to run select pgreloadconf. Password for user postgres. Configure Remote Access for Postgre. SQL 9. Locate the postgresql. Look for CONNECTIONS AND AUTHENTICATION. It will look as below. CONNECTIONS AND AUTHENTICATION. Connection Settings. IP addresses to listen on. By default, access is limited to local machine localhost. To enable remote connections, uncomment listenaddresses and change to as shown below. CONNECTIONS AND AUTHENTICATION. Connection Settings. IP addresses to listen on.