- Psql Download
- Postgresql Download For Windows 10 64-bit
- Postgresql Latest Version Download For Windows 10 64 Bit
- Postgresql 10.6 Download For Windows
PostgreSQL is a relational database system that belongs in the class of open-source software that stands out for its robustness, scalability, and accomplishment of SQL standards. There are versions available for a wide range of operating systems, including Linux, Windows, Mac OS X, Solaris, BSD, Tru64, and others. 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 and run the Windows PostgreSQL one click installer. When the wizard prompts you to choose where to install PostgreSQL, point it to the apps subdirectory of your, i.e. C: labkey apps postgresql-10.6 Keep track of the PostgreSQL Windows Service account name and password. LabKey Server needs to ask for it so that we can. PostgreSQL is a product developed by Marc Ligyanage.This site is not directly affiliated with Marc Ligyanage.All trademarks, registered trademarks, product names and company names or logos mentioned herein are the property of their respective owners.
Active1 year, 3 months ago
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).
Paul MoorePaul Moore3,1674 gold badges28 silver badges41 bronze badges
3 Answers
Unfortunately there is no real client 'only' installer.
Psql Download
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. Install weblogic 12c on windows.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
a_horse_with_no_namea_horse_with_no_nameunzip
to be the best 'installer' anyway (I also use that to install the Postgres server, the Windows installer just has too many quirks) 335k55 gold badges519 silver badges614 bronze badges
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/. Download tekken 6 pc torrent.
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. Tamil movie dhoom 3 download.Postgresql Download For Windows 10 64-bit
rogerdpack38.1k21 gold badges147 silver badges271 bronze badges
Dmitrii MikhailovDmitrii Mikhailov![Download postgresql 9.5 for windows 10 64 bit Download postgresql 9.5 for windows 10 64 bit](/uploads/1/3/3/8/133847430/504840177.png)
2,7524 gold badges31 silver badges49 bronze badges
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
RickRickserver
and pgadmin
in the installer's window when prompted to choose what I wanted to install.Postgresql Latest Version Download For Windows 10 64 Bit
3,6511 gold badge23 silver badges19 bronze badges