On 10/05/12 1:53 AM, adekoya adekunle wrote:> how to install phpmyadmin on centos 6.3 ?
assuming you want to use postgresql 9.1 on a 64bit CentOS 6.x system
with phpPgAdmin...
# rpm -Uvh
http://yum.postgresql.org/9.1/redhat/rhel-6-x86_64/pgdg-centos91-9.1-4.noarch.rpm
...
# yum install postgresql91-server postgresql91-contrib phpPgAdmin
...
# chkconfig postgresql-9.1 on
# service postgresql-9.1 initdb
## (tweak /var/lib/pgsql/9.1/postgresql.conf and pg_hba.conf to suit [*])
# service postgresql-9.1 start
# su - postgres
$ createuser --superuser -P username
(enter a password for this new sql user at the prompt)
$ createdb -O username username
$ ^D
# service httpd start ## or reload if its already running
now, on that server, http://localhost/phpPgAdmin should get you
phpPgAdmin.... initially connect to localhost:5432 as user username to
database username with the password you gave above. you'll need to
tweak /etc/httpd/conf.d/phpPgAdmin.conf to enable access from other
hosts and reload httpd.
[*] in particular, change pg_hba.conf to read like...
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all postgres peer
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# host all all x.y.z.w/24 md5 #
uncomment this line and change to your subnet if you want LAN
connections to postgres
--
john r pierce N 37, W 122
santa cruz ca mid-left coast