Search
 
 

Display results as :
 


Rechercher Advanced Search

Web Applications
install Joomla Wordpress Phpbb Drupal FluxBB PunBB osCommerce simple-machines MYBB moodle vBulletin Dolphin-v.7.1.1 PHPNUKE XOOPS
Services
install BorkNet Services X3 Services Anope Atheme Services Srvx IRC Srervices
IRCD
install Snircd IRCU INSPIRCD UNREAL Nefarious Bircd Bahamut Asuka Charybdis
TCL SCRIPT
TCL SCRIPT FOR EGGDROP Allprotection4.7 Antiproxy
Bots
Bots install FishBot bobot++ Eggdrop janus Omega Security Services Botnix Bopm
Keywords

multi  speed  

Latest topics
» מדריך התקנה WORDPRESS על FREEBSD11
Mon Jul 17, 2017 2:50 am by Chief

» מדריך התקנה postgreSQL && phpPgAdmin על FREEBSD11
Sun Jul 16, 2017 4:23 pm by Chief

» מדריך התקנה PHPMYADMIN על FREEBSD11
Sat Jul 15, 2017 5:44 am by Chief

» mIRCx IRC Network Config
Fri Jul 07, 2017 12:57 pm by Chief

» מדריך איך מתקינים DESKTOP על FREEBSD
Fri Jul 07, 2017 12:44 pm by Chief

» מדריך התקנה FTP SERVER על FREEBSD
Mon Jul 03, 2017 3:52 am by Chief

» install inspircd in freebsd 11
Sat Jul 01, 2017 11:57 pm by Chief

» מדריך התקנה FEDORA 25
Sat Jul 01, 2017 7:59 pm by Chief

» מדריך התקנה מערכת הפעלה FREEBSD
Sat Jun 24, 2017 12:59 am by Chief

August 2017
MonTueWedThuFriSatSun
 123456
78910111213
14151617181920
21222324252627
28293031   

Calendar Calendar

Affiliates
free forum

Affiliates
free forum


Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7

View previous topic View next topic Go down

Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7

Post  Chief on Sun Jun 14, 2015 1:33 am

Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7
Today I will teach you about install and configure and i expalin to you step by step
step1





write please in your root
Code:

rpm -Uvh http://yum.postgresql.org/9.4/redhat/rhel-7-x86_64/pgdg-centos94-9.4-1.noarch.rpm
yum install postgresql94-server postgresql94-contrib
yum install pgadmin3.x86_64
step2


Code:

/usr/pgsql-9.4/bin/postgresql94-setup initdb
and after this do you need write this
Code:

systemctl enable postgresql-9.4
systemctl start postgresql-9.4
step3
after this you need select more port in iptables then doing it


you can choose from where you want inside nano or gedit
Code:

nano /etc/sysconfig/iptables
gedit /etc/sysconfig/iptables
-A INPUT -m state --state NEW -m tcp -p tcp --dport 5432 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
service iptables save
service iptables restart
step4
now we need Access PostgreSQL command prompt and you need doing like it's


Code:

su - postgres
psql
\password postgres
\q
now you can Create New User and Database
Code:

CREATE DATABASE mircx;
CREATE ROLE mircx WITH login;
sudo -u postgres psql mircx
\password mircx


more options you can select more things like more user database with SUPERUSER and what do you need is write first
Code:

CREATE DATABASE nefarious;
CREATE role nefarious LOGIN PASSWORD '123456' SUPERUSER;
ALTER USER "nefarious" WITH CREATEDB;
ALTER USER "nefarious" WITH CREATEROLE;
ALTER USER "nefarious" WITH Replication;




step5
before we install phpPgAdmin we need change something in pg_hba.conf
Code:

nano /var/lib/pgsql/9.4/data/pg_hba.conf
systemctl restart postgresql-9.4

and now we need change in Configure PostgreSQL-Configure TCP/IP
Code:

nano /var/lib/pgsql/9.4/data/postgresql.conf
change this
Code:

#listen_addresses = 'localhost'
^
listen_addresses = '*'
#password_encryption = on
^
password_encryption = on
if do you no understand is need to be like this and make restart
Code:

systemctl restart postgresql-9.4

step6
configure phpPgAdmin
do you need do it


Code:

yum install epel-release
yum update
yum install phpPgAdmin httpd
systemctl enable httpd
systemctl start httpd
now do you need change some in config.inc.php
Code:

nano /etc/phpPgAdmin/config.inc.php

change
Code:

$conf['servers'][0]['host'] = 'localhost';
$conf['extra_login_security'] = false;
$conf['owned_only'] = true;
and after this write this
Code:

systemctl restart postgresql-9.4
systemctl restart httpd

Good luck
Guide write by mIRCx IRC Network
avatar
Chief
Admin

מספר הודעות : 200
Join date : 2011-12-09
מיקום : mIRCx IRC Network

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum