Skip to content

Latest commit

 

History

History
91 lines (85 loc) · 2.71 KB

postgres_install.org

File metadata and controls

91 lines (85 loc) · 2.71 KB
Raw

postgresql 10 安装

debian 9.0 快速安装

apt-get build_dep postgresql-9.6
./configure --with-systemd
make
su
make install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -U user -W -A password -E UTF-8 -D /usr/local/pgsql/data 
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l postgres.log start
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

安装后配置环境变量

LD_LIBRARY_PATH=/usr/local/pgsql/lib
export LD_LIBRARY_PATH
PATH=/usr/local/pgsql/bin:$PATH
export PATH
MANPATH=/usr/local/pgsql/share/man:$MANPATH
export MANPATH
#取代-D参数
PGDATA=/usr/local/pgsql/data
export PGDATA

创建database cluster

  • database cluster:

单独运行数据库服务实例下的数据库集合

  • 初始化database cluster
$ initdb -D /usr/local/pgsql/data
或者
$ pg_ctl -D /usr/local/pgsql/data initdb

systemd自启动

[Unit]
Description=PostgreSQL database server
Documentation=man:postgres(1)

[Service]
Type=forking
User=postgres
ExecStart=/usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data -l /usr/local/pgsql/data/log/postgres.log -s -w -t 300
ExecReload=/bin/kill -HUP $MAINPID
KillMode=mixed
KillSignal=SIGINT
TimeoutSec=0

[Install]
WantedBy=multi-user.target

结巴分词插件

git clone https://github.com/jaiminpan/pg_jieba

cd pg_jieba
USE_PGXS=1 make
USE_PGXS=1 make install 

jieba=# create extension pg_jieba;
CREATE EXTENSION

jieba=#  select * from to_tsvector('jiebacfg', '小明硕士毕业于中国科学院计算所，后在日本京都大学深造');
                                                 to_tsvector
--------------------------------------------------------------------------------------------------------------
 '中国科学院':5 '于':4 '后':8 '在':9 '小明':1 '日本京都大学':10 '毕业':3 '深造':11 '硕士':2 '计算所':6 '，':7
(1 row)

jieba=#  select * from to_tsvector('jiebacfg', '李小福是创新办主任也是云计算方面的专家');
                                        to_tsvector
-------------------------------------------------------------------------------------------
 '专家':11 '主任':5 '也':6 '云计算':8 '创新':3 '办':4 '方面':9 '是':2,7 '李小福':1 '的':10
(1 row)

创建用户角色

# 数据库的普通数据库用户
# 
createuser -e -P dbuser
# 创建用户的schema
create schema dbuser AUTHORIZATION dbuser

msys2 emacs连接无密码提示解决方法

修改%APPDATA%\postgresql\pgpass.conf添加hostname:port:database:username:password