Delete built-in PostgreSQL and install it in Linux

Root Account Logon: suRoot

Delete: rpm-Qa | grep PostgreSQL | xargs rpm-e -- nodeps

Query: rpm-Qa | grep PostgreSQL

Windows Client: pgadmin III or phpPgAdmin

Http://www.postgresql.org/download/

# Useradd postgre (automatically create a postgre Group)

# Tar xvfz postgresql-7.1.3.tar.gz
# Cd postgresql-7.1.3
#./Configure -- prefix =/usr/local/pgsql
# Make
# Make install
# Chown-r postgre. postgre/usr/local/pgsql

# Vi ~ Postgre/. bash_profile
Add:

Pglib =/usr/local/pgsql/lib
Pgdata = $ home/Data
Path = $ path:/usr/local/pgsql/bin
Manpath = $ manpath:/usr/local/pgsql/man
Export pglib pgdata path manpath

# Su-postgre

Create the data folder in the postgre directory. (/home/postgre/data)

$ Mkdir data

$ Initdb (-e-euc_jp)

Modify: Under/home/postgre/Data

1. PostgreSQL. conf

Tcpip_socket = true

2. pg_cmd.conf

# Type Database User IP-ADDRESS IP-MASK Method

Local all trust
# IPv4-style local connections:
Host All all 192.168.1.220 255.255.255.0 Trust
Host All all 192.168.1.219 255.255.255.0 Trust
Host All all 192.168.1.221 255.255.255.0 Trust
Host All all 192.168.1.54 255.255.255.0 Trust
# IPv6-style local connections:
Host All: 1 FFFF: FFFF Trust

/Usr/local/pgsql/bin/postmaster-D/home/postgre/Data

Or/usr/local/pgsql/bin/pg_ctl-D/home/postgre/Data start

$ Postmaster-I-d ~ /Data &