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).
Download PostgreSQL 10.6.1 for Windows. Fast downloads of the latest free software!
Paul MoorePaul Moore- PostgreSQL 64-bit is a powerful object-relational database management system! Download PostgreSQL Offline Installer Setup 64bit for PC! Download PostgreSQL Offline Installer Setup 64bit for PC! It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in.
- Mini Bytes: In this tutorial i am going to explain you about how to install PostgreSQL 10 in windows 10 and Linux operating system. Since there are many ways to install PostgreSQL 10, i am going to follow GUI installation in Window 10 and command line installation in Linux (Ubuntu 17.04 & CentOS 7).
3 Answers
Unfortunately there is no real client 'only' installer.
Postgresql 9.4 Download For Windows 10 64 Bit
What you can do, is to download the ZIP archive of the complete Postgres binaries:
and then remove the 'server' part from it.
When you unzip it, you get the following directories:
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
- 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)
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/.
Psql Download Windows 10
Then you'll be able to find those tools in folder like C:Program Files (x86)pgAdmin III1.22 or C:Program Files (x86)pgAdmin 4v2runtime, depends on the pgAdmin version you have installed.
Dmitrii MikhailovDownload Postgresql 9.5 For Windows 10
Dmitrii MikhailovPostgresql software, free download For Windows 10
Postgresql 9.3 Download For Windows 10 64 Bit
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.
