postgresql安装

# yum install readline-devel
未安装readline-devel会出现readline library not found错误
# wget http://ftp.postgresql.org/pub/source/v9.1.2/postgresql-9.1.2.tar.bz2
# tar jxvf postgresql-9.1.2.tar.bz2 -C ../software/
# ./configure --prefix=/home/xuhh/pgsql912  --with-perl --with-python
# gmake
# gmake install
# mkdir /home/xuhh/pgsql912/data
# adduser postgres
# chown -R postgres.postgres /home/xuhh/pgsql912
# chown postgres.postgres /home/xuhh/pgsql912/data
# su - postgres
$ /home/xuhh/pgsql912/bin/initdb -D /home/xuhh/pgsql912/data  //初始化数据
$ /home/xuhh/pgsql912/bin/postgres -D /home/xuhh/pgsql912/data > /tmp/pg-logfile 2>&1 &  //启动数据库

$ /home/xuhh/pgsql912/bin/createdb test  //创建数据库
$ /home/xuhh/pgsql912/bin/psql -d test //连接数据库
test=# CREATE TABLE  test (id serial, name varchar(32));
test=# insert into test values(1,'abc');
test=# insert into test values('2','bbb');
test=# \dp+   //查看表空间
Access privileges
Schema |    Name     |   Type   | Access privileges | Column access privileges
--------+-------------+----------+-------------------+--------------------------
public | test        | table    |                   |
public | test_id_seq | sequence |                   |
(2 rows)
test=# \dt+   //查看表
List of relations
Schema | Name | Type  |  Owner   |    Size    | Description
--------+------+-------+----------+------------+-------------
public | test | table | postgres | 8192 bytes |
(1 row)

test=# create tablespace xxoo location '/tmp/';    //创建表空间

test=# select * from pg_tablespace;    //查看表空间
spcname   | spcowner | spclocation | spcacl | spcoptions
------------+----------+-------------+--------+------------
pg_default |       10 |             |        |
pg_global  |       10 |             |        |
xxoo       |       10 | /tmp/xxoo   |        |
(3 rows)

test=# alter tablespace xxoo rename to ttlsa;   //更改表空间名
ALTER TABLESPACE
test=# select * from pg_tablespace;
spcname   | spcowner | spclocation | spcacl | spcoptions
------------+----------+-------------+--------+------------
pg_default |       10 |             |        |
pg_global  |       10 |             |        |
ttlsa      |       10 | /tmp/xxoo   |        |
(3 rows)