Обсуждение: Ready to launch?
So, with the possible exception of the survey being missing from the front page, are we ready to launch now? As for the survey, the only responses I've seen from anyone are along the lines of 'yes, it does need to be on the front page'. I personally think that the 'Featured User' box should be used for this - I can't see us getting a new quote from a user every few weeks after all... Regards, Dave.
On Mon, 2004-12-20 at 09:06, Dave Page wrote:
> So, with the possible exception of the survey being missing from the
> front page, are we ready to launch now?
>
> As for the survey, the only responses I've seen from anyone are along
> the lines of 'yes, it does need to be on the front page'. I personally
> think that the 'Featured User' box should be used for this - I can't see
> us getting a new quote from a user every few weeks after all...
>
I like that idea, maybe oscillate between surveys / quotes for 3 weeks /
1 week of every month?
As for rolling up, I think we still have a few things that should be
addressed:
1) "about the new website" link in the announcement doesn't go anywhere,
did someone have content for that?
2) Under About->Press we have a link to the 8.0 press kit and in the FAQ
it stats 8.0 is the most recent version. Perhaps those links should be
hidden for now?
3) Downloads->BitTorrent-> only has links to the 8.0beta4, can we get a
copy of 7.4.6 and 8.0rc1 ?
4) More of a IMO thing, but I think the links in
Documentation->Manuals->[current|archive] should be changed so that with
user comments is listed first.
5) Documentation->FAQ seems fairly busted. Since we have all of the
language FAQ's working on the current site, I think this needs to be
straightened out before we go live.
6) Books should probably be listed in order of Publish date, an added
bonus would be to link to the book information on techdocs (reviews,
recommendations) but not a deal breaker.
7) I think we should add gborg, pgfoundry, and techdocs to
Community->Resources. possibly devrim's blog roll too, though I dont
know if that is live yet.
8) Support->professional services is blank, we either need to import the
info from techdocs are create a link to it.
9) Support-> hosting is also blank, same story as #8
10) Support-> bug reporting probably should have a link to the
pgsql-bugs archives.
11) Should the license link in the footer point to the license of the
website?
12) Anyone else have an issue with the footer links sometimes
overlapping the sponser add? I get this alot in the community section of
the website.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
> -----Original Message-----
> From: Robert Treat [mailto:xzilla@users.sourceforge.net]
> Sent: 20 December 2004 16:07
> To: Dave Page
> Cc: pgsql-www@postgresql.org
> Subject: Re: [pgsql-www] Ready to launch?
>
> I like that idea, maybe oscillate between surveys / quotes
> for 3 weeks /
> 1 week of every month?
Sounds good to me.
> As for rolling up, I think we still have a few things that should be
> addressed:
>
>
> 5) Documentation->FAQ seems fairly busted. Since we have all of the
> language FAQ's working on the current site, I think this needs to be
> straightened out before we go live.
They should be there - the links just need fixing. The problem is that
these are extracted automatically from CVS, so integrating them into the
site properly as the note on that page suggests is not particularly
easy.
> 11) Should the license link in the footer point to the license of the
> website?
Using Omar's reasoning for removing my Privacy Policy link from the
About section (ie. It's to do with the site, not the product), I would
say that the Licence link from the bottom of each page should go
altogether.
That said, the site code is also under the BSD licence (albeit the
standard one, not the PG version) - but does anyone really care about
that? {erhaps it's best left on Gborg.
Which reminds me of a problem - *all* the website in CVS is published
under the BSD licence, however that includes the elephant which Emily
pointed out was a $100 stock photo. Technically that means we cannot use
the elephant...
> 12) Anyone else have an issue with the footer links sometimes
> overlapping the sponser add? I get this alot in the community
> section of
> the website.
My brother pointed that out the other day. He's a web developer by trade
so has a bunch of browsers to hand, and determined that of those he had,
only Firefox 0.9 seemed to be affected. 1.0 seems to be fine (that's
what I run).
Does that tie in with your system?
WRT the other items, are they on the todo? Can you add them and mark the
showstoppers if not please?
Regards, Dave.
"Dave Page" <dpage@vale-housing.co.uk> writes:
> Which reminds me of a problem - *all* the website in CVS is published
> under the BSD licence, however that includes the elephant which Emily
> pointed out was a $100 stock photo. Technically that means we cannot use
> the elephant...
How so? The BSD license is not antithetical to living beside non-free
stuff (unlike GPL). I agree it would be a good idea to point out
somewhere in the relevant docs that the elephant image isn't BSD'd,
just so no one mistakenly thinks it is.
regards, tom lane
> -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: 20 December 2004 16:53 > To: Dave Page > Cc: Robert Treat; pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Ready to launch? > > "Dave Page" <dpage@vale-housing.co.uk> writes: > > Which reminds me of a problem - *all* the website in CVS is > published > > under the BSD licence, however that includes the elephant > which Emily > > pointed out was a $100 stock photo. Technically that means > we cannot use > > the elephant... > > How so? The BSD license is not antithetical to living beside non-free > stuff (unlike GPL). >I agree it would be a good idea to point out > somewhere in the relevant docs that the elephant image isn't BSD'd, > just so no one mistakenly thinks it is. Oh no, that's not what I meant. The entire site is in CVS (in fact, periodically rebuilds itself from CVS), and that CVS is advertised by the Gborg site as being covered by a BSD licence. It's not easy to edit that as the licence is one of a number of standard ones used site wide. If we keep the elephant in CVS, then I think we would need to include a note saying that it is not included in the licence on every place we have/display that licence. Not only is that a pita, but is also made more difficult for the reason mentioned already. Are there no good royalty free alternatives around? Regards, Dave.
On Mon, 20 Dec 2004, Dave Page wrote: > > >> -----Original Message----- >> From: Tom Lane [mailto:tgl@sss.pgh.pa.us] >> Sent: 20 December 2004 16:53 >> To: Dave Page >> Cc: Robert Treat; pgsql-www@postgresql.org >> Subject: Re: [pgsql-www] Ready to launch? >> >> "Dave Page" <dpage@vale-housing.co.uk> writes: >>> Which reminds me of a problem - *all* the website in CVS is >> published >>> under the BSD licence, however that includes the elephant >> which Emily >>> pointed out was a $100 stock photo. Technically that means >> we cannot use >>> the elephant... >> >> How so? The BSD license is not antithetical to living beside non-free >> stuff (unlike GPL). >> I agree it would be a good idea to point out >> somewhere in the relevant docs that the elephant image isn't BSD'd, >> just so no one mistakenly thinks it is. > > Oh no, that's not what I meant. The entire site is in CVS (in fact, > periodically rebuilds itself from CVS), and that CVS is advertised by > the Gborg site as being covered by a BSD licence. It's not easy to edit > that as the licence is one of a number of standard ones used site wide. > If we keep the elephant in CVS, then I think we would need to include a > note saying that it is not included in the licence on every place we > have/display that licence. Not only is that a pita, but is also made > more difficult for the reason mentioned already. > > Are there no good royalty free alternatives around? Could we not put it outside of CVS and just link'd in via the IMG SRC tag? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
On Mon, 20 Dec 2004, Robert Treat wrote: > 12) Anyone else have an issue with the footer links sometimes > overlapping the sponser add? I get this alot in the community section of > the website. I'm seeing this with Mozilla 1.7.3 on Linux. It seems to happen on any short page where the text doesn't clear the sidebar (e.g. Case Studies, Privacy Policy). -- Steve Simms <steve@deefs.net> http://www.deefs.net
Hi, > Oh no, that's not what I meant. The entire site is in CVS (in fact, You mean the sentence at the top of the project page? "This project is released under the Berkeley/BSD license"? Just adding something in the project description that says what the actual license is would work. On the other hand, the source itself does not have a license included (as Gavin pointed out), and does not appear to have an actual binding license. Adding the bit about the elephant into the eventual COPYING/LICENSE file is all that's needed in that regard. > Are there no good royalty free alternatives around? Uh, it *is* a royalty free image. Rights managed images cost several thousand dollars plus. Royalty free just means you don't pay royalties. If you mean free (libre and gratis), then it'd be virtually impossible to find an totally free image of that quality. Unless someone happens to be a budding photographer, and has some great pictures of elephants in the African savannah, that is. In which case, I'm all for it. Or, the dancing bear. Perhaps we can dress it up as an elephant? Omar
Hi,
>>Which reminds me of a problem - *all* the website in CVS is published
>>under the BSD licence, however that includes the elephant which Emily
>>pointed out was a $100 stock photo. Technically that means we cannot use
>>the elephant...
>
> How so? The BSD license is not antithetical to living beside non-free
> stuff (unlike GPL). I agree it would be a good idea to point out
> somewhere in the relevant docs that the elephant image isn't BSD'd,
> just so no one mistakenly thinks it is.
I'd like to point out that code does not equate to *design*, and that
the previous conversation was about *site code*, i.e., pgweb, and not
the design (and even then, nothing was decided upon.)
Not that there's anything in the BSD license that says you can't use an
image on a website, but alas.
This is a proposed license. The PostgreSQL Global Development Group must
accept the following terms for the BSD license and copyright addition to
take affect (the CSS has already been BSD licensed, separately.)
---
The images (except the elephant in the announcement box on the front
page), the unique combination of images, colors, sizes, typography, and
positioning ("the design") are:
Copyright (c) 2004 Emily Boyd
Copyright (c) 2004 Omar Kilani
("the original copyright holders") and is additionally:
Copyright (c) 2004 PostgreSQL Global Development Group
And is released under the BSD license.
---
The elephant in the announcement box on the front page is a licensed
derivative work of a royalty free image, and Emily Boyd grants the
PostgreSQL Global Development Group the right to use said image on the
postgresql.org website.
---
Use by PostgreSQL International sites is possible, but a right to use
must be granted by Emily Boyd for each licensee, as per the terms of the
original license on the image.
---
> regards, tom lane
Best Regards,
Omar Kilani
Emily Boyd
On Monday 20 December 2004 11:50, Dave Page wrote:
> > -----Original Message-----
> > From: Robert Treat [mailto:xzilla@users.sourceforge.net]
> > 12) Anyone else have an issue with the footer links sometimes
> > overlapping the sponser add? I get this alot in the community
> > section of
> > the website.
>
> My brother pointed that out the other day. He's a web developer by trade
> so has a bunch of browsers to hand, and determined that of those he had,
> only Firefox 0.9 seemed to be affected. 1.0 seems to be fine (that's
> what I run).
>
> Does that tie in with your system?
>
Well, mine is the mozilla based Galeon 1.2.6. As Steve said, this seems to
happen on any short page where the text doesn't clear the sidebar.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
The License on GBorg for that project could be easily changed to whatever makes the most sense. Chris Ryan --- Dave Page <dpage@vale-housing.co.uk> wrote: > > > > -----Original Message----- > > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > > Sent: 20 December 2004 16:53 > > To: Dave Page > > Cc: Robert Treat; pgsql-www@postgresql.org > > Subject: Re: [pgsql-www] Ready to launch? > > > > "Dave Page" <dpage@vale-housing.co.uk> writes: > > > Which reminds me of a problem - *all* the website in CVS is > > published > > > under the BSD licence, however that includes the elephant > > which Emily > > > pointed out was a $100 stock photo. Technically that means > > we cannot use > > > the elephant... > > > > How so? The BSD license is not antithetical to living beside > non-free > > stuff (unlike GPL). > >I agree it would be a good idea to point out > > somewhere in the relevant docs that the elephant image isn't BSD'd, > > just so no one mistakenly thinks it is. > > Oh no, that's not what I meant. The entire site is in CVS (in fact, > periodically rebuilds itself from CVS), and that CVS is advertised by > the Gborg site as being covered by a BSD licence. It's not easy to > edit > that as the licence is one of a number of standard ones used site > wide. > If we keep the elephant in CVS, then I think we would need to include > a > note saying that it is not included in the licence on every place we > have/display that licence. Not only is that a pita, but is also made > more difficult for the reason mentioned already. > > Are there no good royalty free alternatives around? > > Regards, Dave. > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend > __________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail
> -----Original Message----- > From: Chris Ryan [mailto:xgbe@yahoo.com] > Sent: 20 December 2004 19:13 > To: Dave Page; Tom Lane > Cc: Robert Treat; pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Ready to launch? > > The License on GBorg for that project could be easily changed to > whatever makes the most sense. Presumably that means creating a new site-wide licence option though? Regards, Dave.
> -----Original Message----- > From: Marc G. Fournier [mailto:scrappy@postgresql.org] > Sent: 20 December 2004 17:47 > To: Dave Page > Cc: Tom Lane; Robert Treat; pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Ready to launch? > > Could we not put it outside of CVS and just link'd in via the > IMG SRC tag? Yeah, but it would be a real pita to have one image from the site stored in a different way from the entire rest of the site. Regards, Dave.
From reading the other messages I think this has been resolved, however... I can create a license record that is not availabe to other projects and then manually assign that license to a project. Chris Ryan --- Dave Page <dpage@vale-housing.co.uk> wrote: > > > > -----Original Message----- > > From: Chris Ryan [mailto:xgbe@yahoo.com] > > Sent: 20 December 2004 19:13 > > To: Dave Page; Tom Lane > > Cc: Robert Treat; pgsql-www@postgresql.org > > Subject: Re: [pgsql-www] Ready to launch? > > > > The License on GBorg for that project could be easily changed > to > > whatever makes the most sense. > > Presumably that means creating a new site-wide licence option though? > > Regards, Dave. > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
> -----Original Message----- > From: Chris Ryan [mailto:xgbe@yahoo.com] > Sent: 20 December 2004 21:33 > To: Dave Page; Tom Lane > Cc: Robert Treat; pgsql-www@postgresql.org > Subject: RE: [pgsql-www] Ready to launch? > > From reading the other messages I think this has been resolved, > however... I can create a license record that is not availabe to other > projects and then manually assign that license to a project. Oh, that's OK then. Another problem solved :-) Thanks Chris. Regards Dave
Omar Kilani <omar@tinysofa.org> writes:
> The elephant in the announcement box on the front page is a licensed
> derivative work of a royalty free image, and Emily Boyd grants the
> PostgreSQL Global Development Group the right to use said image on the
> postgresql.org website.
>
> Use by PostgreSQL International sites is possible, but a right to use
> must be granted by Emily Boyd for each licensee, as per the terms of the
> original license on the image.
Hmm. As phrased, this would seem to require Emily to write a grant for
each Postgres mirror site. While she might be happy to do that, I think
it'd become a bookkeeping nightmare in no time. If the license you have
for the image requires these sorts of pushups then I agree with Joshua
--- we should look elsewhere.
Could we see the exact terms under which you licensed the image?
regards, tom lane
On Mon, Dec 20, 2004 at 11:07:04AM -0500, Robert Treat wrote: > On Mon, 2004-12-20 at 09:06, Dave Page wrote: > 3) Downloads->BitTorrent-> only has links to the 8.0beta4, can we get a > copy of 7.4.6 and 8.0rc1 ? Um, bt.postgresql.org has rc1. What didn't I fix? Cheers, D -- David Fetter david@fetter.org http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote!
> -----Original Message----- > From: David Fetter [mailto:david@fetter.org] > Sent: 21 December 2004 06:48 > To: Robert Treat > Cc: Dave Page; pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Ready to launch? > > On Mon, Dec 20, 2004 at 11:07:04AM -0500, Robert Treat wrote: > > On Mon, 2004-12-20 at 09:06, Dave Page wrote: > > > 3) Downloads->BitTorrent-> only has links to the 8.0beta4, > can we get a > > copy of 7.4.6 and 8.0rc1 ? > > Um, bt.postgresql.org has rc1. What didn't I fix? Nothing - the new site has links to the main torrents (which I fixed last night): http://wwwmaster.postgresql.org/download/bittorrent Regards, Dave.
> -----Original Message----- > From: Robert Treat [mailto:xzilla@users.sourceforge.net] > Sent: 20 December 2004 16:07 > To: Dave Page > Cc: pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Ready to launch? > > > 1) "about the new website" link in the announcement doesn't > go anywhere, > did someone have content for that? Link removed for now. > 2) Under About->Press we have a link to the 8.0 press kit and > in the FAQ > it stats 8.0 is the most recent version. Perhaps those links > should be > hidden for now? Done. > 3) Downloads->BitTorrent-> only has links to the 8.0beta4, > can we get a > copy of 7.4.6 and 8.0rc1 ? Added. > 4) More of a IMO thing, but I think the links in > Documentation->Manuals->[current|archive] should be changed > so that with > user comments is listed first. Done. > 5) Documentation->FAQ seems fairly busted. Since we have all of the > language FAQ's working on the current site, I think this needs to be > straightened out before we go live. Links pointed to auto-updating docs from CVS. > 6) Books should probably be listed in order of Publish date, an added > bonus would be to link to the book information on techdocs (reviews, > recommendations) but not a deal breaker. Not done yet. > 7) I think we should add gborg, pgfoundry, and techdocs to > Community->Resources. possibly devrim's blog roll too, though I dont > know if that is live yet. Done (the first 3) > 8) Support->professional services is blank, we either need to > import the > info from techdocs are create a link to it. Links pointed to techdocs for now. > 9) Support-> hosting is also blank, same story as #8 Links pointed to techdocs for now. > 10) Support-> bug reporting probably should have a link to the > pgsql-bugs archives. Done. > 11) Should the license link in the footer point to the license of the > website? Left as-is (licence applies to code and site). > 12) Anyone else have an issue with the footer links sometimes > overlapping the sponser add? I get this alot in the community > section of > the website. Probably an issue with certain versions of Gecko (now fixed) given the reports on the list. I haven't looked at this. Regards, Dave
On Mon, 20 Dec 2004, Dave Page wrote: > So, with the possible exception of the survey being missing from the > front page, are we ready to launch now? http://wwwmaster.postgresql.org/developer/profiles ... linked from the first paragraph of ... http://wwwmaster.postgresql.org/developer ... gives a "Page Not Found" error. -- Steve Simms <steve@deefs.net> http://www.deefs.net
> -----Original Message----- > From: Steve Simms [mailto:steve@deefs.net] > Sent: 21 December 2004 16:13 > To: pgsql-www@postgresql.org > Cc: Dave Page > Subject: Re: [pgsql-www] Ready to launch? > > On Mon, 20 Dec 2004, Dave Page wrote: > > > So, with the possible exception of the survey being missing from the > > front page, are we ready to launch now? > > http://wwwmaster.postgresql.org/developer/profiles > > ... linked from the first paragraph of ... > > http://wwwmaster.postgresql.org/developer > > ... gives a "Page Not Found" error. That was fixed last night... But thanks :-) Regards, Dave.
On Tue, 21 Dec 2004, Dave Page wrote: > > -----Original Message----- > > From: Steve Simms [mailto:steve@deefs.net] > > > > http://wwwmaster.postgresql.org/developer/profiles > > > > ... gives a "Page Not Found" error. > > That was fixed last night... It still doesn't work for me... Should I be using a different link? Thanks, Steve -- Steve Simms <steve@deefs.net> http://www.deefs.net
> -----Original Message----- > From: Steve Simms [mailto:steve@deefs.net] > Sent: 21 December 2004 16:45 > To: Dave Page > Cc: pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Ready to launch? > > On Tue, 21 Dec 2004, Dave Page wrote: > > > > -----Original Message----- > > > From: Steve Simms [mailto:steve@deefs.net] > > > > > > http://wwwmaster.postgresql.org/developer/profiles > > > > > > ... gives a "Page Not Found" error. > > > > That was fixed last night... > > It still doesn't work for me... Should I be using a different link? http://wwwmaster.postgresql.org/developer/bios Regards, Dave.
On Tue, 21 Dec 2004, Dave Page wrote: > > It still doesn't work for me... Should I be using a different link? > > http://wwwmaster.postgresql.org/developer/bios Ok, in that case, the link in the first paragraph of ... http://wwwmaster.postgresql.org/developer/ ... should be changed to point to that page. :-) Hope this helps, Steve -- Steve Simms <steve@deefs.net> http://www.deefs.net
> -----Original Message----- > From: Steve Simms [mailto:steve@deefs.net] > Sent: 21 December 2004 16:56 > To: Dave Page > Cc: pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Ready to launch? > > On Tue, 21 Dec 2004, Dave Page wrote: > > > > It still doesn't work for me... Should I be using a > different link? > > > > http://wwwmaster.postgresql.org/developer/bios > > Ok, in that case, the link in the first paragraph of ... > > http://wwwmaster.postgresql.org/developer/ > > ... should be changed to point to that page. :-) It was - last night :-) Perhaps you need to refresh? /D
On Tue, 21 Dec 2004, Dave Page wrote: > > Ok, in that case, the link in the first paragraph of ... > > > > http://wwwmaster.postgresql.org/developer/ > > > > ... should be changed to point to that page. :-) > > It was - last night :-) > > Perhaps you need to refresh? I did, several times, and just tried it from a fresh browser on a different server in a different part of the US to boot. :-) The link still points to /developer/profiles, unless I'm greatly mistaken (which is not at all outside of the realm of possibility). Hmm, perhaps this is it. The link in the *sidebar* points to /developer/bios, but the link in the first paragraph of text in the main *content* area (text is "people behind PostgreSQL") still points to /developer/profiles. That's the one I'm talking about. Hope this helps, Steve -- Steve Simms <steve@deefs.net> http://www.deefs.net
> -----Original Message----- > From: Steve Simms [mailto:steve@deefs.net] > Sent: 21 December 2004 17:06 > To: Dave Page > Cc: pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Ready to launch? > > Hmm, perhaps this is it. The link in the *sidebar* points to > /developer/bios, but the link in the first paragraph of text > in the main > *content* area (text is "people behind PostgreSQL") still points to > /developer/profiles. That's the one I'm talking about. > > Hope this helps, Ahh, yes thanks. I thought you meant the menu - didn't realise there was another. It'll be fixed in 5 mins (but will probably take up to 4 hours to update on the site). Sorry for the confusion (and thanks to Gavin as well)! Regards, Dave
On Tue, 21 Dec 2004, Dave Page wrote: > > >> -----Original Message----- >> From: Steve Simms [mailto:steve@deefs.net] >> Sent: 21 December 2004 16:13 >> To: pgsql-www@postgresql.org >> Cc: Dave Page >> Subject: Re: [pgsql-www] Ready to launch? >> >> On Mon, 20 Dec 2004, Dave Page wrote: >> >>> So, with the possible exception of the survey being missing from the >>> front page, are we ready to launch now? >> >> http://wwwmaster.postgresql.org/developer/profiles >> >> ... linked from the first paragraph of ... >> >> http://wwwmaster.postgresql.org/developer >> >> ... gives a "Page Not Found" error. > > That was fixed last night... > unfortunately, I see megera@mira:~/WWW/img $>curl -I http://wwwmaster.postgresql.org/developer/profiles HTTP/1.1 404 Not Found Date: Tue, 21 Dec 2004 17:29:01 GMT Server: Apache/1.3.29 (Unix) PHP/4.3.4 X-Powered-By: PHP/4.3.4 Content-Language: en Content-Type: text/html; charset=utf-8 > But thanks :-) > > Regards, Dave. > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
> -----Original Message----- > From: Oleg Bartunov [mailto:oleg@sai.msu.su] > Sent: 21 December 2004 17:29 > To: Dave Page > Cc: Steve Simms; pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Ready to launch? > > unfortunately, I see > > megera@mira:~/WWW/img $>curl -I > http://wwwmaster.postgresql.org/developer/profiles > HTTP/1.1 404 Not Found > Date: Tue, 21 Dec 2004 17:29:01 GMT > Server: Apache/1.3.29 (Unix) PHP/4.3.4 > X-Powered-By: PHP/4.3.4 > Content-Language: en > Content-Type: text/html; charset=utf-8 Unless there is a third occurance of that URL, it has now been fixed. It might not have made it to the server yet though. The static page generation takes 20+ minutes going full throttle on a virtually unloaded 3GHz P4 with 2GB RAM and x15 U320 disk(!) so I dropped the build frequency down to 4 hours. Regards, Dave
Guys,
I am completely unable to keep up with the traffic on this list over <
28.8 dial-up. If there's something that needs my attention, please
mention it in the subject line, or e-mail me privately?
Thanks!
--Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 752-2500
for law firms, small businesses fax 752-2387
and non-profit organizations. San Francisco
On Tue, Dec 21, 2004 at 08:18:48AM -0000, Dave Page wrote: > > > > -----Original Message----- > > From: David Fetter [mailto:david@fetter.org] > > Sent: 21 December 2004 06:48 > > To: Robert Treat > > Cc: Dave Page; pgsql-www@postgresql.org > > Subject: Re: [pgsql-www] Ready to launch? > > > > On Mon, Dec 20, 2004 at 11:07:04AM -0500, Robert Treat wrote: > > > On Mon, 2004-12-20 at 09:06, Dave Page wrote: > > > > > 3) Downloads->BitTorrent-> only has links to the 8.0beta4, > > can we get a > > > copy of 7.4.6 and 8.0rc1 ? > > > > Um, bt.postgresql.org has rc1. What didn't I fix? > > Nothing - the new site has links to the main torrents (which I fixed > last night): > > http://wwwmaster.postgresql.org/download/bittorrent BTW, RC1 is down & RC2 is up. Cheers, D -- David Fetter david@fetter.org http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote!
On Tuesday 21 December 2004 19:54, David Fetter wrote: > On Tue, Dec 21, 2004 at 08:18:48AM -0000, Dave Page wrote: > > > -----Original Message----- > > > From: David Fetter [mailto:david@fetter.org] > > > Sent: 21 December 2004 06:48 > > > To: Robert Treat > > > Cc: Dave Page; pgsql-www@postgresql.org > > > Subject: Re: [pgsql-www] Ready to launch? > > > > > > On Mon, Dec 20, 2004 at 11:07:04AM -0500, Robert Treat wrote: > > > > On Mon, 2004-12-20 at 09:06, Dave Page wrote: > > > > > > > > 3) Downloads->BitTorrent-> only has links to the 8.0beta4, > > > > > > can we get a > > > > > > > copy of 7.4.6 and 8.0rc1 ? > > > > > > Um, bt.postgresql.org has rc1. What didn't I fix? > > > > Nothing - the new site has links to the main torrents (which I fixed > > last night): > > > > http://wwwmaster.postgresql.org/download/bittorrent > > BTW, RC1 is down & RC2 is up. > David (Fett-dog that is), do you think you could update this page whenever you update the bittorrent site? Alternativly (and preferrably) is there some way we could make this automagic? Maybe an rss/xml scrape of the bittorrent site could be set up? -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
On Tue, Dec 21, 2004 at 08:32:44PM -0500, Robert Treat wrote: > On Tuesday 21 December 2004 19:54, David Fetter wrote: > > On Tue, Dec 21, 2004 at 08:18:48AM -0000, Dave Page wrote: > > > > > > http://wwwmaster.postgresql.org/download/bittorrent > > > > BTW, RC1 is down & RC2 is up. > > > > David (Fett-dog that is), do you think you could update this page whenever you > update the bittorrent site? Alternativly (and preferrably) is there some way > we could make this automagic? Maybe an rss/xml scrape of the bittorrent site > could be set up? Happy to. What access(es) do I need to do this, and what's The Right Way(TM)? Cheers, D -- David Fetter david@fetter.org http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote!
On Tuesday 21 December 2004 20:40, David Fetter wrote: > On Tue, Dec 21, 2004 at 08:32:44PM -0500, Robert Treat wrote: > > On Tuesday 21 December 2004 19:54, David Fetter wrote: > > > On Tue, Dec 21, 2004 at 08:18:48AM -0000, Dave Page wrote: > > > > http://wwwmaster.postgresql.org/download/bittorrent > > > > > > BTW, RC1 is down & RC2 is up. > > > > David (Fett-dog that is), do you think you could update this page > > whenever you update the bittorrent site? Alternativly (and preferrably) > > is there some way we could make this automagic? Maybe an rss/xml scrape > > of the bittorrent site could be set up? > > Happy to. What access(es) do I need to do this, and what's The Right > Way(TM)? > I guess for you to do this we'll have to add you as a developer of the pgweb project, (anyone see any problems with that?) and then you can find the file under portal/template/en/download/bittorrent.html. Dave has already fixed it for this release though, so we can revisit this when final/rc3 comes out. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
On Tue, 21 Dec 2004, Dave Page wrote: > > >> -----Original Message----- >> From: Oleg Bartunov [mailto:oleg@sai.msu.su] >> Sent: 21 December 2004 17:29 >> To: Dave Page >> Cc: Steve Simms; pgsql-www@postgresql.org >> Subject: Re: [pgsql-www] Ready to launch? >> >> unfortunately, I see >> >> megera@mira:~/WWW/img $>curl -I >> http://wwwmaster.postgresql.org/developer/profiles >> HTTP/1.1 404 Not Found >> Date: Tue, 21 Dec 2004 17:29:01 GMT >> Server: Apache/1.3.29 (Unix) PHP/4.3.4 >> X-Powered-By: PHP/4.3.4 >> Content-Language: en >> Content-Type: text/html; charset=utf-8 > > Unless there is a third occurance of that URL, it has now been fixed. It > might not have made it to the server yet though. The static page > generation takes 20+ minutes going full throttle on a virtually unloaded > 3GHz P4 with 2GB RAM and x15 U320 disk(!) so I dropped the build > frequency down to 4 hours. > How much pages rebuildes and does everything rebuilded each run, regardless on changes ? 20+ minutes looks too much for medium sized server. > Regards, Dave > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
> -----Original Message----- > From: Oleg Bartunov [mailto:oleg@sai.msu.su] > Sent: 22 December 2004 13:26 > To: Dave Page > Cc: Steve Simms; pgsql-www@postgresql.org > Subject: RE: [pgsql-www] Ready to launch? > > How much pages rebuildes and does everything rebuilded each run, > regardless on changes ? > 20+ minutes looks too much for medium sized server. > It builds around 10,000 pages, and does so by spidering the site as an indexer would, and saving the output. It's clearly not the most efficient way, but given the number of different ways that pages get built on the site, it is certainly the most maintainable. I have a suspicion that it might not be avoiding saving duplicate links but I haven't checked that yet. Regards, Dave
Hi, Dave Page wrote: >>How much pages rebuildes and does everything rebuilded each run, >>regardless on changes ? >>20+ minutes looks too much for medium sized server. > > It builds around 10,000 pages, and does so by spidering the site as an > indexer would, and saving the output. It's clearly not the most > efficient way, but given the number of different ways that pages get > built on the site, it is certainly the most maintainable. Do you spider all the static docs every time? They only need to be regenerated on design change or docs update after a new release. > I have a suspicion that it might not be avoiding saving duplicate links > but I haven't checked that yet. If it was *that* stupid, the mirroring would take *much* more than 20 minutes. ;]
> -----Original Message----- > From: Alexey Borzov [mailto:borz_off@cs.msu.su] > Sent: 22 December 2004 14:48 > To: Dave Page > Cc: Oleg Bartunov; Steve Simms; pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Ready to launch? > > Hi, > > Dave Page wrote: > >>How much pages rebuildes and does everything rebuilded each run, > >>regardless on changes ? > >>20+ minutes looks too much for medium sized server. > > > > It builds around 10,000 pages, and does so by spidering the > site as an > > indexer would, and saving the output. It's clearly not the most > > efficient way, but given the number of different ways that pages get > > built on the site, it is certainly the most maintainable. > > Do you spider all the static docs every time? They only need to be > regenerated on design change or docs update after a new release. At the moment it spiders the whole site, exactly as you wrote it (with the exception that it ignores /redir). > > I have a suspicion that it might not be avoiding saving > duplicate links > > but I haven't checked that yet. > > If it was *that* stupid, the mirroring would take *much* more than 20 > minutes. ;] Would it? I don't know how many links there are to the doc sets. Mind you, I suppose each doc links to the next and previous, so it would hit each at least 3 times which it clearly isn't. Regards, Dave.
Hi, Dave Page wrote: >>Do you spider all the static docs every time? They only need to be >>regenerated on design change or docs update after a new release. > > At the moment it spiders the whole site, exactly as you wrote it (with > the exception that it ignores /redir). Yes, I also wrote it to accept a -r preg_pattern command line switch. Running it like mirror.php -r "~/static/~" (not tested) may do the trick... The script also knows the standard -h / --help switch, BTW... > Would it? I don't know how many links there are to the doc sets. Mind > you, I suppose each doc links to the next and previous, so it would hit > each at least 3 times which it clearly isn't. Of course, the saved links are remembered and are not crawled again.
On Wed, 22 Dec 2004, Dave Page wrote:
>
>
>> -----Original Message-----
>> From: Oleg Bartunov [mailto:oleg@sai.msu.su]
>> Sent: 22 December 2004 13:26
>> To: Dave Page
>> Cc: Steve Simms; pgsql-www@postgresql.org
>> Subject: RE: [pgsql-www] Ready to launch?
>>
>> How much pages rebuildes and does everything rebuilded each run,
>> regardless on changes ?
>> 20+ minutes looks too much for medium sized server.
>>
>
> It builds around 10,000 pages, and does so by spidering the site as an
> indexer would, and saving the output. It's clearly not the most
> efficient way, but given the number of different ways that pages get
> built on the site, it is certainly the most maintainable.
>
> I have a suspicion that it might not be avoiding saving duplicate links
> but I haven't checked that yet.
if you spidering via http you could ask if page was modified since last rebuild
and you'll save a lot. Check is your servers actually provides such information,
probably you need to configure them properly.
>
> Regards, Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
On Wed, 22 Dec 2004, Alexey Borzov wrote:
> Hi,
>
> Dave Page wrote:
>>> How much pages rebuildes and does everything rebuilded each run,
>>> regardless on changes ?
>>> 20+ minutes looks too much for medium sized server.
>>
>> It builds around 10,000 pages, and does so by spidering the site as an
>> indexer would, and saving the output. It's clearly not the most
>> efficient way, but given the number of different ways that pages get
>> built on the site, it is certainly the most maintainable.
>
> Do you spider all the static docs every time? They only need to be
> regenerated on design change or docs update after a new release.
>
using SSI (server side include) could save even if design was changed
(with accuracy to header/footer components).
>> I have a suspicion that it might not be avoiding saving duplicate links
>> but I haven't checked that yet.
>
> If it was *that* stupid, the mirroring would take *much* more than 20
> minutes. ;]
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
> -----Original Message----- > From: Oleg Bartunov [mailto:oleg@sai.msu.su] > Sent: 22 December 2004 15:20 > To: Dave Page > Cc: Steve Simms; pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Ready to launch? > > if you spidering via http you could ask if page was modified > since last rebuild > and you'll save a lot. Check is your servers actually > provides such information, > probably you need to configure them properly. Most of the pages are dynamically built by php code from numerous files & the database, so the server isn't going to know if they have changed :-( Regards, Dave
On Wed, 22 Dec 2004, Dave Page wrote:
>
>
>> -----Original Message-----
>> From: Oleg Bartunov [mailto:oleg@sai.msu.su]
>> Sent: 22 December 2004 15:20
>> To: Dave Page
>> Cc: Steve Simms; pgsql-www@postgresql.org
>> Subject: Re: [pgsql-www] Ready to launch?
>>
>> if you spidering via http you could ask if page was modified
>> since last rebuild
>> and you'll save a lot. Check is your servers actually
>> provides such information,
>> probably you need to configure them properly.
>
> Most of the pages are dynamically built by php code from numerous files
> & the database, so the server isn't going to know if they have changed
> :-(
So, that php-code should be corrected to issue right headers. Marc should
know how.
>
> Regards, Dave
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
Hi, Oleg Bartunov wrote: >>> if you spidering via http you could ask if page was modified >>> since last rebuild >>> and you'll save a lot. Check is your servers actually >>> provides such information, >>> probably you need to configure them properly. >> >> >> Most of the pages are dynamically built by php code from numerous files >> & the database, so the server isn't going to know if they have changed >> :-( > > > So, that php-code should be corrected to issue right headers. Marc should > know how. Please note that code to issue right headers will not necessarily work faster than the code to just dispatch the page.
On Wed, 22 Dec 2004, Oleg Bartunov wrote: > On Wed, 22 Dec 2004, Dave Page wrote: > >> >> >>> -----Original Message----- >>> From: Oleg Bartunov [mailto:oleg@sai.msu.su] >>> Sent: 22 December 2004 15:20 >>> To: Dave Page >>> Cc: Steve Simms; pgsql-www@postgresql.org >>> Subject: Re: [pgsql-www] Ready to launch? >>> >>> if you spidering via http you could ask if page was modified >>> since last rebuild >>> and you'll save a lot. Check is your servers actually >>> provides such information, >>> probably you need to configure them properly. >> >> Most of the pages are dynamically built by php code from numerous files >> & the database, so the server isn't going to know if they have changed >> :-( > > So, that php-code should be corrected to issue right headers. Marc should > know how. Nope, can't help with this one ... with the archives/php, we are setting Last-Modified based on the Date of the email message itself ... we were originally doing it based on timestamp of the message file itself, but that wouldn't work with Alexey's code, since it links in several files, any of which could, in theory, have changed since teh last build :( ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
> -----Original Message----- > From: Oleg Bartunov [mailto:oleg@sai.msu.su] > Sent: 22 December 2004 17:07 > To: Dave Page > Cc: Steve Simms; pgsql-www@postgresql.org > Subject: RE: [pgsql-www] Ready to launch? > > > Most of the pages are dynamically built by php code from > numerous files > > & the database, so the server isn't going to know if they > have changed > > :-( > > So, that php-code should be corrected to issue right headers. > Marc should > know how. Err, probably not - he hasn't had much to do with the new site's code. Besides, to give an example, if considering one docs page (which accounts for the vast majority of the site), there are 10 php scripts involved (the main site handler, the doc handler, plus settings, global funtions and Pear code), as well as a record in the database. Checking the freshness of each of those will likely cost more or at least as much as just serving the page anyway (remember, it's spidering form the same machine, so there is no real network bottleneck), and would be particularly tricky to code well I imagine. Regards, Dave