随笔分类 -  postgresql

摘要:创建文件存储库配置 echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list 导入存储库签名密钥 wget --quiet - 阅读全文
posted @ 2023-03-01 14:19 小吉猫 阅读(544) 评论(0) 推荐(0)
摘要:方法一:.pgpass 查看postgres家目录 grep postgres /etc/passwd postgres:x:114:119:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash 创建.pgpass touch /var/ 阅读全文
posted @ 2023-03-01 14:19 小吉猫 阅读(144) 评论(0) 推荐(0)
摘要:pg_hba.conf 文件格式 local database user auth-method [auth-options] host database user address auth-method [auth-options] hostssl database user address au 阅读全文
posted @ 2023-03-01 14:08 小吉猫 阅读(57) 评论(0) 推荐(0)