The psql
command line tool is widely used for interacting with a PostgreSQL or
Timescale instance, and it is available for all operating systems. Most of
the instructions in the Timescale documentation assume you are using psql
.
Before you start, check that you don't already have psql
installed. It is
sometimes installed by default, depending on your operating system and other
packages you have installed over time:
psql --version
The psql
tool is installed by default on macOS systems when you install
PostgreSQL, and this is the most effective way to install the tool. On macOS you can use Homebrew or MacPorts to install the PostgreSQL package or just the psql
tool.
Install Homebrew, if you don't already have it:
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"For more information about Homebrew, including installation instructions, see the Homebrew documentation.
Make sure your Homebrew repository is up to date:
brew doctorbrew updateInstall PostgreSQL:
brew install postgresql
Install MacPorts by downloading and running the package installer.. For more information about MacPorts, including installation instructions, see the MacPorts documentation.
Install the latest version of Postgresql:
sudo port install postgresql<xx>For example, to install version 14 replace
postgresql<xx>
withpostgresql14
.- OptionalView the files that were installed:port contents postgresql<xx>
If you do not want to install the entire PostgreSQL package, you can install the psql
tool on its own. libpqxx
is the official C++ client API for PostgreSQL.
Install Homebrew, if you don't already have it:
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"For more information about Homebrew, including installation instructions, see the Homebrew documentation.
Make sure your Homebrew repository is up to date:
brew doctorbrew updateInstall
psql
:brew install libpqUpdate your path to include the
psql
tool.brew link --force libpqOn Intel chips, the symbolic link is added to
/usr/local/bin
. On Apple Silicon, the symbolic link is added to/opt/homebrew/bin
.
Install MacPorts by downloading and running the package installer. For more information about MacPorts, including installation instructions, see the MacPorts documentation.
Install the latest version of libpqxx:
sudo port install libpqxx- OptionalView the files that were installed by libpqxx:port contents libpqxx
You can use the apt
package manager on Debian and Ubuntu systems to install
the psql
tool.
Make sure your
apt
repository is up to date:sudo apt-get updateInstall the
postgresql-client
package:sudo apt-get install postgresql-client
The psql
tool is installed by default on Windows systems when you install
PostgreSQL, and this is the most effective way to install the tool. These
instructions use the interactive installer provided by PostgreSQL and
EnterpriseDB.
- Download and run the PostgreSQL installer from www.enterprisedb.com.
- In the
Select Components
dialog, checkCommand Line Tools
, along with any other components you want to install, and clickNext
. - Complete the installation wizard to install the package.
Keywords
Found an issue on this page?
Report an issue!