PG查看表的死锁

1.查看数据库的进程。SELECT * FROM pg_stat_activity WHERE datname='死锁的数据库ID ';检索出来的字段中,【wating 】字段,数据为t的那条,就是死锁的进程,找到对应的【procpid 】列的值。例如:SELECT procpid FROM pg_stat_activity WHERE datname='数据库ID' and waiti...

继续阅读 »

ltsc2019(1809)上的wsl

配置 apt 国内源sed -i 's/archive.ubuntu.com/mirrors.aliyun.com/g' /etc/apt/sources.list # 更新源 apt update/etc/init.wsl#! /bin/sh # Filename: /etc/init.wsl # Usage: /etc/init.wsl [start|stop|restart] /etc...

继续阅读 »