http://kb.owrench.com/index.php?action=history&feed=atom&title=Postgres_installation 2026-05-04T04:22:41Z Revision history for this page on the wiki MediaWiki 1.34.2 http://kb.owrench.com/index.php?title=Postgres_installation&diff=97&oldid=prev 2017-06-16T09:16:59Z

<p>Created page with &quot;install &lt;b&gt;postgres&lt;/b&gt; from these links&lt;br&gt; https://yum.postgresql.org/howtoyum.php&lt;br&gt; https://yum.postgresql.org/repopackages.php&lt;br&gt; wget the required version into serve...&quot;</p> <p><b>New page</b></p><div>install &lt;b&gt;postgres&lt;/b&gt; from these links&lt;br&gt;<br /> <br /> https://yum.postgresql.org/howtoyum.php&lt;br&gt;<br /> https://yum.postgresql.org/repopackages.php&lt;br&gt;<br /> <br /> wget the required version into server, then&lt;br&gt;<br /> <br /> rpm -Uvh &quot;downloaded file&quot;&lt;br&gt;<br /> yum install postgresql93-server postgresql93&lt;br&gt;<br /> <br /> follow steps in http://community.webcorecloud.com/tutorials/install-postgresql-94-centos-6x/&lt;br&gt;<br /> <br /> <br /> vim /var/lib/pgsql93/data/postgresql.conf&lt;br&gt;<br /> log_destination = 'stderr'&lt;br&gt;<br /> logging_collector = on &lt;br&gt;<br /> log_directory = 'pg_log' &lt;br&gt;<br /> <br /> &lt;b&gt;Installing PhpPgAdmin&lt;/b&gt;<br /> <br /> yum install phpPgAdmin&lt;br&gt;<br /> vim /etc/httpd/conf.d/phpPgAdmin.conf&lt;br&gt;<br /> # Deny from all&lt;br&gt;<br /> # Allow from 127.0.0.1&lt;br&gt;<br /> Allow from all ## &lt;-- safe for internal servers, but provide the allowed IPs(office static IP) in live environment&lt;br&gt;<br /> <br /> vim /etc/phpPgAdmin/config.inc.php OR&lt;br&gt;<br /> vim /usr/share/phpPgAdmin/conf/config.inc.php&lt;br&gt;<br /> $conf['extra_login_security'] = false;&lt;br&gt;<br /> <br /> vim /var/lib/pgsql93/data/pg_hba.conf&lt;br&gt;<br /> local all all trust&lt;br&gt;<br /> host all all 127.0.0.1/32 md5&lt;br&gt;<br /> host all postgres all md5&lt;br&gt;<br /> # IPv6 local connections:&lt;br&gt;<br /> host all all ::1/128 md5&lt;br&gt;<br /> <br /> <br /> &lt;b&gt;UBUNTU doc reference:&lt;/b&gt;&lt;br&gt;<br /> http://stackoverflow.com/questions/1471571/how-to-configure-postgresql-for-the-first-time reference&lt;br&gt;<br /> <br /> [[category:it-support]]</div>

imported>Kishor