Thread: Re: [mail] Re: Windows Build System

Re: [mail] Re: Windows Build System

From
"Dave Page"
Date:

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 29 January 2003 16:57
> To: Dave Page
> Cc: Vince Vielhaber; Katie Ward; Curtis Faith;
> pgsql-hackers@postgresql.org
> Subject: Re: [mail] Re: [HACKERS] Windows Build System
>
>
> "Dave Page" <dpage@vale-housing.co.uk> writes:
> > I'll admit my methods were not particularly scientific, but
> over the
> > last few weeks I've had far more grief from DB2 and SQL
> Server than I
> > did from the PostgreSQL native betas.
>
> My gripe had to do with questioning the reliability of the
> platform, not of the Postgres port ;-).
>
> Aside from load testing as suggested by Vince, I'd be
> interested to hear what happens when you pull the power cord
> under load (repeatedly).  This would give some evidence about
> the robustness of the Windows filesystem and its ability to
> emulate Unix sync semantics.

OK, I can maybe do some testing on that next week (I'm off for a few
days from today). Is there anything in particular I should look out for,
or that you would want tested?

Katie, can I get the latest build from anywhere?

Regards, Dave.


Re: [mail] Re: Windows Build System

From
Tom Lane
Date:
"Dave Page" <dpage@vale-housing.co.uk> writes:
>> Aside from load testing as suggested by Vince, I'd be 
>> interested to hear what happens when you pull the power cord 
>> under load (repeatedly).  This would give some evidence about 
>> the robustness of the Windows filesystem and its ability to 
>> emulate Unix sync semantics.

> OK, I can maybe do some testing on that next week (I'm off for a few
> days from today). Is there anything in particular I should look out for,
> or that you would want tested?

Make sure your test load includes lots of updating queries, and look for
database corruption --- bad data, duplicated rows, lost rows, that sort
of thing.
        regards, tom lane


Re: [mail] Re: Windows Build System

From
Katie Ward
Date:
The latest build is still: ftp://209.61.187.152/postgres/postgres_beta4.zip

This is not exactly what Jan submitted, and the catalog number is slightly
different, but it should do for testing.

Katie


> -----Original Message-----
> From: Dave Page [mailto:dpage@vale-housing.co.uk]
> Sent: Wednesday, January 29, 2003 12:02 PM
> To: Tom Lane
> Cc: Vince Vielhaber; Katie Ward; Curtis Faith;
> pgsql-hackers@postgresql.org
> Subject: RE: [mail] Re: [HACKERS] Windows Build System
>
> Katie, can I get the latest build from anywhere?
>
> Regards, Dave.



Re: [mail] Re: Windows Build System

From
Justin Clift
Date:
Katie Ward wrote:
> The latest build is still: ftp://209.61.187.152/postgres/postgres_beta4.zip
> 
> This is not exactly what Jan submitted, and the catalog number is slightly
> different, but it should do for testing.

In case anyone's interested, there are step by step installation 
instructions for it at:

http://techdocs.postgresql.org/guides/InstallingOnWindows

;-)

Regards and best wishes,

Justin Clift


> Katie


-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi



Re: [mail] Re: Windows Build System

From
Jan Wieck
Date:
Dave Page wrote:
> 
> > -----Original Message-----
> > From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> > Sent: 29 January 2003 16:57
> > To: Dave Page
> > Cc: Vince Vielhaber; Katie Ward; Curtis Faith;
> > pgsql-hackers@postgresql.org
> > Subject: Re: [mail] Re: [HACKERS] Windows Build System
> >
> >
> > "Dave Page" <dpage@vale-housing.co.uk> writes:
> > > I'll admit my methods were not particularly scientific, but
> > over the
> > > last few weeks I've had far more grief from DB2 and SQL
> > Server than I
> > > did from the PostgreSQL native betas.
> >
> > My gripe had to do with questioning the reliability of the
> > platform, not of the Postgres port ;-).
> >
> > Aside from load testing as suggested by Vince, I'd be
> > interested to hear what happens when you pull the power cord
> > under load (repeatedly).  This would give some evidence about
> > the robustness of the Windows filesystem and its ability to
> > emulate Unix sync semantics.
> 
> OK, I can maybe do some testing on that next week (I'm off for a few
> days from today). Is there anything in particular I should look out for,
> or that you would want tested?
> 
> Katie, can I get the latest build from anywhere?

The code Katie wrote and tested, and what has been posted by me are two
different things. So what has been posted might not be that solid as a
rock as the beta's you got from PeerDirect. I will try to put some
binaries of what I posted together over the weekend.

That said, I don't quite understand the attitude of some people here. Is
it that if the native Win32 port as I posted it isn't as solid and
stable as v7.3 on Unix (well, some flavours), we will have to reject it?
With that ruleset (ruleset, what a word in this context ;-) we would not
have an SQL parser yet ...

Also, so far I have the impression not many people have actually taken a
look at the code itself. Everyone is busy bitching about the build
environment and if it is kosher to cook the code in Cygwin milk on a
Microsoft stove or not. Sorry guy's, but that's not the point! Does
anyone feel that the quality of our mainstream unix product is in
serious danger because of the code changes, required for the Win32 port,
which affect the unix environment? If so, could those please discuss
their feelings with their spouses or shrinks unless they can actually
point at specific areas of the code? 


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


Re: [mail] Re: Windows Build System

From
Jan Wieck
Date:
Katie Ward wrote:
> 
> The latest build is still: ftp://209.61.187.152/postgres/postgres_beta4.zip
> 
> This is not exactly what Jan submitted, and the catalog number is slightly
> different, but it should do for testing.

That binary at least demonstrates, what could be built based on the code
submitted.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #