Install psql without PostgreSQL
To use RisingWave, you need a PostgreSQL client, not the PostgreSQL server. The PostgreSQL official installers and packages come with all the components needed to run a PostgreSQL server, but some of these components are not needed for RisingWave.
psql, which is included in the PostgreSQL package, is a command-line interface for interacting with PostgreSQL databases. As RisingWave is wire-compatible with PostgreSQL, psql
becomes an essential tool for you to connect to RisingWave, issue SQL queries, and manage database objects.
To install psql
without the rest of the PostgreSQL package, you can use your operating system’s package manager. Here are the steps to install psql on some common operating systems:
- Install Homebrew if you don’t have it on your mac.
- Update package definitions (formulae).
- Install libpq.
Homebrew’s package for the PostgreSQL client tools is
libpq
, which includespsql
,pg_dump
, and other client utilities.
- Link all binaries of
libpq
to/usr/local/bin
.
libpq
does not install itself in the/usr/local/bin
directory. Thus, you need to link them to the directory to use the installed binaries.
- Install Homebrew if you don’t have it on your mac.
- Update package definitions (formulae).
- Install libpq.
Homebrew’s package for the PostgreSQL client tools is
libpq
, which includespsql
,pg_dump
, and other client utilities.
- Link all binaries of
libpq
to/usr/local/bin
.
libpq
does not install itself in the/usr/local/bin
directory. Thus, you need to link them to the directory to use the installed binaries.
- Update apt’s package list.
- Install the client packages.
- Install the repository RPM to point YUM at the PostgreSQL repository.
Go to Linux Downloads (Red Hat Family) and select your platform for the command and repository URL.
- Install the latest client packages.
Strange as it may seem,
postgresql
is the right package we are looking for in YUM.postgresql
— PostgreSQL client programs includingpsql
postgresql-server
— The complete set of programs required to set up a PostgreSQL server
Simply run:
postgresql
represents the PostgreSQL client programs includingpsql
in DNF.
For Windows users, please use the interactive installer by EDB.
This is the usual way of installing PostgreSQL on Windows. But to install the client only, select Command Line Tools and uncheck other options when selecting components during installation.
Was this page helpful?