1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>
Image 1

WE Solutions / Our services

  • Previous
  • Next
  • Stop
  • Play

SAMBA/LDAP

Thin Client Server

Postfix Mail Server

Postfix Mail Server

HA Clustering

PostgreSQL

PDF Print E-mail

Written by Mr. Sontaya Photibut Saturday, 02 May 2009 19:02

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)Add Comment

Write comment

security code
Write the displayed characters


busy