Centos 6 Postgresql 9.5, phpPgAdmin, PgAdmin Kurulumu ve Ayarları
*****************************************************************

1. Güvenlik Duvarı açıksa aşağıdaki işlemleri yapın
---------------------------------------------------
# iptables -I INPUT -p tcp --dport 80 -j ACCEPT
# iptables -I INPUT -p tcp --dport 5432 -j ACCEPT
# service iptables save



2. Apache ve Php Kurulumu
-------------------------
# yum install httpd php -y
# echo '<?php phpinfo(); ?>' > /var/www/html/test.php
# service httpd start && chkconfig httpd on
WEB TEST:   http://192.168.0.220/test.php



3. PostgreSQL, phpPgAdmin paket kurulumu ve servisini aktif adilmesi
--------------------------------------------------------------------
# rpm -Uvh https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-centos95-9.5-2.noarch.rpm
# yum install -y postgresql95 postgresql95-server phpPgAdmin
# service postgresql-9.5 initdb
# service postgresql-9.5 start && chkconfig postgresql-9.5 on



4. PostgreSQL Yönetici useri postgres'e parola verme
----------------------------------------------------
# su - postgres
psql
\password postgres
Enter new password: 123456
\q
exit



5. Postgresql Ayarları
----------------------
# sed -i s/"#listen_addresses = 'localhost'"/"listen_addresses = '*'"/g /var/lib/pgsql/9.5/data/postgresql.conf
# sed -i s/"#port = 5432"/"port = 5432"/g /var/lib/pgsql/9.5/data/postgresql.conf
# sed -i s/"max_connections = 100"/"max_connections = 250"/g /var/lib/pgsql/9.5/data/postgresql.conf
# sed -i s/"local   all             all                                     peer"/"local all all md5"/g /var/lib/pgsql/9.5/data/pg_hba.conf
# echo 'host all all 192.168.0.15/32 md5' >> /var/lib/pgsql/9.5/data/pg_hba.conf    --> KENDI SISTEMINIZE GÖRE DÜZENLEYİN
# service postgresql-9.5 restart



6. PostgreSQL Veritabanı, Tablo, Kullanıcı Oluşturmak Veri Girmek
-----------------------------------------------------------------
# sudo -u postgres psql
Password: 123456
create database unaldb;
CREATE role unaldb LOGIN PASSWORD '123456' SUPERUSER;
ALTER USER unaldb WITH encrypted PASSWORD '123456';
grant all privileges on database unaldb to unaldb;
\list
\c unaldb;
create schema personel;
create table personel.adsoyad(adi CHAR(15), soyadi CHAR(20));
\d personel.adsoyad
insert into personel.adsoyad values('Unal','Yilmaz');
insert into personel.adsoyad values('Meric','Yilmaz');
insert into personel.adsoyad values('Murat','Ozdemir');
select * from personel.adsoyad;
\q



7. Postgresql Yönetim Aracı Bağlantısı
--------------------------------------
Postgresql Yönetim Aracı Download -->>  http://www.pgadmin.org/download  --> Kurulur

Server Tanımı Ekleme;
Servers/Create/Server
Name : PostgreSQL_DbServer
host : 192.168.0.220
Db   : postgres
user : postgres
pass : 123456



8. phpPgAdmin Ayarı ve Bağlantısı
---------------------------------
# sed -i '/\Deny from all/a\Allow from '"192.168.0.15/32"'' /etc/httpd/conf.d/phpPgAdmin.conf    --> KENDI SISTEMINIZE GÖRE DÜZENLEYİN
# service httpd restart
WEB TEST:   http://192.168.0.220/phpPgAdmin
	    username: unaldb
	    password: 123456