PostgreSQL with Windows

[Monsores]

Hi All.
I found a web site with an article about using PostgreSQL over Windows 9x/Me/2K/XP using Cygwin (

http://pgsqlbr.querencialivre.rs.gov.br/index.php?corpo=tut_inst_win).

After reading the article my opinion (maybe wrong) is that PostgreSQL with Cygwin will work over Windows like a Windows program with Wine over Linux.
So, my question is: based in the fact that many Windows applications doesn´t work as they should under Linux+Wine, will PostgreSQL work under Windows+Cygwin exactly as it does straight in Linux?

Thanks and Regards,
Marcelo

 

[DubMartin]

I use Cygwin quite a bit but have not yet run PostgreSQL although I plan to try this. Using Cygwin, you have a Windows DLL that provides all the proper UNIX/Linux kernel APIs and passes the calls through to the Windows OS. The tools supplied with Cygwin, including PostgreSQL, are, for the most part, compiled from the same sources as other GNU implementations. I frequently compile UNIX/Linux source code using GCC and the makefile supplied with the source and have no problems. I often run XFree86 so I can run XDvi to view TeX/LaTeX output as I work.

I also run the bash shell in a Windows command prompt and often use UNIX commands to solve Windows problems just because I'm used to using them. Except for printing, I see no reason why one couldn't treat Windows as just another kernel and keep all user processes and interface activity entirely under the GNU system. This is handy if your work often requires a UNIX-like system at hand but you also need Windows functionality. Cygwin lets you have all the functionality of both environments without having to reboot or shell over to another system.

 

[Monsores]

I was afraid it wouldn't work as it should because I had some problems with Wine, but never used Cygwin.
I need this because I'm developing a small program that uses PostgreSQL, but the client decided to stop using Linux. The program is almost complete, so if I had to change the database it would be necessary many time to change and test everything.
I will try PostgreSQL+Cygwin

Thank you.
Marcelo

 

[uniware]

Cygwin + PostgreSQL works well.
But you may pay some attention to the performance.
I have used PostgreSQL 7.3 on Cygwin on a Windows 2000 box.

 

[tgharris]

Perhaps you could help me.

I have ActiveState ActivePerl 5.8.0 installed on my Windows 98SE system along with cygwin postgreSQL.
The problem is, I can't seem to connect with postgreSQL without the following:

<snip>

DBI connect('dbname=perl-begin;','tgharris',...) failed: Couldn't connect to /tmp/.s.PGSQL.5432:  at C:/Perl/site/lib/DBD/PgPP.pm line 124

Error (1): Couldn't connect to /tmp/.s.PGSQL.5432:  at C:/Perl/site/lib/DBD/PgPP
.pm line 124

</snip>

I don't understand what's going wrong. The DBI is looking in the right place, .s.PGSQL.5432 is exactly where it is supposed to be. Any ideas?



Tony Harris
tgharris_1@juno.com