greater_wms/postgresql.md

先./ba一下

新建WMSDB

CREATE USER wmsuser WITH PASSWORD 'abc@1234';
GRANT ALL PRIVILEGES ON DATABASE wmsdb TO wmsuser;
GRANT ALL PRIVILEGES ON SCHEMA public TO wmsuser;
ALTER USER wmsuser SET client_encoding TO 'utf8';
ALTER USER wmsuser SET default_transaction_isolation TO 'read committed';
ALTER USER wmsuser SET timezone TO 'UTC';

安装postgresql适配器

pip install psycopg2-binary