PostgreSQL

Install PostgreSQL-8.3.3 (Source Complies)

PostgreSQL คือโปรแกรม Database open source หรือ Object-Relational DBMS.

Download : http://www.master.postgresql.org/download/mirrors-ftp?file=%2Fsource%2Fv8.3.3%2Fpostgresql-8.3.3.tar.bz2

Install :

# wget http://www.master.postgresql.org/download/mirrors-ftp?file=%2Fsource%2Fv8.3.3%2Fpostgresql-8.3.3.tar.bz2

# tar -xvjf postgresql-8.3.3.tar.bz2

./configure

# gmake

# gmake install

# useradd postgres

# mkdir /usr/local/pgsql/data

# chown postgres /usr/local/pgsql/data

# su postgres

Create a new database

# /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

Start the database server

# /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &

# /usr/local/pgsql/bin/createdb test

# /usr/local/pgsql/bin/psql test

*** Restore your data from backup with

/usr/local/pgsql/bin/psql -d postgres -f outputfile

       using the *new* psql.

Postgres configure.

# vim /usr/local/pgsql/data/pg_hba.conf

#-------------------------------------------------------------------

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only

local   all         adempiere                         md5

local   all         all                               ident sameuser

# IPv4 local connections:

host    all         postgres    127.0.0.1/32          ident sameuser

host    all         all         127.0.0.1/32              md5

host    all         all         127.0.0.2/32              md5

host    all         all         192.168.1.0/24           md5

#-------------------------------------------------------------------

เป็นอันเสร็จการติดตั้ง แบบ compile.  

Comments (0)

Subscribe to this comment's feed

Name

Email

Website

Title

Comment

smaller | bigger

Subscribe via email (registered users only)

Write the displayed characters

Add Comment