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
Latest topics
» Guide install Janus IRC
Sat Dec 03, 2016 3:46 am by Chief

» Guide install Anope in Centos 7
Sat Nov 19, 2016 7:24 am by Chief

» mIRCx IRC Network Config
Tue Oct 18, 2016 10:52 pm by Chief

» מדריך התקנה מירק על ubuntu 14.04
Mon Sep 19, 2016 2:40 am by Chief

» Guide install srvx 1.4.1-rc1  in ubuntu
Fri Aug 26, 2016 5:02 pm by Chief

» Guide install Inspircd
Fri Aug 19, 2016 8:21 am by Chief

» config Inspircd+atheme 7.2.4
Mon Aug 01, 2016 2:21 am by Chief

» מדריך התקנה SRVX Services על Centos 7
Sat Jul 16, 2016 9:58 pm by Chief

» Guide All protection4.7
Fri Jul 15, 2016 2:31 pm by Chief

May 2017
MonTueWedThuFriSatSun
1234567
891011121314
15161718192021
22232425262728
293031    

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

מספר הודעות : 189
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