Thread: 20th anniversary of PostgreSQL ?
Determining the birth date of an open source project is a open debate. However in our case, I think we can consider the first official open-source release which is 1995-05-01 http://www.postgresql.org/docs/9.4/interactive/release-0-01.html Btw I find it funny that PostgreSQL 9.5 will be released 20 years after Postgres95 :) This sounds to me like a nice opportunity to organize bithday parties everywhere :) If we want to organize a joint effort to celebrate this, I think we could build a small birthday team to federate local initiatives. For instance : - contact all PUGs and local association and try to get them involved - contact all PG and FLOSS conferences and try to get them involved as well - define a "celebration week" and let each local user group choose the best date inside that week - organize the "celebration week" in september-october, to be closer to the release of PostgreSQL 9.5... Btw May 1st is really near and it's certainly not a good choice in many countries. - define a common logo, a common hasthag and maybe a website -- damien
For the 10th birthday we used the start of the online presence as our birthday, not the Postgres95 release. That's next year.
It would seem odd to change the definition and celebrate a 20th birthday 9 years after the 10th.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK:http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK:http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Determining the birth date of an open source project is a open debate.
However in our case, I think we can consider the first official
open-source release which is 1995-05-01
http://www.postgresql.org/docs/9.4/interactive/release-0-01.html
Btw I find it funny that PostgreSQL 9.5 will be released 20 years after
Postgres95 :)
This sounds to me like a nice opportunity to organize bithday parties
everywhere :) If we want to organize a joint effort to celebrate this, I
think we could build a small birthday team to federate local initiatives.
For instance :
- contact all PUGs and local association and try to get them involved
- contact all PG and FLOSS conferences and try to get them involved as well
- define a "celebration week" and let each local user group choose the
best date inside that week
- organize the "celebration week" in september-october, to be closer to
the release of PostgreSQL 9.5... Btw May 1st is really near and it's
certainly not a good choice in many countries.
- define a common logo, a common hasthag and maybe a website
--
damien
--
Sent via pgsql-advocacy mailing list (pgsql-advocacy@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Le 23/03/2015 10:18, Dave Page a écrit : > For the 10th birthday we used the start of the online presence as our > birthday, not the Postgres95 release. That's next year. > Ok i was not aware of that. What do you mean by "start of online presence" ? The publication of postgresql.org website ? > It would seem odd to change the definition and celebrate a 20th birthday > 9 years after the 10th. > I dont think people would care actually :) This celebration is just an excuse to organize local events and reach out new users. I'm not sure anyone would remember about the 10th birthday or complain about our lack of consistency. Anyway like I said it's an endless debate and I'm interested by that. The purpose of my email was to start a joint effort, not arguing about the birth date
> For the 10th birthday we used the start of the online presence as our > birthday, not the Postgres95 release. That's next year. > > It would seem odd to change the definition and celebrate a 20th birthday 9 > years after the 10th. In Cuba the birth date of PostgreSQL-Cuba is the 14 of december. Saludos, Gilberto Castillo La Habana, Cuba --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
There appears to be a number of opportunities here, and why don't we take advantage of them?
Given we have a couple of dates to mark key events about a year apart - May 1, 1995 (Postgres95-the foundation of what is used today) and July 8, 1996 (Global Community Development Group) - why not facilitate events throughout the year culminating in one party with everyone putting in their support in some way.
Renee Deger
Director, Corporate Communications
Office: 781-357-3090
Cell: 650-714-3911
Skype ID: renee.deger1
On Mon, Mar 23, 2015 at 9:38 AM, Gilberto Castillo <gilberto.castillo@etecsa.cu> wrote:
> For the 10th birthday we used the start of the online presence as our
> birthday, not the Postgres95 release. That's next year.
>
> It would seem odd to change the definition and celebrate a 20th birthday 9
> years after the 10th.
In Cuba the birth date of PostgreSQL-Cuba is the 14 of december.
Saludos,
Gilberto Castillo
La Habana, Cuba
---
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
--
Sent via pgsql-advocacy mailing list (pgsql-advocacy@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
On Mon, Mar 23, 2015 at 9:33 AM, Renee Deger <renee.deger@enterprisedb.com> wrote:
There appears to be a number of opportunities here, and why don't we take advantage of them?Given we have a couple of dates to mark key events about a year apart - May 1, 1995 (Postgres95-the foundation of what is used today) and July 8, 1996 (Global Community Development Group) - why not facilitate events throughout the year culminating in one party with everyone putting in their support in some way.Renee DegerDirector, Corporate CommunicationsOffice: 781-357-3090Cell: 650-714-3911Skype ID: renee.deger1On Mon, Mar 23, 2015 at 9:38 AM, Gilberto Castillo <gilberto.castillo@etecsa.cu> wrote:---
> For the 10th birthday we used the start of the online presence as our
> birthday, not the Postgres95 release. That's next year.
>
> It would seem odd to change the definition and celebrate a 20th birthday 9
> years after the 10th.
In Cuba the birth date of PostgreSQL-Cuba is the 14 of december.
Saludos,
Gilberto Castillo
La Habana, Cuba
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
--
Sent via pgsql-advocacy mailing list (pgsql-advocacy@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
> +1 (or, in this case, +20 ;) ) It is good a logo that everyone can deliver, plus other local initiatives is prepared. Saludos, Gilberto Castillo La Habana, Cuba --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
Dave, all,
* Dave Page (dpage@pgadmin.org) wrote:
> For the 10th birthday we used the start of the online presence as our birthday, not the Postgres95 release. That's
nextyear.
>
> It would seem odd to change the definition and celebrate a 20th birthday 9 years after the 10th.
Agreed. We've already settled on a birthday; let's not try and change
that now.
I'm very excited about next year's celebration, but let's be clear that
it's next year. :)
Thanks!
Stephen
Attachment
On Mon, Mar 30, 2015 at 6:56 PM, Stephen Frost <sfrost@snowman.net> wrote: > Dave, all, > > * Dave Page (dpage@pgadmin.org) wrote: >> For the 10th birthday we used the start of the online presence as our birthday, not the Postgres95 release. That's nextyear. >> >> It would seem odd to change the definition and celebrate a 20th birthday 9 years after the 10th. > > Agreed. We've already settled on a birthday; let's not try and change > that now. > > I'm very excited about next year's celebration, but let's be clear that > it's next year. :) FYI, I just stumbled across this old gem: ==== From: "Marc G. Fournier" Date: Tue, 22 Oct 1996 05:11:44 -0400 (EDT) Subject: [PG95-DEV] PostgreSQL.ORG Hey... Well, I’m now recovering from a heart attack... I sent out the registration request for PostgreSQL.ORG no more then 15 minutes ago...I got confirmation that it is complete 5 minutes ago... ===== So based on that, we could say PostgreSQL was born at 05:06 EDT on 22 October 1996. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On 23 March 2015 at 05:18, Dave Page <dpage@pgadmin.org> wrote: > For the 10th birthday we used the start of the online presence as our > birthday, not the Postgres95 release. That's next year. > > It would seem odd to change the definition and celebrate a 20th birthday 9 > years after the 10th. If we are going to celebrate something, we should be celebrating Stonebraker's Turing award. It seems weird to celebrate a 20th anniversary of Postgres next year, significantly more than 20 years since Stonebraker did the work that won him the award. Postgres was always open source, so celebrating the start of the open source project in 1996 doesn't make sense. We should invite Stonebraker and have a big party, forget the year. Hell, he might even help pay if we asked. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
Hi All,
Can't resist to stay quite,
I am definitelly agree with Simon, PostgreSQL has longer story than '96, used as research as well as commercial, and evolving better up to now.
So we have to appreciate what prof Mike has initiate in the past and what DevGroup has done such great effort to support postgres being fastest enterprise level database up to now....
Let's have great party with him...
Love u all,
julyanto sutandang
On Apr 7, 2015 10:57 PM, "Simon Riggs" <simon@2ndquadrant.com> wrote:
On 23 March 2015 at 05:18, Dave Page <dpage@pgadmin.org> wrote:
> For the 10th birthday we used the start of the online presence as our
> birthday, not the Postgres95 release. That's next year.
>
> It would seem odd to change the definition and celebrate a 20th birthday 9
> years after the 10th.
If we are going to celebrate something, we should be celebrating
Stonebraker's Turing award. It seems weird to celebrate a 20th
anniversary of Postgres next year, significantly more than 20 years
since Stonebraker did the work that won him the award.
Postgres was always open source, so celebrating the start of the open
source project in 1996 doesn't make sense.
We should invite Stonebraker and have a big party, forget the year.
Hell, he might even help pay if we asked.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
--
Sent via pgsql-advocacy mailing list (pgsql-advocacy@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
On 04/07/2015 08:57 AM, Simon Riggs wrote: > We should invite Stonebraker and have a big party, forget the year. > Hell, he might even help pay if we asked. I doubt it; currently he's doing the NoSQL thing, last I checked. He hasn't really cared about Postgres in well over a decade. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com
On 04/08/15 03:35, Josh Berkus wrote: > On 04/07/2015 08:57 AM, Simon Riggs wrote: >> We should invite Stonebraker and have a big party, forget the year. >> Hell, he might even help pay if we asked. > > I doubt it; currently he's doing the NoSQL thing, last I checked. He > hasn't really cared about Postgres in well over a decade. What "NoSQL thing"? The last time I checked he was a vocal critic of the NoSQL movement, and involved in projects on relational databases like Vertica or VoltDB. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Yet another metric used to define an initial release is the date of the 1.0 version. From the first archive capture [1] this is "Postgres95 1.0 ... Tue Sep 5 11:24:11 PDT 1995" I'm also digging the first logo [2]. It seems to be influenced by Kool-Aid Man with a lens flare = awesome. [1] http://web.archive.org/web/19970208171725/http://postgresql.org/history.phtml [2] http://web.archive.org/web/19970613233238/http://www.postgresql.org/img/postgreSQL.jpg
> > I'm also digging the first logo [2]. It seems to be influenced by > Kool-Aid Man with a lens flare = awesome. > > [2] http://web.archive.org/web/19970613233238/http://www.postgresql.org/img/postgreSQL.jpg > :)
On 04/08/2015 04:10 AM, Tomas Vondra wrote: > What "NoSQL thing"? Well, it all depends on what you mean by NoSQL. This very much seems like a marketing (rather than technical) term we should embrace (rather than battle). voltdb.com [0] puts it that way: "VoltDB offers [..] the scalability of NoSQL, [..] and the transactional consistency of traditional relational databases." > The last time I checked he was a vocal critic of the > NoSQL movement, and involved in projects on relational databases like > Vertica or VoltDB. Their marketing has been clever enough not to fight NoSQL, but adjusts the term slightly (keeping it equally meaningless from a technical perspective) and now states: "Designed by Dr. Michael Stonebraker, VoltDB is a modern NewSQL in-memory database [..]." Let's embrace, extend and extinguish NoSQL! But back to the topic at hand: It might be worth to ask Michael if he wants to celebrate with us. But let's focus on celebrating Postgres, please. Regarding the date: Remember that we had a 10th Anniversary Summit in July 2006. Celebrating the 20th far off from July 2016 triggers a serialization error in my mind. ;-) Regards Markus Wanner 0: http://voltdb.com/fast-smart-scale
On Wed, Apr 8, 2015 at 4:18 AM, Mike Toews <mwtoews@gmail.com> wrote:
-- Yet another metric used to define an initial release is the date of
the 1.0 version.
From the first archive capture [1] this is "Postgres95 1.0 ... Tue Sep
5 11:24:11 PDT 1995"
That is the Postgres95 version 1.0. There was also sometime in ancient history a Postgres 1.0 I believe (though I don't think it ever made it outside Berkeley?)
So it depends on if we're doing the birthday for Postgres, Postgres95 or PostgreSQL.
I thought that were no Postgres 1.0 since Postgres is continuing Ingres, then Postgres95.
Postgres started from version 6.0 to give credit of the past development
"""
PostgreSQL, originally called Postgres, was created at UCB by a computer science professor named Michael Stonebraker, who went on to become the CTO of Informix Corporation. Stonebraker started Postgres in 1986 as a followup project to its predecessor, Ingres, now owned by Computer Associates. The name Postgres thus plays off of its predecessor (as in "after Ingres"). Ingres, developed from 1977 to 1985, had been an exercise in creating a database system according to classic RDBMS theory. Postgres, developed between 1986-1994, was a project meant to break new ground in database concepts such as exploration of "object relational" technologies.
Stonebraker and his graduate students actively developed Postgres for eight years. During that time, Postgres introduced rules, procedures, time travel, extensible types with indices and object-relational concepts. Postgres was later commercialized to become Illustra which was later bought by Informix and integrated into its Universal Server. Informix was purchased by IBM in 2001 for one billion dollars.
In 1995, two Ph.D. students from Stonebraker's lab, Andrew Yu and Jolly Chen, replaced Postgres' POSTQUEL query language with an extended subset of SQL. They renamed the system to Postgres95.
In 1996, Postgres95 departed from academia and started a new life in the open source world when a group of dedicated developers outside of Berkeley saw the promise of the system, and devoted themselves to its continued development. Contributing enormous amounts of time, skill, labor, and technical expertise, this global development group radically transformed Postgres. Over the next eight years, they brought consistency and uniformity to the code base, created detailed regression tests for quality assurance, set up mailing lists for bug reports, fixed innumerable bugs, added incredible new features, and rounded out the system by filling various gaps such as documentation for developers and users.
The fruition of their labor was a new database that garnered a reputation for rock solid stability. With the start of its new life in the open source world, with many new features and enhancements, the database system took its current name: PostgreSQL. ("Postgres" is still used as an easy-to-pronounce nick-name.)
PostgreSQL began at version 6.0, giving credit to its many years of prior development
"""
On Wed, Apr 8, 2015 at 2:30 PM, Magnus Hagander <magnus@hagander.net> wrote:
On Wed, Apr 8, 2015 at 4:18 AM, Mike Toews <mwtoews@gmail.com> wrote:--Yet another metric used to define an initial release is the date of
the 1.0 version.
From the first archive capture [1] this is "Postgres95 1.0 ... Tue Sep
5 11:24:11 PDT 1995"That is the Postgres95 version 1.0. There was also sometime in ancient history a Postgres 1.0 I believe (though I don't think it ever made it outside Berkeley?)So it depends on if we're doing the birthday for Postgres, Postgres95 or PostgreSQL.
Julyanto SUTANDANG
Equnix Business Solutions, PT
(An Open Source an Open Mind Company)
Pusat Niaga ITC Roxy Mas Blok C2/42. Jl. KH Hasyim Ashari 125, Jakarta Pusat
T: +6221 7997 692 F: +62216315281 M: +628164858028
Caution: The information enclosed in this email (and any attachments) may be legally privileged and/or confidential and is intended only for the use of the addressee(s). No addressee should forward, print, copy, or otherwise reproduce this message in any manner that would allow it to be viewed by any individual not originally listed as a recipient. If the reader of this message is not the intended recipient, you are hereby notified that any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is strictly prohibited. If you have received this communication in error, please immediately notify the sender and delete this message.Unless it is made by the authorized person, any views expressed in this message are those of the individual sender and may not necessarily reflect the views of PT Equnix Business Solutions.
On Wed, Apr 8, 2015 at 9:38 AM, julyanto SUTANDANG <julyanto@equnix.co.id> wrote:
I thought that were no Postgres 1.0 since Postgres is continuing Ingres, then Postgres95.Postgres started from version 6.0 to give credit of the past development
PostgreSQL started from version 6.0.
Postgres95 started from version 1.0 (though we can pretend it was 5.0)
POSTGRES had at least versions 4.x. 4.2 was the last release.
I don't actually know about POSTGRES prior to 4.x, that was well before my time.
> > That is the Postgres95 version 1.0. There was also sometime in ancient > history a Postgres 1.0 I believe (though I don't think it ever made it > outside Berkeley?) > > So it depends on if we're doing the birthday for Postgres, Postgres95 or > PostgreSQL. We did celebrate 10 years in 2006, right? What criteria were used then to decide? AFAIK it was the first release as a FOSS project outside academia, and that was in 1996 as per http://www.postgresql.org/about/history/ . The tag line was something like 10 years of Open Source or something similar. So we should stick to that and celebrate 20 years in 2016, for consistency. ... Or just celebrate "NaN years" this year ;) Bye, Chris
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Am 08.04.2015 um 04:10 schrieb Tomas Vondra: > On 04/08/15 03:35, Josh Berkus wrote: >> On 04/07/2015 08:57 AM, Simon Riggs wrote: >>> We should invite Stonebraker and have a big party, forget the >>> year. Hell, he might even help pay if we asked. >> >> I doubt it; currently he's doing the NoSQL thing, last I >> checked. He hasn't really cared about Postgres in well over a >> decade. > > What "NoSQL thing"? The last time I checked he was a vocal critic > of the NoSQL movement, and involved in projects on relational > databases like Vertica or VoltDB. Independently of this discussion, did anybody representing .org send some congratulations to "daddy"?!? Just my 2p, - -- Gunnar "Nick" Bluth RHCE/SCLA Mobil +49 172 8853339 Email: gunnar.bluth@pro-open.de ________________________________________________________________________ __ In 1984 mainstream users were choosing VMS over UNIX. Ten years later they are choosing Windows over UNIX. What part of that message aren't yo u getting? - Tom Payne -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (MingW32) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJVJN1LAAoJEBAQrmsyiTOM/OMH/3zVMJgNgAehwUxWu9ymbjPk pdnmjQchpSlWD/CjV+DxPlsgLr3lHFkOunUyfhz2kerBmmbGPnr4H+rhi2nXYV22 eXpMHi9Mm3WUaxH/s2WXN/n/n7Gp3Eq9E+wdfMH73EhkvlBmqK8MTWMCPOCz5El0 Hv9V2eKfdUhqgQUBY0ggPv0pL+e+Yob5RdKCZfkbGFQU50GSJqfjFFjvkpjYiJF5 ANRlwWUSOqilOZwMZfasxGkVubeY5+GEZAM04iB2EYiOs8szo0ChEbnHGD47bQdA +7C7TjCfKCNtiKvG+Ati+WmcFroj1a2Th7LHbSVVOOHXPjEoqbFRtN6ZPBRFUyM= =bvZt -----END PGP SIGNATURE-----
Attachment
Ah Ok, thanks for the correction Magnus,
but still, based on the History, version 1.0 is belongs to Ingres, perhaps?
Thanks,
On Wed, Apr 8, 2015 at 2:45 PM, Magnus Hagander <magnus@hagander.net> wrote:
On Wed, Apr 8, 2015 at 9:38 AM, julyanto SUTANDANG <julyanto@equnix.co.id> wrote:I thought that were no Postgres 1.0 since Postgres is continuing Ingres, then Postgres95.Postgres started from version 6.0 to give credit of the past developmentPostgreSQL started from version 6.0.Postgres95 started from version 1.0 (though we can pretend it was 5.0)POSTGRES had at least versions 4.x. 4.2 was the last release.I don't actually know about POSTGRES prior to 4.x, that was well before my time.--
Julyanto SUTANDANG
Equnix Business Solutions, PT
(An Open Source an Open Mind Company)
Pusat Niaga ITC Roxy Mas Blok C2/42. Jl. KH Hasyim Ashari 125, Jakarta Pusat
T: +6221 7997 692 F: +62216315281 M: +628164858028
Caution: The information enclosed in this email (and any attachments) may be legally privileged and/or confidential and is intended only for the use of the addressee(s). No addressee should forward, print, copy, or otherwise reproduce this message in any manner that would allow it to be viewed by any individual not originally listed as a recipient. If the reader of this message is not the intended recipient, you are hereby notified that any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is strictly prohibited. If you have received this communication in error, please immediately notify the sender and delete this message.Unless it is made by the authorized person, any views expressed in this message are those of the individual sender and may not necessarily reflect the views of PT Equnix Business Solutions.
On Wed, Apr 8, 2015 at 9:13 AM, julyanto SUTANDANG <julyanto@equnix.co.id> wrote: > Ah Ok, thanks for the correction Magnus, > but still, based on the History, version 1.0 is belongs to Ingres, perhaps? They are completely independent projects. The only link between them is that they both came out of the same group at Berkeley. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
I remember one reason behind the dates of the first PGDay in Prato (July 7th,8th 2007) was "one" birthday of PostgreSQL (the CVS at least): http://www.postgresql.org/about/news/978/ Besides, 2016 is the 20th year. Luca
On 23 March 2015 at 22:18, Dave Page <dpage@pgadmin.org> wrote: > For the 10th birthday we used the start of the online presence as our > birthday, not the Postgres95 release. That's next year. > > It would seem odd to change the definition and celebrate a 20th birthday 9 > years after the 10th. This is the most compelling evidence, along with the domain registration, that the birthday was 05:06 EDT on 22 October 1996, as per the domain registration of the online presence as PostgreSQL.ORG Thanks Dave for digging this up! That means there is a year and a half yet for revised Kool-Aid Man / lens flare inspired logo re-designs in preparation for the 20th...
On 04/08/2015 06:19 AM, Mike Toews wrote: > On 23 March 2015 at 22:18, Dave Page <dpage@pgadmin.org> wrote: >> For the 10th birthday we used the start of the online presence as our >> birthday, not the Postgres95 release. That's next year. >> >> It would seem odd to change the definition and celebrate a 20th birthday 9 >> years after the 10th. > > This is the most compelling evidence, along with the domain > registration, that the birthday was 05:06 EDT on 22 October 1996, as > per the domain registration of the online presence as PostgreSQL.ORG The reason we've been celebrating July 8, 1996 as the birthday of the PostgreSQL Project is that's when Marc stood up the CVS server and the source of PostgreSQL went online, with an OSS license. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com
On Wed, Apr 8, 2015 at 09:45:05AM +0200, Magnus Hagander wrote: > On Wed, Apr 8, 2015 at 9:38 AM, julyanto SUTANDANG <julyanto@equnix.co.id> > wrote: > > I thought that were no Postgres 1.0 since Postgres is continuing Ingres, > then Postgres95. > Postgres started from version 6.0 to give credit of the past development > > > PostgreSQL started from version 6.0. > Postgres95 started from version 1.0 (though we can pretend it was 5.0) > POSTGRES had at least versions 4.x. 4.2 was the last release. Actually, I think Postgres95 had "5.X" in its $PGDATA/PG_VERSION, which forced us to start PostgreSQL at 6.0, in case any applications were looking there for version information. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
On Wed, Apr 8, 2015 at 9:28 PM, Bruce Momjian <bruce@momjian.us> wrote:
-- On Wed, Apr 8, 2015 at 09:45:05AM +0200, Magnus Hagander wrote:
> On Wed, Apr 8, 2015 at 9:38 AM, julyanto SUTANDANG <julyanto@equnix.co.id>
> wrote:
>
> I thought that were no Postgres 1.0 since Postgres is continuing Ingres,
> then Postgres95.
> Postgres started from version 6.0 to give credit of the past development
>
>
> PostgreSQL started from version 6.0.
> Postgres95 started from version 1.0 (though we can pretend it was 5.0)
> POSTGRES had at least versions 4.x. 4.2 was the last release.
Actually, I think Postgres95 had "5.X" in its $PGDATA/PG_VERSION, which
forced us to start PostgreSQL at 6.0, in case any applications were
looking there for version information.
Oh really? That's even more confusing than I thought, and I thought it was pretty bad :)
On Wed, Apr 8, 2015 at 09:31:15PM +0200, Magnus Hagander wrote:
> On Wed, Apr 8, 2015 at 9:28 PM, Bruce Momjian <bruce@momjian.us> wrote:
>
> On Wed, Apr 8, 2015 at 09:45:05AM +0200, Magnus Hagander wrote:
> > On Wed, Apr 8, 2015 at 9:38 AM, julyanto SUTANDANG <julyanto@equnix.co.id
> >
> > wrote:
> >
> > I thought that were no Postgres 1.0 since Postgres is continuing
> Ingres,
> > then Postgres95.
> > Postgres started from version 6.0 to give credit of the past
> development
> >
> >
> > PostgreSQL started from version 6.0.
> > Postgres95 started from version 1.0 (though we can pretend it was 5.0)
> > POSTGRES had at least versions 4.x. 4.2 was the last release.
>
> Actually, I think Postgres95 had "5.X" in its $PGDATA/PG_VERSION, which
> forced us to start PostgreSQL at 6.0, in case any applications were
> looking there for version information.
>
>
> Oh really? That's even more confusing than I thought, and I thought it was
> pretty bad :)
Yes. When they numbered Postgres95 as 1.0, they changed PG_VERSION from
4.X to 5.X, not to 1.X, as you would have assumed. Here is proof from
Postgres95 1.01's miscadmin.h:
/*****************************************************************************
* magic.h - definitions of the indexes of the magic numbers *
*****************************************************************************/
#define PG_RELEASE 5
#define PG_VERSION 1
#define PG_VERFILE "PG_VERSION"
and this function to create the PG_VERSION file:
/*
* SetPgVersion - writes the version to a database directory
*/
void
SetPgVersion(char *path)
{
int fd;
char version[4], buf[MAXPGPATH+1];
PathSetVersionFilePath(path, buf);
if ((fd = open(buf, O_WRONLY|O_CREAT|O_EXCL, 0666)) < 0)
elog(FATAL, "SetPgVersion: %s: %m", buf);
version[0] = '0' + PG_RELEASE;
version[1] = '.';
version[2] = '0' + PG_VERSION;
version[3] = '\n';
if (write(fd, version, 4) != 4)
elog(WARN, "SetPgVersion: %s: %m", buf);
close(fd);
}
so the Postgres95 1.01 PG_VERSION file contained 5.1.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
Hey guys, I'm ressurecting this old thread with hope that the timing is right now. So if we consider that the date of "birth" of PostgreSQL is 22/10/1996, that leaves us a few month to organize something. I really think it'd be nice to use this event to promote PostgreSQL and try to reach a larger audience. Here's a quick tour of how other community have celebrated their anniversary : The Linux Foundation made video and a nice infographic: http://content.linuxfoundation.org/20th/ Wikipedia just made a nice website https://15.wikipedia.org/ Mozilla bought a bus: http://mozbus-en.tumblr.com/post/102248099620/firefox-10th-anniversary-in-tokyo (If you have other examples, please post it here) While buying a bus may not be a great idea, I think we can get some inspirations from what other communities did. In particular, I think we could : - define a celebration week or a celebrating month, and let local user group and comapnies organize their own event - define a common logo and a common twitter hastag (#Postgres20 ? ) - Create a poster And If we want to go beyond that, I think creating a dedicated website would be nice. Actually I really like what wikipedia has done, which is basically creating user interaction by asking "What does Wikipedia means to you ?". I think we go follow the same path and ask our user base "Why do love PostgreSQL", with the possibility give their name and the company they work for... That'd be a nice way to collect a great amout of quotes, which is something we miss a lot a think. Of course there's many things we can do. These are just ideas I'm throwing here... -- Damien Clochard
On Sat, Jan 16, 2016 at 12:12:34PM +0100, Damien Clochard wrote: > Hey guys, > > I'm ressurecting this old thread with hope that the timing is right now. > > So if we consider that the date of "birth" of PostgreSQL is > 22/10/1996, that leaves us a few month to organize something. I am curious why you chose that date? I always thought it was the creation of the CVS tree on July 9, 1996. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Roman grave inscription +
> > I am curious why you chose that date? I always thought it was the > creation of the CVS tree on July 9, 1996. > Clearly I'm not familiar that part of PostgreSQL history but last year, Dave told me that the birthdate was the start of the online presence, which seems to be 22/10/1996 when Marc Fournier bought the postgresql.org domain. I don't really care though. We can define the birthdate as July 9,1996. We can even avoid completely defining a specific date and simply state that "PostgreSQL was born in 1996". I don't think people really care what the date stands for anyway... To me the most important thing is to have a series of coordinated events and actions on a scheduled period. It can be in may, july or october... The only problem I see with July is that it's more difficult to organize events in the summer (at least in Europe) Regards, -- Damien Clochard
On Sun, Jan 17, 2016 at 12:27:06PM +0100, Damien Clochard wrote: > > > > >I am curious why you chose that date? I always thought it was the > >creation of the CVS tree on July 9, 1996. > > > > Clearly I'm not familiar that part of PostgreSQL history but last > year, Dave told me that the birthdate was the start of the online > presence, which seems to be 22/10/1996 when Marc Fournier bought the > postgresql.org domain. Oh, the website. OK, makes sense. > I don't really care though. We can define the birthdate as July > 9,1996. We can even avoid completely defining a specific date and > simply state that "PostgreSQL was born in 1996". I don't think > people really care what the date stands for anyway... > > To me the most important thing is to have a series of coordinated > events and actions on a scheduled period. It can be in may, july or > october... The only problem I see with July is that it's more > difficult to organize events in the summer (at least in Europe) Agreed. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Roman grave inscription +
On 01/17/2016 07:28 AM, Bruce Momjian wrote: > On Sun, Jan 17, 2016 at 12:27:06PM +0100, Damien Clochard wrote: >>> I am curious why you chose that date? I always thought it was the >>> creation of the CVS tree on July 9, 1996. >>> >> >> Clearly I'm not familiar that part of PostgreSQL history but last >> year, Dave told me that the birthdate was the start of the online >> presence, which seems to be 22/10/1996 when Marc Fournier bought the >> postgresql.org domain. > > Oh, the website. OK, makes sense. > >> I don't really care though. We can define the birthdate as July >> 9,1996. We can even avoid completely defining a specific date and Considering we held the 10 year anniversary in July, seems like we ought to stick with that. Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development
Attachment
> On Sun, Jan 17, 2016 at 12:27:06PM +0100, Damien Clochard wrote: >> >> > >> >I am curious why you chose that date? I always thought it was the >> >creation of the CVS tree on July 9, 1996. >> > >> >> Clearly I'm not familiar that part of PostgreSQL history but last >> year, Dave told me that the birthdate was the start of the online >> presence, which seems to be 22/10/1996 when Marc Fournier bought the >> postgresql.org domain. > > Oh, the website. OK, makes sense. > >> I don't really care though. We can define the birthdate as July >> 9,1996. We can even avoid completely defining a specific date and >> simply state that "PostgreSQL was born in 1996". I don't think >> people really care what the date stands for anyway... >> >> To me the most important thing is to have a series of coordinated >> events and actions on a scheduled period. It can be in may, july or >> october... The only problem I see with July is that it's more >> difficult to organize events in the summer (at least in Europe) > > Agreed. Preferable of july at decembre, by that 14 of december is the aniversary of PostgreSQL-Cuba Saludos, Gilberto Castillo ETECSA, La Habana, Cuba
Damien Clochard wrote: > > > > >I am curious why you chose that date? I always thought it was the > >creation of the CVS tree on July 9, 1996. > > Clearly I'm not familiar that part of PostgreSQL history but last year, Dave > told me that the birthdate was the start of the online presence, which seems > to be 22/10/1996 when Marc Fournier bought the postgresql.org domain. > > I don't really care though. We can define the birthdate as July 9,1996. FYI the renaming in CVS took place in December 1996 http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1b929d174916a0e226c72927932bdbdd1230dcb0 but that's just a matter of changing the name. It seems clear from the code history that the community efforts began in July with the initial commit from Marc, commit d31084e9d1118b25fd16580d9d8c2924b5740dff Author: Marc G. Fournier <scrappy@hub.org> AuthorDate: Tue Jul 9 06:22:35 1996 +0000 CommitDate: Tue Jul 9 06:22:35 1996 +0000 Postgres95 1.01 Distribution - Virgin Sources -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services