MIRCX IRC Network
Would you like to react to this message? Create an account in a few clicks or log in to continue.
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 V4
postgresql - Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptySat Aug 05, 2023 2:09 am by Chief

» mIRCx IRC Network Config
postgresql - Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptySat Jul 15, 2023 9:51 pm by Chief

» ircu2.10.12-pk with dnsbl
postgresql - Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyFri Mar 10, 2023 2:22 pm by Admin

» Guide install PyLink on New version FreeBSD
postgresql - Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyThu Dec 15, 2022 9:39 pm by Chief

» מדריך התקנה PBot על מערכת הפעלה FreeBsd-12
postgresql - Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyMon Dec 05, 2022 5:44 am by Chief

» install Nefarious2 && X3 IRC Services in FreeBsd
postgresql - Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptySat Nov 12, 2022 3:12 pm by Chief

» help problem with adduser in Freebsd 12
postgresql - Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyFri Nov 11, 2022 9:06 pm by Chief

» מדריך פקודות והתקנה בסרביס X3
postgresql - Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyFri Oct 28, 2022 1:43 pm by Chief

» מדריך הגדרות WebIRC in Nefarious2
postgresql - Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 EmptyThu Apr 07, 2022 4:45 am by Chief

March 2024
MonTueWedThuFriSatSun
    123
45678910
11121314151617
18192021222324
25262728293031

Calendar Calendar

Affiliates
free forum

Affiliates
free forum


Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7

Go down

postgresql - Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7 Empty Guide Installing PostgreSQL 9.4 And phpPgAdmin In CentOS 7

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

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

Back to top Go down

Back to top

- Similar topics

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