Install Postgresql on Red Hat 9 with RPM packages

kinux

               
               
               
               
               
Install Postgresql on Red Hat 9 with RPM packages
Download packages
http://www.postgresql.org/ftp/binary/v7.4.8/linux/rpms/redhat/redhat-9/
postgresql-7.4.8-1PGDG.i686.rpm               
postgresql-contrib-7.4.8-1PGDG.i686.rpm
postgresql-devel-7.4.8-1PGDG.i686.rpm
postgresql-docs-7.4.8-1PGDG.i686.rpm
postgresql-jdbc-7.4.8-1PGDG.i686.rpm
postgresql-libs-7.4.8-1PGDG.i686.rpm
postgresql-pl-7.4.8-1PGDG.i686.rpm
postgresql-server-7.4.8-1PGDG.i686.rpm
postgresql-test-7.4.8-1PGDG.i686.rpm
Installation
# rpm -ivh postgresql-libs-7.4.8-1PGDG.i686.rpm
# rpm -ivh postgresql-devel-7.4.8-1PGDG.i686.rpm
# rpm -ivh postgresql-contrib-7.4.8-1PGDG.i686.rpm
# rpm -ivh postgresql-7.4.8-1PGDG.i686.rpm
# rpm -ivh postgresql-server-7.4.8-1PGDG.i686.rpm
# rpm -ivh postgresql-docs-7.4.8-1PGDG.i686.rpm
# rpm -ivh postgresql-test-7.4.8-1PGDG.i686.rpm
# rpm -ivh postgresql-jdbc-7.4.8-1PGDG.i686.rpm
# rpm -ivh postgresql-pl-7.4.8-1PGDG.i686.rpm
Start Postgresql
#/etc/init.d/postgresql start
Configuration
#cd /var/lib/pgsql/data
#vi postgresql.conf
Uncomment tcpip_socket and change false to true
tcpip_socket = true
#vi pg_hba.conf
Add the allowed host connect to the database.
host    all         all         127.0.0.1         255.255.255.255   password
host    all         all         192.168.0.0         255.255.255.0       password
Start postgresql after reboot
#chkconfig postgresql on
Postgres login to the database
#su postgres
Add user with all privileges
$createuser
    Enter name of user to add: test
    Shall the new user be allowed to create databases? (y/n) y
    Shall the new user be allowed to create more new users? (y/n) n
    CREATE USER
$
Change passwd
$psql template1   // default database is template1
Welcome to psql 7.4.8, the PostgreSQL interactive terminal.
Type:  copyright for distribution terms
       h for help with SQL commands
       ? for help on internal slash commands
       g or terminate with semicolon to execute query
       q to quit
template1=#ALTER USER test WITH PASSWORD 'test';
ALTER USER
template1=#\q
$
Reference
http://dev.panopticsearch.com/postgres_microhowto.html
               
               

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/184/showart_55239.html