How do I install just the client tools for PostgreSQL on Windows?
WindowsPostgresqlWindows Problem Overview
I have a PostgreSQL database on a Linux system that I want to access from my Windows PC. But the only Windows binaries I have been able to find are the full installer, which includes the database server and client.
Is it possible to get a client-only Windows binary install for PostgreSQL from anywhere?
(To clarify, I want the standard PostgreSQL client, psql - not a GUI client or independent tool).
Windows Solutions
Solution 1 - Windows
Unfortunately there is no real client "only" installer.
What you can do, is to download the ZIP archive of the complete Postgres binaries:
http://www.enterprisedb.com/products-services-training/pgbindownload
and then remove the "server" part from it.
When you unzip it, you get the following directories:
bin doc include lib pgAdmin III share StackBuilder symbols
You can remove the doc
, include
, pgAdmin III
, StackBuilder
and symbols
directories. As far as I can tell (but I am not sure) the client also doesn't need the share
or lib
directories, but you would need to test that. So that leaves only the bin
directory.
I think the share
directory could be needed for localized error messages in psql
but I'm not sure about that.
Inside the bin
directory you can essentially remove all .exe files (except psql.exe
of course). You can also remove all wx*.dll
files, they are only needed for pgAdmin. The libxml2.dll
and libxslt.dll
are also only needed for the server.
If you do want some of the other client tools, you might want to keep
- pg_dump.exe
- pg_dumpall.exe
- pg_restore.exe
One drawback of this approach is that this requires the Visual C++ Redistributable to be installed. But you can overcome that as well by simply putting the MSVCR120.DLL
from some computer where it is installed into the bin
directory.
So that leaves you with these files (from the bin
directory) that are required for the psql client:
- iconv.dll (libiconv-2.dll in newer Postgres versions)
- libeay32.dll
- libintl-8.dll
- libpq.dll
- msvcr120.dll
- ssleay32.dll
- zlib1.dll
- psql.exe
Of course you can also take all that from an existing Postgres installation without the need to download the ZIP archive.
It is obviously not a real installer, but if you put the cleaned up directory into a ZIP file, you can distribute that and whoever needs it just unzips the archive. Personally I find unzip
to be the best "installer" anyway (I also use that to install the Postgres server, the Windows installer just has too many quirks)
Solution 2 - Windows
As of 2020, when you click download the full installer from here , click next and next and you get the option to install only the command line - tools . Remember to add the path to the bin folder in the PATH variable.
Solution 3 - Windows
Actually there are client CLI tools in pgAdmin. All you need is just to install it on your Windows machine from https://www.postgresql.org/download/windows/.
Then you'll be able to find those tools in folder like C:\Program Files (x86)\pgAdmin III\1.22
or C:\Program Files (x86)\pgAdmin 4\v2\runtime
, depends on the pgAdmin version you have installed.
Solution 4 - Windows
Thanks to everyone who has posted on this thread.
For what it's worth, I got psql.exe from PostgreSQL 10.10 working under Windows 10 with just the following files from the zip archive:
> libcrypto-1_1-x64.dll
>libiconv-2.dll
>libintl-8.dll
>libpq.dll
> libssl-1_1-x64.dll
>psql.exe
When connecting to AWS Redshift, I got the following error:
> psql: FATAL: invalid value for parameter "client_encoding": "WIN1252"
I resolved this by running
set PGCLIENTENCODING=UTF8
I found this solution at https://forums.aws.amazon.com/thread.jspa?messageID=600088
HTH.
Solution 5 - Windows
I realize this is an older question, but when I used the Windows installer for the latest version of Postgres (10.4), it gave me the option to install just the command line tools. I just unchecked server
and pgadmin
in the installer's window when prompted to choose what I wanted to install.
Solution 6 - Windows
Below are the steps I followed to connect to Amazon Redshift with postgres12 psql on windows:
-
download postgres 12.4 from below location: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
-
run the installer which will take few minutes and prompt you for installations options
-
select
command line tools
as shown in below screenshot and install that -
Above will install postgres12 command line in below folder
C:\Program Files\PostgreSQL\12\bin
. Make sure to add this to your PATH environment variable -
open cmd and run command
set PGCLIENTENCODING=UTF8
-
run psql to connect to redshift. Make sure to change below parameters highlighted in red for your cluster endpoint, userid, copy script file name and log script file name respectively
psql -h redshift-cluster-1.abcdefgh.us-east-1.redshift.amazonaws.com -U demo_user -d dev -p 5439 -f d:\demo\redshift_script.sql -L d:\demo\log_redshift_script.log
-
all commands in redshift_script.sql file would get executed in PSQL and logs will be stored in log_redshift_script.log file
Solution 7 - Windows
There is a third-party command-line tool available known as PGCLI - A command-line interface for Postgres with auto-completion and syntax highlighting.
Install:
pip install pgcli
Connect to POSTGRES Server from Command-line:
pgcli -h localhost -U xyz -d app_db
For official documentation, visit PGCLI
Solution 8 - Windows
If there's pgadmin v4
installed then just copy these libraries (from C:\Program Files\pgAdmin 4\v4\runtime\
):
libcrypto-1_1-x64.dll
libpq.dll
libssl-1_1-x64.dll
These were enough for me to connect from a client Windows 10 x64 PC to a remote Postgres 13 server. Note, that libraries coming with the ZIP archive mentioned above are slightly different and have more dependencies.
Solution 9 - Windows
I kind of cheat. I install sqlbackupandftp.com on a Windows server - which has a free version that can schedule a single database backup. In the binaries, pg_dump.exe is there - typically on the C: drive like C:\Program Files (x86)\SQLBackupAndFTP\dbms\PostgreSql