{"id":729,"date":"2015-04-21T02:37:41","date_gmt":"2015-04-21T11:37:41","guid":{"rendered":"http:\/\/blog.box.kr\/?p=729"},"modified":"2015-04-21T02:37:41","modified_gmt":"2015-04-21T11:37:41","slug":"install-postgresql-on-centos7","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=729","title":{"rendered":"install PostgreSQL on CentOS7"},"content":{"rendered":"<p>1.\u00a0Install ( \u00a02015-04-21 &gt; \ucd5c\uc2e0 \ubc84\uc804\uc740 9.4\u00a0 )<\/p>\n<blockquote><p>[root@localhost ~]# rpm -Uvh http:\/\/yum.postgresql.org\/9.4\/redhat\/rhel-7-x86_64\/pgdg-centos94-9.4-1.noarch.rpm<br \/>\nhttp:\/\/yum.postgresql.org\/9.4\/redhat\/rhel-7-x86_64\/pgdg-centos94-9.4-1.noarch.rpm(\uc744)\ub97c \ubcf5\uad6c\ud569\ub2c8\ub2e4<br \/>\n\uacbd\uace0: \/var\/tmp\/rpm-tmp.z0BMz8: Header V4 DSA\/SHA1 Signature, key ID 442df0f8: NOKEY<br \/>\n\uc900\ube44 \uc911&#8230;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ################################# [100%]<br \/>\nUpdating \/ installing&#8230;<br \/>\n1:pgdg-centos94-9.4-1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ################################# [100%]<br \/>\n[root@localhost ~]# yum install postgresql94 postgresql94-server postgresql94-libs postgresql94-contrib postgresql94<br \/>\nLoaded plugins: fastestmirror, langpacks<br \/>\nhttp:\/\/linuxdownload.adobe.com\/linux\/x86_64\/repodata\/repomd.xml: [Errno 14] curl#6 &#8211; &#8220;Could not resolve host: linuxdownload.adobe.com; \uc774\ub984 \ud639\uc740 \uc11c\ube44\uc2a4\ub97c \uc54c \uc218 \uc5c6\uc2b5\ub2c8\ub2e4&#8221;<br \/>\nTrying other mirror.<br \/>\nhttp:\/\/mirror.oasis.onnetcorp.com\/centos\/7.1.1503\/os\/x86_64\/repodata\/repomd.xml: [Errno 12] Timeout on http:\/\/mirror.oasis.onnetcorp.com\/centos\/7.1.1503\/os\/x86_64\/repodata\/repomd.xml: (28, &#8216;Resolving timed out after 30383 milliseconds&#8217;)<br \/>\nTrying other mirror.<br \/>\nbase\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 3.6 kB\u00a0 00:00:00<br \/>\nepel\/x86_64\/metalink\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 | 4.4 kB\u00a0 00:00:00<br \/>\nepel\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 4.4 kB\u00a0 00:00:00<br \/>\nextras\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 3.4 kB\u00a0 00:00:00<br \/>\n.<br \/>\n.<br \/>\n.<\/blockquote>\n<p>2. Configure<\/p>\n<blockquote><p>Initialize the PostgreSQL.<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">[root@itzgeek~\/]# \/usr\/pgsql-9.4\/bin\/postgresql94-setup initdb<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>PostgreSQL normally listens on the localhosts only, if would you like to enable the PostgreSQL to listen on all ip addresses; edit the \/var\/lib\/pgsql\/9.1\/data\/postgresql.conf .<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">[root@itzgeek~\/]# vi \/var\/lib\/pgsql\/9.4\/data\/postgresql.conf<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Go to Connections and Communications section, find the \u201clisten_address\u201d variable. Uncomment the \u201clisten_addresses\u201d and place \u201c*\u201d instead of \u201clocalhost\u201d<\/p>\n<p><strong>Before editing:<\/strong><\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">#listen_addresses = \"localhost\"<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><strong>After editing:<\/strong><\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">listen_addresses = \"*\"<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Add your network to access <a href=\"http:\/\/www.itzgeek.com\/tag\/database\" target=\"_blank\">database <\/a>remotely; Edit\u00a0 \/var\/lib\/pgsql\/9.4\/data\/pg_hba.conf.<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">[root@itzgeek~\/]# \u00a0vi \/var\/lib\/pgsql\/9.4\/data\/pg_hba.conf<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Add the following line according to your network configuration with md5 password authentication (Enable remote access of database).<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\"># IPv4 local connections:\nhost\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 127.0.0.1\/32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5\nhost\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 107.155.94.0\/24\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5\n# IPv6 local connections:\nhost\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ::1\/128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 md5<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Restart the PostgreSQL server.<\/p><\/blockquote>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">[root@itzgeek~\/]# systemctl start postgresql-9.4.service<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Confirm the PostgreSQL listening.<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">[root@itzgeek ~\/]# netstat -antup | grep 5432\ntcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0.0.0.0:5432\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.0.0.0:*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTEN\u00a0\u00a0\u00a0\u00a0\u00a0 39620\/postgres\ntcp6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 :::5432\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :::*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTEN\u00a0\u00a0\u00a0\u00a0\u00a0 39620\/postgres<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Auto start the service on startup.<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">[root@itzgeek~\/]# systemctl enable postgresql-9.4.service<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h4><strong>Creating Database:<\/strong><\/h4>\n<p>Login as postgres user.<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">[root@geeksite~\/]$ su -l postgres<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>create the database called \u201ctest\u201d<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">-bash-4.2$ createdb test<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Login into the database.<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">-bash-4.2$ psql test<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Create a new user called \u201craj\u201d to manage the databases.<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">test=# CREATE USER raj WITH SUPERUSER LOGIN PASSWORD 'raj';<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Login with the superuser.<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"dos\">sam@geeksite~\/$ psql -h localhost -d test -U raj<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>That\u2019s all!. You have successfully installed<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.\u00a0Install ( \u00a02015-04-21 &gt; \ucd5c\uc2e0 \ubc84\uc804\uc740 9.4\u00a0 ) [root@localhost ~]# rpm -Uvh http:\/\/yum.postgresql.org\/9.4\/redhat\/rhel-7-x86_64\/pgdg-centos94-9.4-1.noarch.rpm http:\/\/yum.postgresql.org\/9.4\/redhat\/rhel-7-x86_64\/pgdg-centos94-9.4-1.noarch.rpm(\uc744)\ub97c \ubcf5\uad6c\ud569\ub2c8\ub2e4 \uacbd\uace0: \/var\/tmp\/rpm-tmp.z0BMz8: Header V4 DSA\/SHA1 Signature, key ID 442df0f8: NOKEY \uc900\ube44 \uc911&#8230;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ################################# [100%] Updating \/ installing&#8230; 1:pgdg-centos94-9.4-1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ################################# [100%] [root@localhost ~]# yum install postgresql94 postgresql94-server postgresql94-libs postgresql94-contrib postgresql94 Loaded plugins: fastestmirror, langpacks http:\/\/linuxdownload.adobe.com\/linux\/x86_64\/repodata\/repomd.xml: [Errno 14] curl#6 &#8211; &#8220;Could not resolve host: linuxdownload.adobe.com; \uc774\ub984 \ud639\uc740 \uc11c\ube44\uc2a4\ub97c \uc54c \uc218 \uc5c6\uc2b5\ub2c8\ub2e4&#8221; Trying other mirror. http:\/\/mirror.oasis.onnetcorp.com\/centos\/7.1.1503\/os\/x86_64\/repodata\/repomd.xml: [Errno 12] Timeout on http:\/\/mirror.oasis.onnetcorp.com\/centos\/7.1.1503\/os\/x86_64\/repodata\/repomd.xml: (28, &#8216;Resolving timed out after 30383 milliseconds&#8217;) Trying other mirror. base\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 3.6 kB\u00a0 00:00:00 epel\/x86_64\/metalink\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 | 4.4 kB\u00a0 00:00:00 epel\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 4.4 kB\u00a0 00:00:00 extras\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 3.4 kB\u00a0 00:00:00 . . . 2. Configure Initialize the PostgreSQL. [root@itzgeek~\/]# \/usr\/pgsql-9.4\/bin\/postgresql94-setup initdb PostgreSQL normally listens on the localhosts only, if would you like to enable the PostgreSQL to listen on all ip addresses; edit the \/var\/lib\/pgsql\/9.1\/data\/postgresql.conf . [root@itzgeek~\/]# vi \/var\/lib\/pgsql\/9.4\/data\/postgresql.conf Go to Connections and Communications section, find the \u201clisten_address\u201d variable. Uncomment the \u201clisten_addresses\u201d and place \u201c*\u201d instead of \u201clocalhost\u201d Before editing: #listen_addresses = &#8220;localhost&#8221; After editing: listen_addresses = &#8220;*&#8221; Add your network to access database remotely; Edit\u00a0 \/var\/lib\/pgsql\/9.4\/data\/pg_hba.conf. [root@itzgeek~\/]# \u00a0vi \/var\/lib\/pgsql\/9.4\/data\/pg_hba.conf Add the following line according to your network configuration with md5 password authentication (Enable remote access [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[4,5],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-bL","jetpack-related-posts":[{"id":772,"url":"https:\/\/blog.box.kr\/?p=772","url_meta":{"origin":729,"position":0},"title":"Installing Taiga on CentOS  (x64)","date":"2015-05-11","format":false,"excerpt":"\u00a0 Dependencies ... yum update -y yum groupinstall \"Development Tools\" -y yum install libxslt-devel libxml2-devel libXt-devel curl git tmux -y Installing PostgreSQL ... TAIGA_POSTGRES_BD = taiga TAIGA_POSTGRES_USER = taiga TAIGA_POSTGRES_PASSWORD=`< \/dev\/urandom tr -dc _A-Z-a-z-0-9 | head -c${1:-20};echo;` ... rpm -ivh http:\/\/yum.postgresql.org\/9.4\/redhat\/rhel-6-x86_64\/pgdg-centos94-9.4-1.noarch.rpm sed -i 's\/^gpgkey.*\/&nexclude=postgresql*\/' \/etc\/yum.repos.d\/CentOS-Base.repo yum -y install postgresql94 postgresql94-contrib\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":675,"url":"https:\/\/blog.box.kr\/?p=675","url_meta":{"origin":729,"position":1},"title":"[Linux] CentOS 7 \/ RHEL 7\uc5d0 redis \uc124\uce58 \ud558\uae30","date":"2015-04-13","format":false,"excerpt":"Project URL : http:\/\/redis.io\/ CentOS 7 and Red Hat Enterprise Linux 7\uc5d0\uc11c Redis\ub97c \uc124\uce58 \ud558\ub294 \ubc29\ubc95 EPEL \uc800\uc7a5\uc18c \ub4f1\ub85d \ud558\uae30 EPEL \uc800\uc7a5\uc18c\ub97c \uba3c\uc800 \ub4f1\ub85d\ud55c\ub2e4. wget -r --no-parent -A 'epel-release-*.rpm' http:\/\/dl.fedoraproject.org\/pub\/epel\/7\/x86_64\/e\/ rpm -Uvh dl.fedoraproject.org\/pub\/epel\/7\/x86_64\/e\/epel-release-*.rpm \/etc\/yum.repos.d\u00a0 \ud558\uc704 \ub514\ub809\ud1a0\ub9ac\uc5d0 \uc544\ub798\uc640 \uac19\uc774 2\uac1c\uc758 epel \uc800\uc7a5\uc18c\uac00 \ub4f1\ub85d\ub41c\ub2e4. 1. epel.repo 2.epel-testing.repo [root@localhost ~]# ls -l \/etc\/yum.repos.d\/\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":711,"url":"https:\/\/blog.box.kr\/?p=711","url_meta":{"origin":729,"position":2},"title":"HOW TO INSTALL SENSU ON CENTOS7","date":"2015-04-15","format":false,"excerpt":"https:\/\/garage.godaddy.com\/tech\/config\/install-sensu-centos7\/ Sensu is a monitoring router for Linux operating systems such as CentOS 7. It monitors \u201ccheck\u201d scripts and passes their results to the corresponding handler scripts when the specified conditions are met. Checking the status of a service such as Apache is one of the most common uses of\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"Uchiwa","src":"https:\/\/i0.wp.com\/garage.godaddy.com\/wp-content\/uploads\/2015\/01\/Uchiwa.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":510,"url":"https:\/\/blog.box.kr\/?p=510","url_meta":{"origin":729,"position":3},"title":"[\ud38c]How to enable EPEL repo on CentOS 5 &amp; 6","date":"2014-12-28","format":false,"excerpt":"To enable EPEL (Extra Packages for Enterprise Linux) for CentOS 5 x86 or x64, log in to SSH on your server and execute the following command (dependent on your OS \u2013 unsure of what version of CentOS you are running?): \u00a0CentOS 6.x 32-bit (x86\/i386): rpm -Uvh http:\/\/mirror.overthewire.com.au\/pub\/epel\/6\/i386\/epel-release-6-7.noarch.rpm CentOS 6.x 64-bit\u2026","rel":"","context":"In &quot;Linux&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":864,"url":"https:\/\/blog.box.kr\/?p=864","url_meta":{"origin":729,"position":4},"title":"How to Install Git 2.4.2 on CentOS\/Redhat 7,6,5 and Fedora 20\/19","date":"2015-05-27","format":false,"excerpt":"http:\/\/tecadmin.net\/install-git-2-0-on-centos-rhel-fedora\/ Git has released 2.4.2\u00a0version on May 26, 2015.It has lots of noticeable changes over git 1.9 release. Git is a free and open source distributed version control system . It is designed to handle a small to very large projects with speed and efficiency. To know more about read\u2026","rel":"","context":"In &quot;\uae30\uc220&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":853,"url":"https:\/\/blog.box.kr\/?p=853","url_meta":{"origin":729,"position":5},"title":"[scrap]\ub9ac\ub205\uc2a4\uc5d0\uc11c vsftp\uc124\uc815(530\uc5d0\ub7ec, 500\uc5d0\ub7ec, root \ub85c\uadf8\uc778 \uc2e4\ud328 \ud3ec\ud568)","date":"2015-05-20","format":false,"excerpt":"http:\/\/dryad.kr\/bbs\/board.php?bo_table=rboard01&wr_id=200 \u00a0 \ub9ac\ub205\uc2a4 :\u00a0CentOS 5.6 vsFTPD\u00a0: Very Secure FTPD vsftpd FTP \uc11c\ubc84\uc5d0 \ub300\ud574 vsftpd\ub294 UNIX \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 free FTP \uc11c\ubc84(\ub77c\uc774\uc13c\uc2a4\ub294 GPL)\uc774\ub2e4. vsftpd\uac00 \ub0b4\uc138\uc6b0\uace0 \uc788\ub294 \uac83\uc740 \ubcf4\uc548, \uc131\ub2a5, \uc548\uc815\uc131\uc774\ub2e4. \uc9c0\uae08\uae4c\uc9c0 vsftpd\uc758 \uc790\uccb4 \ubcf4\uc548 \ubb38\uc81c\uac00 \uc788\uc5b4 \ubcf4\uc548\uad8c\uace0\uac00 \ub098\uc628 \uc801\uc740 \uc5c6\ub2e4.(Redhat\uc758 rpm \ud328\ud0a4\uc9c0\uc911\uc5d0 tcp_wrappers \uc9c0\uc6d0\uc5c6\uc774 \ub9cc\ub4e4\uc5b4\uc838\uc11c \uc5c5\ub370\uc774\ud2b8 rpm\uc740 \ub098\uc628 \uc801 \uc788\uc74c)\u2026","rel":"","context":"In &quot;\uae30\uc220&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/729"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=729"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/729\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}