Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-13 Thread Chris Browne
robertmh...@gmail.com (Robert Haas) writes: > On Fri, Jan 8, 2010 at 10:12 AM, Dave Page wrote: >>> I have long spoken against making Windows a second class citizen. But I >>> don't think David is going to do that (and I'll hound him if he does). But >>> that doesn't mean it has to be fully suppor

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Stefan Kaltenbrunner
Magnus Hagander wrote: On Fri, Jan 8, 2010 at 18:48, Dave Page wrote: 2010/1/8 Magnus Hagander : On Fri, Jan 8, 2010 at 18:44, Dave Page wrote: The current set of active mirrors can always be found at http://www.postgresql.org/mirrors.xml, so you can build URLs on the mirror network using th

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread David E. Wheeler
On Jan 8, 2010, at 10:08 AM, Magnus Hagander wrote: > That, or implement that "send me to a random mirror" feature. Or > maybe the "send me to a random close mirror if available, or a random > global if not" feature. :-) > > Either way, there's definitely room for some improvement there, but > l

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Magnus Hagander
On Fri, Jan 8, 2010 at 18:48, Dave Page wrote: > 2010/1/8 Magnus Hagander : >> On Fri, Jan 8, 2010 at 18:44, Dave Page wrote: >>> The current set of active mirrors can always be found at >>> http://www.postgresql.org/mirrors.xml, so you can build URLs on the >>> mirror network using the protocol,

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Magnus Hagander
On Fri, Jan 8, 2010 at 18:55, David E. Wheeler wrote: > On Jan 8, 2010, at 9:38 AM, Magnus Hagander wrote: > >> Is there a particular reason not to use the existing mirroring network >> to distribute the files? If not, then I suggest using them should be >> part of the design. > > No, as long as P

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread David E. Wheeler
On Jan 8, 2010, at 9:59 AM, Dave Page wrote: > Either can be arranged. For StackBuilder, we created a pgFoundry > project, so files can just be uploaded there by authorised users, from > where they get replicated back onto the mirror network. > > Which leads us neatly back to the GForge URL threa

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Dave Page
On Fri, Jan 8, 2010 at 5:55 PM, David E. Wheeler wrote: > On Jan 8, 2010, at 9:38 AM, Magnus Hagander wrote: > >> Is there a particular reason not to use the existing mirroring network >> to distribute the files? If not, then I suggest using them should be >> part of the design. > > No, as long as

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread David E. Wheeler
On Jan 8, 2010, at 9:38 AM, Magnus Hagander wrote: > Is there a particular reason not to use the existing mirroring network > to distribute the files? If not, then I suggest using them should be > part of the design. No, as long as PAUS can drop uploaded distributions onto the master FTP server,

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread David E. Wheeler
On Jan 8, 2010, at 9:24 AM, Dave Page wrote: > If that is the goal of your project then I withdraw my previous > comments, which were written on the belief that you were proposing a > generic distribution/build/installation system for PostgreSQL users. It is a generic distribution and installatio

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Dave Page
2010/1/8 Magnus Hagander : > On Fri, Jan 8, 2010 at 18:44, Dave Page wrote: >> The current set of active mirrors can always be found at >> http://www.postgresql.org/mirrors.xml, so you can build URLs on the >> mirror network using the protocol, host, port and path from the mirror >> list, and then

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Magnus Hagander
On Fri, Jan 8, 2010 at 18:44, Dave Page wrote: > On Fri, Jan 8, 2010 at 5:38 PM, Magnus Hagander wrote: >> On Thu, Jan 7, 2010 at 21:07, David E. Wheeler wrote: >>> Hackers, >>> >>> I've posted a [plan] to implement PGAN][], a CPAN for PostgreSQL >>> extensions. I've tried to closely follow the

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Dave Page
On Fri, Jan 8, 2010 at 5:38 PM, Magnus Hagander wrote: > On Thu, Jan 7, 2010 at 21:07, David E. Wheeler wrote: >> Hackers, >> >> I've posted a [plan] to implement PGAN][], a CPAN for PostgreSQL extensions. >> I've tried to closely follow the [CPAN philosophy][] to come up with a plan >> that re

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Magnus Hagander
On Thu, Jan 7, 2010 at 21:07, David E. Wheeler wrote: > Hackers, > > I've posted a [plan] to implement PGAN][], a CPAN for PostgreSQL extensions. > I've tried to closely follow the [CPAN philosophy][] to come up with a plan > that requires a minimum-work implementation that builds on the existin

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Greg Stark
On Fri, Jan 8, 2010 at 5:13 PM, David E. Wheeler wrote: > Please let the Windows thread die now. PGAN doesn't ignore Windows; it > ignores installer development. > yeah, I think there are two quite separable projects here. It's quite possible that once the binary installer people have a source p

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Dave Page
On Fri, Jan 8, 2010 at 5:13 PM, David E. Wheeler wrote: > This whole bit about Windows is a red herring. Perhaps I should not have > phrased it the way I did WRT Windows. So I'm going to change it to: > >> The PGAN client will make no other assumptions about how to build and >> install extensio

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread David E. Wheeler
On Jan 8, 2010, at 1:35 AM, Dave Page wrote: > I am saying that if the design won't ever work without requiring > painful dependency installation that users will likely not want to > bother with, then it is fundamentally broken. Better to write one > system that can _eventually_ work everywhere, t

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Stephen Frost
Dave, * Dave Page (dp...@pgadmin.org) wrote: > Right - but the buildfarm isn't a feature being offered to end users. And this network isn't a feature of the core code either, nor, do I believe, is it being designed in a way that would require an overhaul down the road to support Windows. To be h

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Dave Page
On Fri, Jan 8, 2010 at 4:34 PM, Joshua D. Drake wrote: > On Fri, 2010-01-08 at 16:33 +, Dave Page wrote: >> On Fri, Jan 8, 2010 at 3:56 PM, Joshua D. Drake >> wrote: >> > On Fri, 2010-01-08 at 15:12 +, Dave Page wrote: >> >> Hey Andrew >> >> >> >> On Fri, Jan 8, 2010 at 12:57 PM, Andrew

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Joshua D. Drake
On Fri, 2010-01-08 at 16:33 +, Dave Page wrote: > On Fri, Jan 8, 2010 at 3:56 PM, Joshua D. Drake > wrote: > > On Fri, 2010-01-08 at 15:12 +, Dave Page wrote: > >> Hey Andrew > >> > >> On Fri, Jan 8, 2010 at 12:57 PM, Andrew Dunstan > >> wrote: > >> > > >> > Windows came late to the bui

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Dave Page
On Fri, Jan 8, 2010 at 3:56 PM, Joshua D. Drake wrote: > On Fri, 2010-01-08 at 15:12 +, Dave Page wrote: >> Hey Andrew >> >> On Fri, Jan 8, 2010 at 12:57 PM, Andrew Dunstan wrote: >> > >> > Windows came late to the buildfarm. According to the CVS log, the buildfarm >> > client was first check

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Joshua D. Drake
On Fri, 2010-01-08 at 15:12 +, Dave Page wrote: > Hey Andrew > > On Fri, Jan 8, 2010 at 12:57 PM, Andrew Dunstan wrote: > > > > Windows came late to the buildfarm. According to the CVS log, the buildfarm > > client was first checked in in Sept 2004, got initial Mingw support in Jan > > 2005 a

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Robert Haas
On Fri, Jan 8, 2010 at 10:12 AM, Dave Page wrote: >> I have long spoken against making Windows a second class citizen. But I >> don't think David is going to do that (and I'll hound him if he does). But >> that doesn't mean it has to be fully supported from day one. > > I'm not saying it should be

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Dave Page
Hey Andrew On Fri, Jan 8, 2010 at 12:57 PM, Andrew Dunstan wrote: > > Windows came late to the buildfarm. According to the CVS log, the buildfarm > client was first checked in in Sept 2004, got initial Mingw support in Jan > 2005 and MSVC support in March 2007, when we finally got some of the too

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Magnus Hagander
On Fri, Jan 8, 2010 at 15:14, Ron Mayer wrote: > Magnus Hagander wrote: >> On Fri, Jan 8, 2010 at 05:22, Ron Mayer >> wrote: >>> David E. Wheeler wrote: On Jan 7, 2010, at 1:31 PM, Dave Page wrote: > No, I'm suggesting the mechanism needs to support source and binary > distribution.

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Ron Mayer
Magnus Hagander wrote: > On Fri, Jan 8, 2010 at 05:22, Ron Mayer wrote: >> David E. Wheeler wrote: >>> On Jan 7, 2010, at 1:31 PM, Dave Page wrote: No, I'm suggesting the mechanism needs to support source and binary distribution. For most *nix users, source will be fine. For Windows

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Andrew Dunstan
Dave Page wrote: The only reason we ever offer different functionality on different platforms is when there are external reasons forcing us to - for example, lack of reparse points in NTFS on Windows NT 4.0 prevented us offering table space support, and for some time we had no Win32 port of lib

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Dave Page
On Fri, Jan 8, 2010 at 10:40 AM, Markus Wanner wrote: > Hi, > > Josh Berkus wrote: >> >> Dave wrote: >>> >>> and frankly, >>> isn't the way this project generally works. > > Isn't it? We didn't even support Windows for quite a long time. No, it's quite different for the PostgreSQL not to support

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Markus Wanner
Hi, Josh Berkus wrote: Dave wrote: and frankly, isn't the way this project generally works. Isn't it? We didn't even support Windows for quite a long time. We still have lots more active Unix developers and knowledge that Windows ones. And isn't there some "scratch your own itch" philosophy

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Dave Page
On Thu, Jan 7, 2010 at 10:07 PM, Josh Berkus wrote: >> Building them is no problem - authors can easily use EC2 for which we >> have an AMI pre-configured for next to no cost, can build on their own >> platform, on a community provided system, or get a friend to do it. > > So any module author, in

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Magnus Hagander
On Fri, Jan 8, 2010 at 05:22, Ron Mayer wrote: > David E. Wheeler wrote: >> On Jan 7, 2010, at 1:31 PM, Dave Page wrote: >>> No, I'm suggesting the mechanism needs to support source and binary >>> distribution. For most *nix users, source will be fine. For Windows >>> binaries are required. >> >>

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-08 Thread Jim Nasby
On Jan 7, 2010, at 4:07 PM, Josh Berkus wrote: > Building a simple solution which doesn't initially cover all bases but > can be steadily improved is a far superior strategy to trying to spec > The Perfect Solution before even starting work. And if we want to keep > recruiting new contributors, cr

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Ron Mayer
David E. Wheeler wrote: > On Jan 7, 2010, at 1:31 PM, Dave Page wrote: >> No, I'm suggesting the mechanism needs to support source and binary >> distribution. For most *nix users, source will be fine. For Windows >> binaries are required. > > I would love to follow what Strawberry Perl has done to

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Stephen Frost
* Dave Page (dp...@pgadmin.org) wrote: > Because if we (PostgreSQL) are going to support this effort, then it > should not ignore such a huge percentage of our installation base. Not doing it day 1 is not ignoring. It's using what resources *are* being made available to the best extent we can. I

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Stephen Frost
* Josh Berkus (j...@agliodbs.com) wrote: > What I'm getting from your e-mail, Dave, is "If it doesn't solve all > problems for everyone in the world from Day 1, it's not worth doing." > It's my experience that the way to get OSS software that works is to > build a little bit at a time, each deliver

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread David Fetter
On Thu, Jan 07, 2010 at 12:07:19PM -0800, David Wheeler wrote: > Hackers, > > I've posted a [plan] to implement PGAN][], a CPAN for PostgreSQL > extensions. I've tried to closely follow the [CPAN philosophy][] to > come up with a plan that requires a minimum-work implementation that > builds on th

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Dimitri Fontaine
Dimitri Fontaine writes: > e.g. pg_execute_commands_from_file('path/ to/file.sql'). It would not [...] > Then you need to add a catalog for holding the extensions metadata, like [...] > Now you can hack a CREATE EXTENSION command to fill-in the catalog, and > the commands INSTALL EXTENSION and DRO

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread David E. Wheeler
On Jan 7, 2010, at 2:23 PM, Dimitri Fontaine wrote: > Maybe with a link to: > http://www.postgresql.org/docs/8.4/static/extend.html Good call, thanks. David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Dimitri Fontaine
"David E. Wheeler" writes: > On Jan 7, 2010, at 2:11 PM, Peter Eisentraut wrote: > >> You might want to clarify in your prose what an "extension" is. I >> suspect I know what you mean, but perhaps not everyone does. > > Good suggestion, thanks. How about this in the FAQ? > > * WTF is an "extensi

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread David E. Wheeler
On Jan 7, 2010, at 2:11 PM, Peter Eisentraut wrote: > You might want to clarify in your prose what an "extension" is. I > suspect I know what you mean, but perhaps not everyone does. Good suggestion, thanks. How about this in the FAQ? * WTF is an "extension"? An extension is a piece of softwar

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Peter Eisentraut
On tor, 2010-01-07 at 12:07 -0800, David E. Wheeler wrote: > I've posted a [plan] to implement PGAN][], a CPAN for PostgreSQL extensions. > I've tried to closely follow the [CPAN philosophy][] to come up with a plan > that requires a minimum-work implementation that builds on the existing > Post

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread David E. Wheeler
On Jan 7, 2010, at 1:59 PM, Joshua D. Drake wrote: > So +1 on Wheeler's idea. Thanks! David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Josh Berkus
> Building them is no problem - authors can easily use EC2 for which we > have an AMI pre-configured for next to no cost, can build on their own > platform, on a community provided system, or get a friend to do it. So any module author, in order to submit any module, would be required to build bin

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Joshua D. Drake
On Thu, 2010-01-07 at 13:22 -0800, Josh Berkus wrote: > Dave, > What I'm getting from your e-mail, Dave, is "If it doesn't solve all > problems for everyone in the world from Day 1, it's not worth doing." I doubt that is Dave's intent because then we might as well stop work on PostgreSQL too. >

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Dimitri Fontaine
Dave Page writes: > We have discussed this sort of facility at previous developer > meetings, and as I recall came to the conclusion that we need to have > the ability to distribute pre-built binaries, not just source code as > virtually no Windows users are ever going to have a build environment

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread David E. Wheeler
On Jan 7, 2010, at 1:31 PM, Dave Page wrote: > No, I'm suggesting the mechanism needs to support source and binary > distribution. For most *nix users, source will be fine. For Windows > binaries are required. I would love to follow what Strawberry Perl has done to solve this problem. In 2.0. B

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Dave Page
On Thu, Jan 7, 2010 at 9:22 PM, Josh Berkus wrote: > Dave, > >> Whilst the aim is a noble one, glossing over 'it won't work on >> Windows' which is by far our most popular platform these days seems >> incredibly short sighted, and liable to lead to an endless stream of >> 'why doesn't this work' q

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread David E. Wheeler
On Jan 7, 2010, at 12:36 PM, Dave Page wrote: > Whilst the aim is a noble one, glossing over 'it won't work on > Windows' which is by far our most popular platform these days seems > incredibly short sighted, and liable to lead to an endless stream of > 'why doesn't this work' questions. It also d

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Josh Berkus
Dave, > Whilst the aim is a noble one, glossing over 'it won't work on > Windows' which is by far our most popular platform these days seems > incredibly short sighted, and liable to lead to an endless stream of > 'why doesn't this work' questions. It also does the module authors no > favours, by

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Bruce Momjian
David E. Wheeler wrote: > Hackers, > > I've posted a [plan] to implement PGAN][], a CPAN for PostgreSQL > extensions. I've tried to closely follow the [CPAN philosophy][] to > come up with a plan that requires a minimum-work implementation that > builds on the existing PostgreSQL tools and the exa

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Magnus Hagander
On Thu, Jan 7, 2010 at 21:42, Joshua D. Drake wrote: > On Thu, 2010-01-07 at 20:36 +, Dave Page wrote: >> On Thu, Jan 7, 2010 at 8:07 PM, David E. Wheeler >> wrote: >> > Hackers, >> > >> > I've posted a [plan] to implement PGAN][], a CPAN for PostgreSQL >> > extensions. I've tried to closel

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Joshua D. Drake
On Thu, 2010-01-07 at 20:36 +, Dave Page wrote: > On Thu, Jan 7, 2010 at 8:07 PM, David E. Wheeler wrote: > > Hackers, > > > > I've posted a [plan] to implement PGAN][], a CPAN for PostgreSQL > > extensions. I've tried to closely follow the [CPAN philosophy][] to come up > > with a plan that

Re: [HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread Dave Page
On Thu, Jan 7, 2010 at 8:07 PM, David E. Wheeler wrote: > Hackers, > > I've posted a [plan] to implement PGAN][], a CPAN for PostgreSQL extensions. > I've tried to closely follow the [CPAN philosophy][] to come up with a plan > that requires a minimum-work implementation that builds on the exist

[HACKERS] RFC: PostgreSQL Add-On Network

2010-01-07 Thread David E. Wheeler
Hackers, I've posted a [plan] to implement PGAN][], a CPAN for PostgreSQL extensions. I've tried to closely follow the [CPAN philosophy][] to come up with a plan that requires a minimum-work implementation that builds on the existing PostgreSQL tools and the examples of the [CPAN][] and [JSAN][