Re: [DOCS] correct reference external-projects.sgml
On Tue, Oct 16, 2007 at 01:34:01PM +0900, Hiroshi Saito wrote: > Hi. > > Please check it. > Thanks! Applied, thanks. (Oh, sorry, forgot to put your name on the commit :-S) //Magnus ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [DOCS] Use of "token" vs "lexeme" in text search documentation
On Mon, 15 Oct 2007, Tom Lane wrote: The current documentation seems a bit inconsistent in its use of the terms "token" and "lexeme". The majority of the text seems to use "lexeme" exclusively, which is inconsistent with the fact that the term "token" is exposed by ts_token_type() and friends. But there are a few places that seem to use "lexeme" to mean something returned by a dictionary. I was considering trying to adopt these conventions: * What a parser returns is a "token". * When a dictionary recognizes a token, what it returns is a "lexeme". This would make the phrase "normalized lexeme" redundant, since we don't call it a lexeme at all unless it's been normalized. Comments? Hmm, you say what I always thought. I'd be happy if you stress this in docs. regards, tom lane Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [DOCS] correct reference external-projects.sgml
On Tuesday 16 October 2007 08:14, Magnus Hagander wrote:
> On Tue, Oct 16, 2007 at 01:34:01PM +0900, Hiroshi Saito wrote:
> > Hi.
> >
> > Please check it.
> > Thanks!
>
> Applied, thanks.
>
> (Oh, sorry, forgot to put your name on the commit :-S)
>
The link for libpqxx should either be reverted or changed to libpqxx.org, of
the three, .tk is the least desired.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Re: [DOCS] FAQ corrections
On Friday 12 October 2007 14:04, Ian Barwick wrote:
> Hi
>
> attached some minor corrections, mainly completion of removal of
> the "relation with OID # does not exist" item, and some URL
> corrections.
>
I'm curious why this was removed. We still get this question a bit on irc and
there aren't any more appropriate answers for any released version than what
the FAQ contained...
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 6: explain analyze is your friend
Re: [DOCS] Slony for upgrades
On Tuesday 16 October 2007 01:38, Bruce Momjian wrote:
> Jeff Frost wrote:
> > On Mon, 15 Oct 2007, Bruce Momjian wrote:
> > > Seems we didn't have any mention of Slony for upgrades in the migration
> > > section, so I added it:
> > >
> > >
> > > It is also possible to use Slony to create a slave
> > > server with the updated version of PostgreSQL. The
> > > slave can be on the same computer or a different computer. Once it
> > > has synced up with the master server (running the older version of
> > > PostgreSQL), you can switch masters and make the
> > > slave the master and shut down the older database instance. Such a
> > > switch-over results in only several minutes of downtime for an upgrade.
> > >
> >
> > Bruce, do you think we should say several minutes of downtime? It's been
> > my experience that the downtime is usually measurable in seconds. I
> > don't think I've ever had a switchover take more than 1 minute.
> >
> > Excellent catch and good work by the way!
>
> Thanks, changed to seconds. I thought someone told me <5 minutes a
> while ago but I might have been mistaken.
I might question the strict reference to Slony here. AIUI you could do the
same thing with Bucardo and a couple of other replication solutions as well.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Re: [DOCS] correct reference external-projects.sgml
Robert Treat wrote: > On Tuesday 16 October 2007 08:14, Magnus Hagander wrote: >> On Tue, Oct 16, 2007 at 01:34:01PM +0900, Hiroshi Saito wrote: >>> Hi. >>> >>> Please check it. >>> Thanks! >> Applied, thanks. >> >> (Oh, sorry, forgot to put your name on the commit :-S) >> > > The link for libpqxx should either be reverted or changed to libpqxx.org, of > the three, .tk is the least desired. argh, I thought it was the other way around :-( fixed. (Except it's pqxx.org, not libpqxx.org, according to their site) //Magnus ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [DOCS] Slony for upgrades
Robert Treat wrote: > On Tuesday 16 October 2007 01:38, Bruce Momjian wrote: > > Jeff Frost wrote: > > > On Mon, 15 Oct 2007, Bruce Momjian wrote: > > > > Seems we didn't have any mention of Slony for upgrades in the migration > > > > section, so I added it: > > > > > > > > > > > > It is also possible to use Slony to create a slave > > > > server with the updated version of PostgreSQL. The > > > > slave can be on the same computer or a different computer. Once it > > > > has synced up with the master server (running the older version of > > > > PostgreSQL), you can switch masters and make the > > > > slave the master and shut down the older database instance. Such a > > > > switch-over results in only several minutes of downtime for an upgrade. > > > > > > > > > > Bruce, do you think we should say several minutes of downtime? It's been > > > my experience that the downtime is usually measurable in seconds. I > > > don't think I've ever had a switchover take more than 1 minute. > > > > > > Excellent catch and good work by the way! > > > > Thanks, changed to seconds. I thought someone told me <5 minutes a > > while ago but I might have been mistaken. > > I might question the strict reference to Slony here. AIUI you could do the > same thing with Bucardo and a couple of other replication solutions as well. OK, I now say "like Slony": It is also possible to use replication like Slony to create a slave server with the updated version of PostgreSQL. The slave can be on the same computer or a different computer. Once it has synced up with the master server (running the older version of PostgreSQL), you can switch masters and make the slave the master and shut down the older database instance. Such a switch-over results in only several seconds of downtime for an upgrade. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [DOCS] FAQ corrections
Robert Treat wrote: > On Friday 12 October 2007 14:04, Ian Barwick wrote: > > Hi > > > > attached some minor corrections, mainly completion of removal of > > the "relation with OID # does not exist" item, and some URL > > corrections. > > > > I'm curious why this was removed. We still get this question a bit on irc and > there aren't any more appropriate answers for any released version than what > the FAQ contained... The FAQ will match the release it goes with or we could just delay its removal until after 8.3 is in major circulation and say it only applies to pre-8.3. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [DOCS] FAQ corrections
On Tuesday 16 October 2007 15:46, Bruce Momjian wrote:
> Robert Treat wrote:
> > On Friday 12 October 2007 14:04, Ian Barwick wrote:
> > > Hi
> > >
> > > attached some minor corrections, mainly completion of removal of
> > > the "relation with OID # does not exist" item, and some URL
> > > corrections.
> >
> > I'm curious why this was removed. We still get this question a bit on irc
> > and there aren't any more appropriate answers for any released version
> > than what the FAQ contained...
>
> The FAQ will match the release it goes with or we could just delay its
> removal until after 8.3 is in major circulation and say it only applies
> to pre-8.3.
I think it should remain, with an addition that this problem should be
resolved as of PostgreSQL 8.3. Hard to say exactly when, but I would think
it would be at least untill 8.3 is released, and probably better would be 6
months or so later, when (hopefully) people stop asking about this. IMHO.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
