1.预备好命令文件 loraserver.sql
create role loraserver_as with login password "dbpassword";
create role loraserver_ns with login password "dbpassword";
create database loraserver_as with owner loraserver_as;
create database loraserver_ns with owner loraserver_ns;
\c loraserver_as
create extension pg_trgm;
create extension hstore;
\qcreate role loraserver_as