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 SupyBot PyLink Hopm
Latest topics
» mIRCx IRC Network Config
Sat Aug 04, 2018 2:39 pm by Chief

» מדריך הגנות אופרים בגירסאות IRCD
Mon May 14, 2018 5:50 am by Chief

» install irssi v1.2-1.2-dev in freebsd
Thu Mar 22, 2018 5:43 am by Chief

» install ZNC in Ubuntu 14.04
Sun Mar 04, 2018 5:50 am by Chief

» מדריך שינוי גירסאות ב FREEBSD
Fri Mar 02, 2018 8:35 am by Chief

» מדריך התקנה ZNC על WINDOWS 7
Wed Feb 21, 2018 3:30 am by Chief

» Guide install Znc in FreeBsd
Sun Feb 18, 2018 7:58 am by Chief

» Guide install InspIRCd v3.0.0a5 in FreeBsd
Thu Jan 18, 2018 9:52 pm by Chief

» מדריך התקנה Pylink על unrealircd4 && inspircd
Sat Nov 18, 2017 6:35 am by Chief

October 2018
MonTueWedThuFriSatSun
1234567
891011121314
15161718192021
22232425262728
293031    

Calendar Calendar

Affiliates
free forum

Affiliates
free forum


Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7

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

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

View user profile

Back to top Go down

Back to top

- Similar topics

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