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
» מדריך התקנה InspIRCd-3.0.0-rc1
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyWed Feb 06, 2019 8:43 pm by Chief

» מדריך פקודות בגירסה INSPIRCD
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyTue Dec 04, 2018 9:55 pm by Chief

» mIRCx IRC Network Config
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptySat Aug 04, 2018 2:39 pm by Chief

» מדריך הגנות אופרים בגירסאות IRCD
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyMon May 14, 2018 5:50 am by Chief

» install irssi v1.2-1.2-dev in freebsd
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyThu Mar 22, 2018 5:43 am by Chief

» install ZNC in Ubuntu 14.04
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptySun Mar 04, 2018 5:50 am by Chief

» מדריך שינוי גירסאות ב FREEBSD
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyFri Mar 02, 2018 8:35 am by Chief

» מדריך התקנה ZNC על WINDOWS 7
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyWed Feb 21, 2018 3:30 am by Chief

» Guide install Znc in FreeBsd
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptySun Feb 18, 2018 7:58 am by Chief

April 2019
MonTueWedThuFriSatSun
1234567
891011121314
15161718192021
22232425262728
2930     

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 Empty 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
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-10
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-11
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-12
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-13
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-14
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
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-15
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-16
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
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-17
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-18
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
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-19
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-20
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
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-21
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-22
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;
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 13-06-11
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 13-06-12
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 13-06-13
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 13-06-14
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
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 13-06-15
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
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 13-06-17
step6
configure phpPgAdmin
do you need do it
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-23
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 12-06-24
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
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 13-06-18
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
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 13-06-19
Good luck
Guide write by mIRCx IRC Network
Chief
Chief
Admin

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