nominatim(免费地图安装)
1. 安装依赖包
sudo yum update -y
sudo yum install -y epel-release
sudo yum install -y postgresql-server postgresql-contrib postgresql-devel
postgis postgis-utils
wget git cmake make gcc gcc-c++ libtool policycoreutils-python
php-pgsql php php-intl libpqxx-devel
proj-epsg bzip2-devel proj-devel libxml2-devel boost-devel
expat-devel zlib-devel
2 创建nominatim用户
sudo useradd -d /srv/nominatim -s /bin/bash -m nominatim
export USERNAME=nominatim
export USERHOME=/srv/nominatim
3 初始化 postgresql
sudo postgresql-setup initdb
sudo systemctl enable postgresql
sudo systemctl restart postgresql
4 创建postgresql 用户名
sudo -u postgres createuser -s $USERNAME (导数据账号)
sudo -u postgres createuser apache (读数据账号)
5 下载nominatim包编译,安装
cd $USERHOME
wget https://nominatim.org/release/Nominatim-3.4.2.tar.bz2
tar xf Nominatim-3.4.2.tar.bz2
cd $USERHOME
mkdir build
cd build
cmake $USERHOME/Nominatim-3.4.2
make
6 启动服务
systemctl restart php-php
备注
yum install postgresql96*
yum install postgis24_96
postgres 基本操作
1. 查看库
\l
2. 查看表
\d
3. 进入库
\c
授权
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO xiaoming; //赋予所有表的所有权限给xiaoming
GRANT ALL PRIVILEGES ON tuser TO wechart; // 赋予wechart用户,tuser表的所有权限