Install Postgre. SQL 9 on Cent. OS David Ghedini. Install Postgre. SQL 9 on Cent. 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. 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. 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. Install Only X86_64 Yum' title='Install Only X86_64 Yum' />yum y install postgresql. Uninstall a package using yum remove. To remove a package along with all its dependencies, use yum remove package as. 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. Global Graduate Training Programs'>Global Graduate Training Programs. 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. Once this triggers, you will have an entry with the logging text WARNING PALO ALTO LOGIN ATTEMPT in the log for elasticsearch located at varlogelasticsearch. We can now install PostgreSQL 9 using yum yum install postgresql91 postgresql91devel postgresql91server postgresql91libs postgresql91contrib. Install Only X86_64 Yum' title='Install Only X86_64 Yum' />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. 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. 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. Bejeweled 3 For Mac Crack. 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. How do you install Node. JS on Cent. OS I went thru the task of doing this installation myself on RHEL 5. Unfortunately, with nodejs. However, the build process got quite a bit complicated as the build script involves python code that doesnt work with the default version of Python on RHEL. After a lot of trial and error and a lot of googling, I found this blog post which basically describes a step to step on the following tasks required. Install Python 2. Setup that version of python as an alternate version, then setting it as default. Switching Python back to the default 2. The key is that you should switch back to Python 2.