Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL windows native port available

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <jm(dot)poure(at)freesurf(dot)fr>, <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: PostgreSQL windows native port available
Date: 2002-05-10 09:21:00
Message-ID: 214E9C0A75426D47A876A2FD8A07426E974F@salem.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers

> -----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.

Responses

pgadmin-hackers by date

Next:From: Jean-Michel POUREDate: 2002-05-10 10:28:41
Subject: Re: PostgreSQL windows native port available
Previous:From: Jean-Michel POUREDate: 2002-05-10 09:07:04
Subject: PostgreSQL windows native port available

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group