[TOC] ## 安裝 ## window 安裝包 安裝好后,出現` 用戶 "postgres" Password 認證失敗 `, 尋找data文件夾下面的`pg_hba.conf` 將最下面的 `scram-sha-256` 加密方式修改為` trust` 原 ``` # "local" is for Unix domain socket connections only local all all scram-sha-256 # IPv4 local connections: host all all 127.0.0.1/32 scram-sha-256 # IPv6 local connections: host all all ::1/128 scram-sha-256 ``` 改 ``` # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust ``` ### window choco 安裝 `choco install postgresql --params '/Password:123456' --params-global` ## docker ``` docker run -p 5432:5432 --name some-postgres -e POSTGRES_PASSWORD=123456 -d postgres ``` ## ubuntu 最新安裝方式查看 官網 ``` sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update sudo apt-get -y install postgresql ``` ## RedHat 系列 最新安裝方式查看 官網 ``` sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm sudo yum install -y postgresql15-server sudo /usr/pgsql-15/bin/postgresql-15-setup initdb sudo systemctl enable postgresql-15 sudo systemctl start postgresql-15 ``` 設置 postgres 密碼 ``` > su - postgres > psql -U postgres postgres=# \password ``` ### 配置遠程連接 /var/lib/pgsql/15/data/pg_hba.conf 添加一行 ``` host all all 0.0.0.0/0 md5 ``` /var/lib/pgsql/15/data/postgresql.conf ``` # - 配置文件：連接設置 - listen_addresses = '*' # 監聽地址，重啟數據庫軟件服務生效; port = 5432 # 監聽端口，重啟數據庫軟件服務生效; ```