PostgreSQL under Cygwin31 Dec 2015
As I wrote below I use Cygwin with Windows platform to achieve the Busi-do 😏. Yeah, I’m not looking for easy ways, really. To use the Cygwin is not easy way, but it really works for many tasks. If you work with databases there are two ways. First is to setup database directly into the Windows, the second is setup database into the Cygwin. The first way is easiest one, but may NOT working if you develop inside Cygwin.
At first you need setup PostgreSQL by Cygwin
setup-x86_64.exe. Don’t forget to install development package. If you program by Python and you need access the database and setup the
psycopg2 don’t forget to install the
$HOME/bin in your
The next step install the Windows service by:
After this you can run it by standard Windows service management console. But I don’t recommend run the service automatically when Windows start. We will do it manually.
Next enable the PostgreSQL in Cygwin by:
I use the start/stop script which I hold in
Check out if the
CYGWIN cygserver is stopped and won’t run automatically. It may prevent to function properly if you run database server manually.
If any questions write me in comments below.
Happy New 2016 Year for Everyone!