Re: PostgreSQL windows native port available - Mailing list pgadmin-hackers

From Dave Page
Subject Re: PostgreSQL windows native port available
Date
Msg-id 214E9C0A75426D47A876A2FD8A07426E974F@salem.vale-housing.co.uk
Whole thread Raw
In response to PostgreSQL windows native port available  (Jean-Michel POURE <jm.poure@freesurf.fr>)
Responses Re: PostgreSQL windows native port available  (Jean-Michel POURE <jm.poure@freesurf.fr>)
List pgadmin-hackers

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 10 May 2002 10:07
> To: pgadmin-hackers@postgresql.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.

pgadmin-hackers by date:

Previous
From: Jean-Michel POURE
Date:
Subject: PostgreSQL windows native port available
Next
From: Jean-Michel POURE
Date:
Subject: Re: PostgreSQL windows native port available