zgahxxwht的专栏

查看登录/退出日志是否打开show log_connections;show log_disconnections;打开日志alter system set log_connections=on;system set log_disconnections=on;

一，修改密码1，进入容器docker exec -it 834f03380346 bash2，修改密码二，远程访问设置1，修改配置文件1)、修改pg_hba.conf文件配置用户的访问权限（#开头的行是注释内容）：　　 # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Un...

1，nuget包2，模型 public class TestContext:DbContext { public DbSet<Blog> Blogs { get; set; } public DbSet<Post> Posts { get; set; } protected override void ...

1,CREATE FUNCTION instr(varchar, varchar) RETURNS integer AS $$DECLARE pos integer;BEGIN pos:= instr($1, $2, 1); RETURN pos;END;$$ LANGUAGE plpgsql STRICT IMMUTABLE;2,CREATE FUNCTION...

1，Postgresqlstring sql = "Host=**;Port =5432; Username=**;Password=**;Database=**;"; NpgsqlConnection conn = new NpgsqlConnection(sql); NpgsqlCommand cmd =conn.CreateComman...

安装postgresql-11sudo apt-get install postgresql-11 查看postgresql运行状态：systemctl status postgresql安装pgadmin41, sudo apt install python3-pip2,下载pgadmin4的python 包 https://www.post...

一、修改pg_hba.conf文件，配置用户的访问权限（#开头的行是注释内容）：　　 # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 loc...

1,查找地址终端输入：which psql结果：/usr/bin/psql2,3,修改为/user/bin