postgresql数据库安装

 

postgreSQL数据库安装

1、安装程序

[root@test ~]# cd /

[root@test /]# mkdir files

[root@test /]# cd files/

[root@test files]# wget http://192.168.1.2/flex-2.5.35.tar.bz2

[root@test files]# wget http://192.168.1.2/postgresql-9.1.2.tar.bz2

[root@test files]# tar xfv flex-2.5.35.tar.bz2

[root@test files]# cd flex-2.5.35

[root@test flex-2.5.35]# ./configure

[root@test flex-2.5.35]# make

[root@test flex-2.5.35]# make install

[root@test flex-2.5.35]# mkdir -p /u01/pg9.1/data

[root@test flex-2.5.35]# cd ..

[root@test files]# tar xfv postgresql-9.1.2.tar.bz2

[root@test files]# cd postgresql-9.1.2

[root@test postgresql-9.1.2]# ./configure --with-wal-segsize=64 -with-segsize=32 --prefix=/u01/pg9.1

[root@test postgresql-9.1.2]# gmake

[root@test postgresql-9.1.2]# gmake install

2、添加用户以及配置环境变量

[root@test postgresql-9.1.2]# adduser postgres

[root@test postgresql-9.1.2]# su – postgres

[postgres@test ~]$ vi ~/.bash_profile

export PGHOME=/u01/pg9.1

export PGDATA=$PGHOME/data

export PATH=$PGHOME/bin:$PATH

export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH

export PGUSER=postgres

export PGDATABASE=sfdb

[postgres@test ~]$ exit

3、修改data文件夹的拥有者

[root@test postgresql-9.1.2]# chown postgres /u01/pg9.1/data

[root@test postgresql-9.1.2]# su – postgres

4、初始化数据库

[postgres@test ~]$ initdb -D $PGDATA

[postgres@test ~]$ pg_ctl start >logfile 2>&1 &

[postgres@test ~]$ exit

[root@test postgresql-9.1.2]# vi /etc/rc.local

su - postgres -c "pg_ctl start"

[root@test postgresql-9.1.2]# su – postgres

[postgres@pg1 ~]$ createdb sfdb

[postgres@test ~]$ psql

sfdb=# alter user postgres encrypted password 'guoxianqi';

sfdb=# \q

[postgres@test ~]$ vi /u01/pg9.1/data/postgresql.conf

listen_addresses = '*'

port = 5432

max_connections = 1000

shared_buffers = 400MB---------------------------25-40%

log_destination = 'stderr'

logging_collector = on

log_directory = 'pg_log'

log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'

log_file_mode = 0600

log_truncate_on_rotation = on

log_rotation_age = 1d

log_rotation_size = 10MB

[postgres@test ~]$ vi /u01/pg9.1/data/pg_hba.conf

host       all  all  192.168.1.2/24  trust

[postgres@test ~]$ pg_ctl restart