Re: PostgreSQL windows native port available

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Sent: 10 May 2002 10:07
> To: pgadmin-hackers(at)postgresql(dot)org
> Cc: Dave Page
> Subject: [pgadmin-hackers] PostgreSQL windows native port available
>
>
> Dear Dave,
>
> Some hackers are now discussing about importing PostgreSQL
> Windows port
> http://hp.vector.co.jp/authors/VA023283/PostgreSQLe.html into
> PostgreSQL main
> tree.
>
> How long would it take to release a clean installer for
> PostgreSQLe existing
> binaries. Some say it is a very stable solution. This would
> be nice to
> release both pgAdmin2 and PostgreSQL on bloodshed.

Have you actually tried it? I did last night & deleted it shortly
afterwards. There are a number of problems:

1) All databases are EUC_JP encoded.
2) It doesn't run as a service, but as an application.
3) It doesn't support multi-session (from the docs, I'm not sure what it
means, but perhaps 5).
4) It doesn't support transaction isolation.
5) It crashes with more than one pgbench connection.

Basically, I think they just ripped out all the things that are a
problem in Win32 (like fork() & IPC) and made a single user version,
rather than writing Win32 versions.

I think that a stripped down cygwin version is the (easy) way forward. I
think that's what MySQL do, certainly the cygwin dll is distributed with
it. All that is really required is the rewriting of probably pg_dumpall,
initdb & initlocation - the rest of the scripts aren't needed, and a
binary-only version would then be easy bar licencing issues.

Writing an installer is easy enough as well...

Regards, Dave.