linux 下pgsql创建外链的用户

修改pg_hba.conf文件：

• 文件通常位于/etc/postgresql/[版本号]/main/或/var/lib/pgsql/data/目录

# IPv4 local connections:
host    all             all             192.168.1.0/24          md5

4. 重启PostgreSQL服务

sudo systemctl restart postgresql

5. 确认端口已开放

sudo netstat -tuln | grep 5432

如何查看pgsql用户列表

SELECT usename AS role_name,
CASE 
    WHEN usesuper AND usecreatedb THEN 
      CAST('superuser, create database' AS pg_catalog.text)
    WHEN usesuper THEN 
       CAST('superuser' AS pg_catalog.text)
    WHEN usecreatedb THEN 
       CAST('create database' AS pg_catalog.text)
    ELSE 
       CAST('' AS pg_catalog.text)
 END role_attributes

    
FROM pg_catalog.pg_user
ORDER BY role_name desc;

CREATE ROLE your_username LOGIN SUPERUSER PASSWORD 'your_password';