Install PostgreSQL phpPgAdmin on Fedora 12
1. Update YUM
su – (or sudo)
yum update
2. install from repo
yum install postgresql-server postgresql phpPgAdmin php-pgsql
3. Edit settings files:
a) vim /var/lib/pgsql/data/pg_hba.conf
set “trust” to login “without password”
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# “local” is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
b) vim /var/lib/pgsql/data/postgresql.conf
My basic settings (for local working with db):
#——————————————————————————
# CONNECTIONS AND AUTHENTICATION
#——————————————————————————
# – Connection Settings -
listen_addresses = ‘*’ # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to ‘localhost’, ‘*’ = all
# (change requires restart)
port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
c) cp /etc/phpPgAdmin/config.inc.php-dist config.inc.php
(Copy phpPgAdmin config file (rename on basic setup) )
4. Initialize db
service postgresql initdb
5. Start server
/etc/init.d/postgresql start
Or configure service to start automatical:
/sbin/chkconfig postgresql on
/sbin/service postgresql start
6. Create user and database:
su – postgres
psql template1
psql# create user db_user;
psql# create database test_db owner db_user;
for quitfrom psql, type:
psql# \q
7. Go to : http;//localhost/phpPgAdmin/
put your login (db_user )