how to set up the psql command in cygwin?

apache postgresql cygwin psql
chaonextdoor picture chaonextdoor · Jan 23, 2013 · Viewed 11.2k times · Source

I have a local dev site on my machine with Apache server and PostgreSQL 9.1 database. As I'm using Windows, I also installed Cygwin. I want to access to database and make some queries via Cygwin insead of pgAdmin III, but it tells me that psql command not found. How should I set up the psql command in cygwin?

Answer

Cao Minh Tu picture Cao Minh Tu · Jan 11, 2017

As of today, you just have to install postgresql-client package in cygwin:

  • Run your cygwin setup.exe file (this can be run multiple times to add more packages).
  • Type postgresql into the search box, select postgresql-client and press "next" to install.

enter image description here

Now you can open Cygwin terminal and type psql to run!

enter image description here

Related questions

Call to undefined function pg_connect() - Wamp

I want to connect to PostgreSQL, Im using wamp 64 bit. I have here Apache 2.4.2 PHP 5.4.3 Mysql 5.5.24 I also uncomment in php.ini the php_pgsql and php_pdo_pgsql. but i can't connect , It gives me error like this : Error …

Read More
org.apache.axis2.AxisFault connection refused

I'm getting the following error while tryng to suscribe to a service from client app. Can somebody tell me the reason for this exception? Thanks in advance org.apache.axis2.AxisFault: Conexión rehusada at org.apache.axis2.AxisFault.makeFault(…

Read More
Django, mod_wsgi, psycopg2 ImproperlyConfigured: Error loading psycopg2 module: No module named _psycopg

I have a Django 1.5, Python 2.7 site running under Apache with mod_wsgi on a CentOS 6.4 server. I have rebuilt this site using Django 1.6 and Python 3.3. Deploying it to the same server and changing the paths in httpd.conf I get …

Read More