LoRaServer 笔记 1.2 基础依赖工具准备

sudo yum install mosquitto mosquitto-clients

# cat /etc/redhat-release 
CentOS Linux release 7.4.1708 (Core) 

yum install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm

> yum install postgresql11

yum install postgresql11-server

/usr/pgsql-11/bin/postgresql-11-setup initdb
systemctl enable postgresql-11
systemctl start postgresql-11

# sudo -u postgres psql
psql (11.2)
Type "help" for help.

postgres=# create role loraserver_as with login password 'dbpassword';
CREATE ROLE
postgres=# create role loraserver_ns with login password 'dbpassword';
CREATE ROLE
postgres=# create database loraserver_as with owner loraserver_as;
CREATE DATABASE
postgres=# create database loraserver_ns with owner loraserver_ns;
CREATE DATABASE
postgres=# \c loraserver_as
You are now connected to database "loraserver_as" as user "postgres".
loraserver_as=# create extension pg_trgm;
ERROR:  could not open extension control file "/usr/pgsql-11/share/extension/pg_trgm.control": No such file or directory
loraserver_as=# \q

# sudo yum install postgresql11-contrib

# sudo -u postgres psql
psql (11.2)
Type "help" for help.

postgres=# \c loraserver_as
You are now connected to database "loraserver_as" as user "postgres".
loraserver_as=# create extension pg_trgm;
CREATE EXTENSION
loraserver_as=# \q

redis-server --appendonly yes