pg 常用命令

su - postgres

psql


select * from pg_tables where schemaname = 'public' and tablename like '%user%';



select * from "system$user"




{BCrypt}$2a$12$wckD.qiSECeQP5U4Tw/X8uJ.3jC5XsD92N.G0oD0NGSX6jAAp37B2   admin123456

{BCrypt}$2a$12$eVbRQ.5mMko3DisnVltYaOasnHovFQc0McnZRetxAZ8Jn9YIJIsHO 	1


修改 MxAdmin 密码 admin123456
update "system$user" set password='{BCrypt}$2a$12$wckD.qiSECeQP5U4Tw/X8uJ.3jC5XsD92N.G0oD0NGSX6jAAp37B2' where id = '281474976710794'

 

显示最大连接数

SHOW max_connections;

　

修改最大连接数

vim /var/lib/postgresql/data/pgdata/postgresql.conf

max_connections = 1000