telit

pg建序列

CREATE SEQUENCE lk_gh_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

alter table lk_gh alter column id set default nextval('lk_gh_id_seq');

 

netstat -tunlp | grep 3003

 

删库

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE datname='test_demo' AND pid<>pg_backend_pid();
pg_terminate_backend

DROP DATABASE test_demo

select datname ,datistemplate from pg_database where datname='dfhupms';

UPDATE pg_database SET datistemplate=false where datname='dfhupms';

 

minio 启动

docker run --name minio -p 9000:9000 -p 9001:9001 -d --restart=always --privileged=true -e "MINIO_ROOT_USER=fileadmin" -e "MINIO_ROOT_PASSWORD=fileadmin" -v /opt/minio/data:/data -v /opy/minio/config:/root/.minio minio/minio server  /data --console-address ":9001" --address ":9000"

 

 

    mybatis解决修改值为空的问题

@TableField(updateStrategy = FieldStrategy.IGNORED)



解决数值型长度过长经度丢失问题

@JsonFormat(shape = JsonFormat.Shape.STRING)

忽略返回实体中为空的字段

@JsonInclude(JsonInclude.Include.NON_NULL)