How do I install just the client tools for PostgreSQL on Windows?

Question

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).

Why don't use ssh into your linux machine and use psql there? — mehmet, Nov 22 '15 at 17:11
Basically because any scripts I develop will be on my local PC, and so running from there is easier. All my development work is at the Windows console prompt, so running my SQL from there as well is just more convenient. — Paul Moore, Nov 23 '15 at 14:10
@mehmet he's asking for a client, if he's asking for that is obvious that he doesn't need/want/can't run psql in the Linux machine. — VaTo, Apr 05 '18 at 17:30
Answer by @Fact below should be the accepted answer as of 2020. — G-Mac, Oct 19 '21 at 18:56

score 65 · Answer 1 · answered Feb 24 '20 at 03:37

65

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.

answered Feb 24 '20 at 03:37

Fact

1,957
1
17
26

5

This is the easiest, yet better way, imho. – ata Jul 13 '21 at 04:27
2

This should be the accepted answer as of 2022 – Meursault Aug 13 '22 at 14:08

score 64 · Accepted Answer · 2020-07-08T19:56:48.940

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)

Thanks. I'm not actually too worried about stripping out the unneeded server bits - the main thing I want to avoid is the installer creating accounts, the service and a database - so just having the zip distribution is fine. I looked for this first, but could only find the installer on the EnterpriseDB site (the postgresql site points only to http://www.enterprisedb.com/products-services-training/pgdownload and there's no link from there to the bin download page :-(). — Paul Moore, Nov 23 '15 at 14:15
Whoops. Just noticed the "advanced users" link on the postgresql.org download page. I must have missed that last time. — Paul Moore, Nov 23 '15 at 14:17
For anyone on PostgreSQL >= 9.6.3 wondering where `iconv.dll` went, bring in `libiconv-2.dll` instead. — Anthony Neace, Sep 22 '17 at 17:50
Can confirm that this still works in 2020. Very helpful for having psql.exe for the client tool only. — Doug S, Jul 08 '20 at 19:54
@a_horse_with_no_name i am getting this error during binary zip installation " initdb.exe initialize a database cluster has stopped working" any ideas are highly appreciated? — Dragon, Apr 09 '21 at 21:38

score 34 · Answer 3 · edited Oct 27 '17 at 18:47

34

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.

edited Oct 27 '17 at 18:47

rogerdpack

62,887
36
269
388

answered Mar 23 '17 at 07:15

Dmitrii Mikhailov

5,053
7
43
69

score 14 · Answer 4 · edited Oct 24 '22 at 03:32

14

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.

edited Oct 24 '22 at 03:32

Yuri Astrakhan

8,808
6
63
97

answered Oct 31 '19 at 10:32

Geoff

141
1
2

Thanks. This list was exactly what I was looking for. Much appreciated. – F.D.Castel Feb 15 '20 at 03:17

score 13 · Answer 5 · answered Jun 08 '18 at 14:31

13

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.

answered Jun 08 '18 at 14:31

Rick

4,575
1
26
20

3

Note, as of today I see two Windows installers in the PostgreSQL web site and only one of them has the option to install only the command line tools. The EnterpriseDB installer has the option, the BigSQL installer does not have a command line tools only option. – SeanN Jul 31 '18 at 15:45

score 13 · Answer 6 · answered Oct 29 '20 at 13:39

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

The accepted answer is... wrong. This should be the answer – Michael Fulton Apr 18 '21 at 23:37 — Michael Fulton, Apr 18 '21 at 23:37

score 6 · Answer 7 · answered Oct 18 '21 at 18:24

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

score 1 · Answer 8 · edited Jan 14 '21 at 16:40

1

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.

edited Jan 14 '21 at 16:40

zhisme

2,368
2
19
28

answered Jan 13 '21 at 15:00

ax1ine

11
2

score 1 · Answer 9 · answered Dec 24 '22 at 08:14

1

I built standalone versions for windows and linux. It has less dll dependecies and smaller size and work with many linux.

https://github.com/hemnstill/StandaloneTools/releases?q=pg_dump

answered Dec 24 '22 at 08:14

hemn

365
2
9

score 0 · Answer 10 · answered Aug 24 '21 at 18:14

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

score 0 · Answer 11 · answered Feb 07 '23 at 12:56

0

You can also download "https://www.nuget.org/packages/Postgres.psql" nuget package to get "psql.exe"

answered Feb 07 '23 at 12:56

Drasius

825
1
11
26

How do I install just the client tools for PostgreSQL on Windows?

11 Answers11

Linked