数据库：PostgreSQL：客户端安装

浅浅的花香味﹌ 2022-12-02 13:38 786阅读 0赞

![在这里插入图片描述][20200830141348384.jpeg_pic_center_pic_center]

这篇文章介绍一下PostgreSQL的客户端安装方法。

--------------------

### 文章目录 ###

*  Ubuntu
 *  Debian
 *  Windows
 *  macOS
 *   *  方法1: 使用brew安装整体的包
     *  方法2: 使用官方的安装包
     *  方法3: 使用Postgres.app
     *  方法4: 使用libpq
     *   *  环境确认
         *  brew update
         *  brew install libpq
         *  结果确认
 *  总结

--------------------

# Ubuntu #

执行如下安装命令：

> sudo apt-get update  
> sudo apt-get install postgresql-client

--------------------

# Debian #

执行如下安装命令：

> sudo apt-get update  
> sudo apt-get install postgresql-client

--------------------

# Windows #

安装方法参看：

*  [https://www.postgresql.org/download/windows/][https_www.postgresql.org_download_windows]

--------------------

# macOS #

在macOS下有多种安装方法，主要如下所示

## 方法1: 使用brew安装整体的包 ##

macOS下PostgreSQL只提供了postgres的包，可以通过如下命令安装全体的包

> 执行命令：brew install postgres

## 方法2: 使用官方的安装包 ##

使用官方的安装包，一路Next就可以安装完成了，下载地址为：

*  [https://www.postgresql.org/download/macosx/][https_www.postgresql.org_download_macosx]

## 方法3: 使用Postgres.app ##

Postgres.app把相关需要的内容都进行了打包，下载地址为：

*  [https://postgresapp.com/downloads.html][https_postgresapp.com_downloads.html]

官方目前已经测试过的相关版本信息如下  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdW1pYW9jbg_size_16_color_FFFFFF_t_70_pic_center]

## 方法4: 使用libpq ##

如果你只希望安装客户端，那可以考虑使用libpq来代替，安装方式如下所示

### 环境确认 ###

liumiaocn:~ liumiao$ sw_vers
    ProductName:	Mac OS X
    ProductVersion:	10.15.6
    BuildVersion:	19G73
    liumiaocn:~ liumiao$

### brew update ###

确认brew状态，使用如下命令：

> 执行命令：brew doctor

liumiaocn:~ liumiao$ brew doctor
    Please note that these warnings are just used to help the Homebrew maintainers
    with debugging if you file an issue. If everything you use Homebrew for is
    working fine: please don't worry or file an issue; just ignore this. Thanks!
    
    Warning: The following directories do not exist:
    /usr/local/sbin
    
    You should create these directories and change their ownership to your account.
      sudo mkdir -p /usr/local/sbin
      sudo chown -R $(whoami) /usr/local/sbin
    liumiaocn:~ liumiao$

执行brew update

liumiaocn:~ liumiao$ brew update
    ==> Downloading https://homebrew.bintray.com/bottles-portable-ruby/portable-ruby-2.6.3_2.yosemite.bottle.tar.gz
    ################################################################################################################################# 100.0%
    ==> Pouring portable-ruby-2.6.3_2.yosemite.bottle.tar.gz
    ==> Homebrew has enabled anonymous aggregate formulae and cask analytics.
    Read the analytics documentation (and how to opt-out) here:
      https://docs.brew.sh/Analytics
    No analytics have been recorded yet (or will be during this `brew` run).
    
    Updated 3 taps (homebrew/core, homebrew/cask and homebrew/services).
    ...省略
    gambit                                        podman                                        youview
    ghostlab                                      pokemon-trading-card-game-online
    liumiaocn:~ liumiao$

### brew install libpq ###

liumiaocn:~ liumiao$ brew install libpq
    ==> Downloading https://homebrew.bintray.com/bottles/openssl%401.1-1.1.1g.catalina.bottle.tar.gz
    ...省略
    Bash completion has been installed to:
      /usr/local/etc/bash_completion.d
    liumiaocn:~ liumiao$

### 结果确认 ###

本文安装的内容可以在如下目录下查询到

liumiaocn:bin liumiao$ pwd
    /usr/local/Cellar/libpq/12.4/bin
    liumiaocn:bin liumiao$ ls
    clusterdb		initdb			pg_ctl			pg_resetwal		pg_waldump
    createdb		pg_archivecleanup	pg_dump			pg_restore		pgbench
    createuser		pg_basebackup		pg_dumpall		pg_rewind		psql
    dropdb			pg_checksums		pg_isready		pg_test_fsync		reindexdb
    dropuser		pg_config		pg_receivewal		pg_test_timing		vacuumdb
    ecpg			pg_controldata		pg_recvlogical		pg_upgrade
    liumiaocn:bin liumiao$

可以看到已经有psql等命令了，所以只需要将bin追加至PATH中即可。也可每次都带上全路径进行访问。

liumiaocn:bin liumiao$ /usr/local/Cellar/libpq/12.4/bin/psql --version
    psql (PostgreSQL) 12.4
    liumiaocn:bin liumiao$

--------------------

# 总结 #

这篇文章介绍了一下常见的操作系统下的Postgres客户端的安装方式。

[20200830141348384.jpeg_pic_center_pic_center]: /images/20221123/09da3e5b728d4fc8bb02364a7a24aa38.png
[https_www.postgresql.org_download_windows]: https://www.postgresql.org/download/windows/
[https_www.postgresql.org_download_macosx]: https://www.postgresql.org/download/macosx/
[https_postgresapp.com_downloads.html]: https://postgresapp.com/downloads.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdW1pYW9jbg_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/c289a98f995e41f4b162e79d02186b8f.png