Search
Web Applications
install Joomla Wordpress Phpbb Drupal FluxBB PunBB osCommerce simple-machines MYBB moodle vBulletin Dolphin-v.7.1.1 PHPNUKE XOOPSServices
install BorkNet Services X3 Services Anope Atheme Services Srvx IRC SrervicesIRCD
install Snircd IRCU INSPIRCD UNREAL Nefarious Bircd Bahamut Asuka CharybdisTCL SCRIPT
TCL SCRIPT FOR EGGDROP
Allprotection4.7 AntiproxyBots
Bots install FishBot bobot++ Eggdrop janus Omega Security Services Botnix Bopm SupyBot PyLink HopmLatest topics
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7
MIRCX IRC Network :: MIRCX :: MIRCX
Page 1 of 1
Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7
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
after this you need select more port in iptables then doing it
you can choose from where you want inside nano or gedit
now we need Access PostgreSQL command prompt and you need doing like it's
more options you can select more things like more user database with SUPERUSER and what do you need is write first
step5
before we install phpPgAdmin we need change something in pg_hba.conf
and now we need change in Configure PostgreSQL-Configure TCP/IP
step6
configure phpPgAdmin
do you need do it
change
Good luck
Guide write by mIRCx IRC Network
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
- Code:
/usr/pgsql-9.4/bin/postgresql94-setup initdb
- Code:
systemctl enable postgresql-9.4
systemctl start postgresql-9.4
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
now we need Access PostgreSQL command prompt and you need doing like it's
- Code:
su - postgres
psql
\password postgres
\q
- 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
- Code:
#listen_addresses = 'localhost'
^
listen_addresses = '*'
#password_encryption = on
^
password_encryption = on
- 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
- Code:
nano /etc/phpPgAdmin/config.inc.php
change
- Code:
$conf['servers'][0]['host'] = 'localhost';
$conf['extra_login_security'] = false;
$conf['owned_only'] = true;
- Code:
systemctl restart postgresql-9.4
systemctl restart httpd
Good luck
Guide write by mIRCx IRC Network
Chief- Admin
- מספר הודעות : 268
Join date : 2011-12-09
מיקום : mIRCx IRC Network
Similar topics
» מדריך התקנה postgresql+phpPgAdmin על ubuntu14.04.1
» מדריך התקנה postgreSQL && phpPgAdmin על FREEBSD11
» Guide install postgresql on ubuntu
» Guide Centos 7 Help with iptables
» Guide install Anope in Centos 7
» מדריך התקנה postgreSQL && phpPgAdmin על FREEBSD11
» Guide install postgresql on ubuntu
» Guide Centos 7 Help with iptables
» Guide install Anope in Centos 7
MIRCX IRC Network :: MIRCX :: MIRCX
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|
Sat Aug 05, 2023 2:09 am by Chief
» mIRCx IRC Network Config
Sat Jul 15, 2023 9:51 pm by Chief
» ircu2.10.12-pk with dnsbl
Fri Mar 10, 2023 2:22 pm by Admin
» Guide install PyLink on New version FreeBSD
Thu Dec 15, 2022 9:39 pm by Chief
» מדריך התקנה PBot על מערכת הפעלה FreeBsd-12
Mon Dec 05, 2022 5:44 am by Chief
» install Nefarious2 && X3 IRC Services in FreeBsd
Sat Nov 12, 2022 3:12 pm by Chief
» help problem with adduser in Freebsd 12
Fri Nov 11, 2022 9:06 pm by Chief
» מדריך פקודות והתקנה בסרביס X3
Fri Oct 28, 2022 1:43 pm by Chief
» מדריך הגדרות WebIRC in Nefarious2
Thu Apr 07, 2022 4:45 am by Chief