好久不写东西,一直在看些开源的东西,下面贴下linux上安装配置postgres及使用dblink的操作参考,以供读者和自己今后参考:
1、下载源码:postgresql-9.3.2.tar.gz 自行百度
2、创建postgres cluster组和用户:
groupaddpostgres
useraddpostgres -d /home/postgres -g postgres
mkdir -p/usr/local/pgsql
mkdir -p/use/local/pgsql/data
chown -Rpostgres.postgres /usr/local/pgsql
passwdpostgres
su -postgres
cd
vi.bash_profile
exportPGHOME=/usr/local/pgsql
exportPGDATA=/usr/local/pgsql/data
exportPATH=$PATH:/usr/local/pgsql/bin
..bash_profile
3、将源码文件传至数据库服务器:
/usr/local/pgsql/postgresql-9.3.2.tar.gz
cd/usr/local/pgsql
tar zxfpostgresql-9.3.2.tar.gz
4、配置及安装数据库:
cd/usr/local/plsql/postgresql-9.3.2
configure
make
su -
makeinstall
5、初始化数据库:
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
6、配置参数文件:
cd/usr/local/pgsql/data
vipostgresql.conf
--监听和端口
7、配置登录安全规则:
vipg_hba.conf
8、登录postgres并修改密码:
psqlpostgres postgres
alteruser postgres password 'test';
9、配置dblink:
cd/usr/local/pgsql/postgresql-9.3.2/contrib/dblink
make
su
makeinstall
psqlpostgres postgres
create extension dblink;
select *from pg_extension;
10、创建和使用dblink
psql testtest
selectdblink_connect('test_dblink','dbname=postgres host=192.168.109.10 port=1921user=postgres password=test');
select *from dblink('test_dblink','select c1,c3 from ttt') as t1 (c1 integer,c2 varchar);
评论