[HACKERS] replication and pg_hba.conf

2011-01-16 Thread Magnus Hagander
In 9.0, we specifically require using replication as database name to start a replication session. In 9.1 we will have the REPLICATION attribute to a role - should we change it so that all in database includes replication connections? It certainly goes in the principle of least surprise path.. --

[HACKERS] Replication logging

2011-01-16 Thread Magnus Hagander
Currently, replication connections *always* logs something like: LOG: replication connection authorized: user=mha host=[local] There's no way to turn that off. I can't find the reasoning behind this - why is this one not controlled by log_connections like normal ones? There's a comment in the

Re: [HACKERS] replication and pg_hba.conf

2011-01-16 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: In 9.0, we specifically require using replication as database name to start a replication session. In 9.1 we will have the REPLICATION attribute to a role - should we change it so that all in database includes replication connections? It certainly

Re: [HACKERS] replication and pg_hba.conf

2011-01-16 Thread Josh Berkus
In 9.0, we specifically require using replication as database name to start a replication session. In 9.1 we will have the REPLICATION attribute to a role - should we change it so that all in database includes replication connections? It certainly goes in the principle of least surprise

Re: [HACKERS] Replication logging

2011-01-16 Thread Robert Haas
On Sun, Jan 16, 2011 at 9:19 AM, Magnus Hagander mag...@hagander.net wrote: Currently, replication connections *always* logs something like: LOG:  replication connection authorized: user=mha host=[local] There's no way to turn that off. I can't find the reasoning behind this - why is this

Re: [HACKERS] replication and pg_hba.conf

2011-01-16 Thread Heikki Linnakangas
On 16.01.2011 22:55, Josh Berkus wrote: In 9.0, we specifically require using replication as database name to start a replication session. In 9.1 we will have the REPLICATION attribute to a role - should we change it so that all in database includes replication connections? It certainly goes

Re: [HACKERS] replication and pg_hba.conf

2011-01-16 Thread Magnus Hagander
On Mon, Jan 17, 2011 at 07:44, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 16.01.2011 22:55, Josh Berkus wrote: In 9.0, we specifically require using replication as database name to start a replication session. In 9.1 we will have the REPLICATION attribute to a role -

Re: [HACKERS] Replication logging

2011-01-16 Thread Magnus Hagander
On Mon, Jan 17, 2011 at 03:06, Robert Haas robertmh...@gmail.com wrote: On Sun, Jan 16, 2011 at 9:19 AM, Magnus Hagander mag...@hagander.net wrote: Currently, replication connections *always* logs something like: LOG:  replication connection authorized: user=mha host=[local] There's no way to

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Fujii Masao
On Thu, Jan 7, 2010 at 1:51 AM, Tom Lane t...@sss.pgh.pa.us wrote: This strikes me as a completely bad idea.  We need get no farther than the point that it assumes nobody can have a database named replication Though I might misunderstand your point. My proposal would force the users who have a

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Magnus Hagander
On Thu, Jan 7, 2010 at 07:19, Fujii Masao masao.fu...@gmail.com wrote: On Wed, Jan 6, 2010 at 11:11 PM, Magnus Hagander mag...@hagander.net wrote: I haven't read up on the rest of the patch, but where do we put the rest of the information about the replication master? Like which IP and port to

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Magnus Hagander
On Thu, Jan 7, 2010 at 09:26, Fujii Masao masao.fu...@gmail.com wrote: The same problem also exists in pg_hba.conf. It's because I introduced new keyword replication in pg_hba.conf to authenticate the standby server. This restriction is not acceptable? If so, I'd need to consider an

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Fujii Masao
On Thu, Jan 7, 2010 at 5:44 PM, Magnus Hagander mag...@hagander.net wrote: Such information are supplied in the parameter 'primary_conninfo' of recovery.conf. For example;    primary_conninfo = 'host=192.168.1.50 port=5432 user=foo' So the password can just go there, no? Yeah, the password

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Fujii Masao
On Thu, Jan 7, 2010 at 5:46 PM, Magnus Hagander mag...@hagander.net wrote: However, wouldn't it make more logical sense to replace host/hostssl with replication/replicationssl rather than overload the database field? Seems good. How about the following formats? replication user

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Heikki Linnakangas
Fujii Masao wrote: On Thu, Jan 7, 2010 at 5:44 PM, Magnus Hagander mag...@hagander.net wrote: Such information are supplied in the parameter 'primary_conninfo' of recovery.conf. For example; primary_conninfo = 'host=192.168.1.50 port=5432 user=foo' So the password can just go there, no?

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Heikki Linnakangas
Tom Lane wrote: Fujii Masao masao.fu...@gmail.com writes: The attached patch supports new keyword 'replication' on .pgpass file. This keyword is used to specify the password for the standby server to connect to the primary server. This strikes me as a completely bad idea. We need get no

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Heikki Linnakangas
Magnus Hagander wrote: However, wouldn't it make more logical sense to replace host/hostssl with replication/replicationssl rather than overload the database field? It makes more sense to me to overload the database field. When you connect for replication, you're not connecting to any

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Magnus Hagander
On Thu, Jan 7, 2010 at 10:21, Fujii Masao masao.fu...@gmail.com wrote: On Thu, Jan 7, 2010 at 5:46 PM, Magnus Hagander mag...@hagander.net wrote: However, wouldn't it make more logical sense to replace host/hostssl with replication/replicationssl rather than overload the database field?

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Magnus Hagander
On Thu, Jan 7, 2010 at 13:34, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: Fujii Masao wrote: On Thu, Jan 7, 2010 at 5:44 PM, Magnus Hagander mag...@hagander.net wrote: Such information are supplied in the parameter 'primary_conninfo' of recovery.conf. For example;    

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Tom Lane
Fujii Masao masao.fu...@gmail.com writes: On Thu, Jan 7, 2010 at 5:46 PM, Magnus Hagander mag...@hagander.net wrote: However, wouldn't it make more logical sense to replace host/hostssl with replication/replicationssl rather than overload the database field? Seems good. How about the

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-07 Thread Heikki Linnakangas
Tom Lane wrote: I'm getting more and more confused here. I thought we were talking about client-side .pgpass. This seems to be talking about pg_hba.conf. Yeah, the topic was covertly changed. It seems we have consensus to not change .pgpass, and to leave pg_hba.conf as it is now in the patch

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-06 Thread Alvaro Herrera
Fujii Masao escribió: On Sat, Dec 26, 2009 at 10:55 AM, Fujii Masao masao.fu...@gmail.com wrote: On Fri, Dec 25, 2009 at 9:56 PM, Andrew Dunstan and...@dunslane.net wrote: I don't see the use case for it - .pgpass is for single users, not a whole cluster. And it does support wildcards,

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-06 Thread Magnus Hagander
On Wed, Jan 6, 2010 at 15:02, Alvaro Herrera alvhe...@commandprompt.com wrote: Fujii Masao escribió: On Sat, Dec 26, 2009 at 10:55 AM, Fujii Masao masao.fu...@gmail.com wrote: On Fri, Dec 25, 2009 at 9:56 PM, Andrew Dunstan and...@dunslane.net wrote: I don't see the use case for it -

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-06 Thread Tom Lane
Fujii Masao masao.fu...@gmail.com writes: The attached patch supports new keyword 'replication' on .pgpass file. This keyword is used to specify the password for the standby server to connect to the primary server. This strikes me as a completely bad idea. We need get no farther than the

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-06 Thread Fujii Masao
On Wed, Jan 6, 2010 at 11:11 PM, Magnus Hagander mag...@hagander.net wrote: I haven't read up on the rest of the patch, but where do we put the rest of the information about the replication master? Like which IP and port to connect to? Perhaps it could/should go there? Such information are

[HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-05 Thread Fujii Masao
On Sat, Dec 26, 2009 at 10:55 AM, Fujii Masao masao.fu...@gmail.com wrote: On Fri, Dec 25, 2009 at 9:56 PM, Andrew Dunstan and...@dunslane.net wrote: I don't see the use case for it - .pgpass is for single users, not a whole cluster. And it does support wildcards, which takes care of the 'all'

Re: [HACKERS] replication hooks

2008-06-01 Thread James Mansion
Marko Kreen wrote: There is this tiny matter of replicating schema changes asynchronously, but I suspect nobody actually cares. Few random points about that: I'm not sure I follow you - the Sybase 'warm standby' replication of everything is really useful for business continuity. The

Re: [HACKERS] replication hooks

2008-05-30 Thread Robert Hodges
Hi Marko, Replication requirements vary widely of course, but DDL support is shared by such a wide range of use cases it is very difficult to see how any real solution would fail to include it. This extends to change extraction APIs, however, defined. The question of what DDL to replicate is

[HACKERS] replication hooks

2008-05-29 Thread Marko Kreen
On 5/29/08, Andrew Sullivan [EMAIL PROTECTED] wrote: On Thu, May 29, 2008 at 12:05:18PM -0700, Robert Hodges wrote: people are starting to get religion on this issue I would strongly advocate a parallel effort to put in a change-set extraction API that would allow construction of

Re: [HACKERS] replication hooks

2008-05-29 Thread Andrew Sullivan
On Thu, May 29, 2008 at 11:05:09PM +0300, Marko Kreen wrote: There is this tiny matter of replicating schema changes asynchronously, but I suspect nobody actually cares. I know that Slony's users call this their number one irritant, so I have my doubts nobody cares. But maybe nobody cares

Re: [HACKERS] replication hooks

2008-05-29 Thread Marko Kreen
On 5/29/08, Andrew Sullivan [EMAIL PROTECTED] wrote: On Thu, May 29, 2008 at 11:05:09PM +0300, Marko Kreen wrote: There is this tiny matter of replicating schema changes asynchronously, but I suspect nobody actually cares. I know that Slony's users call this their number one irritant, so

Re: [HACKERS] replication hooks

2008-05-29 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Yeah. The main problem is that unless you do WAL based replication, you cannot achieve transparency. So you need to pick few use cases and tailor you solution for them, which gets uninteresting very fast - user _will_ stumble upon spacial

Re: [HACKERS] Replication documentation addition

2006-10-27 Thread Richard Troy
On Wed, 25 Oct 2006, Bruce Momjian wrote: ...snip... Data partitioning is often done within a single database on a single server and therefore, as a concept, has nothing whatsoever to do with different servers. Similarly, the second paragraph of this section is Uh, why would someone

Re: [HACKERS] Replication documentation addition

2006-10-26 Thread Andrew Sullivan
On Wed, Oct 25, 2006 at 05:46:33PM -0400, Bruce Momjian wrote: Josh Berkus wrote: So, like www.postgresql.org/docs/techdocs/replication? That would work. Yes. I like that idea, but I think that the URL needs to be decided upon, needs to be stable, and needs to be put into the docs. (I

Re: [HACKERS] Replication documentation addition

2006-10-26 Thread Bruce Momjian
With no new additions submitted today, I have moved my text into our SGML documentation: http://momjian.us/main/writings/pgsql/sgml/failover.html Please let me know what additional changes are needed. --- bruce

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-26 Thread Jim C. Nasby
On Wed, Oct 25, 2006 at 08:42:07PM -0400, Bruce Momjian wrote: Jim C. Nasby wrote: Something else worth doing though is to have a paragraph explaining why there's no built-in replication. I don't have time to write something right now, but I can do it later tonight if no one beats me to it.

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-26 Thread Bruce Momjian
Jim C. Nasby wrote: On Wed, Oct 25, 2006 at 08:42:07PM -0400, Bruce Momjian wrote: Jim C. Nasby wrote: Something else worth doing though is to have a paragraph explaining why there's no built-in replication. I don't have time to write something right now, but I can do it later tonight

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-26 Thread Bruce Momjian
Joshua D. Drake wrote: Bruce Momjian wrote: Jim C. Nasby wrote: On Wed, Oct 25, 2006 at 08:42:07PM -0400, Bruce Momjian wrote: Jim C. Nasby wrote: Something else worth doing though is to have a paragraph explaining why there's no built-in replication. I don't have time to write

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-26 Thread Joshua D. Drake
Bruce Momjian wrote: Jim C. Nasby wrote: On Wed, Oct 25, 2006 at 08:42:07PM -0400, Bruce Momjian wrote: Jim C. Nasby wrote: Something else worth doing though is to have a paragraph explaining why there's no built-in replication. I don't have time to write something right now, but I can do it

Re: [HACKERS] Replication documentation addition

2006-10-26 Thread Alexey Klyukin
Hi, A typo: (a write to any server has to be _propogated_) s/propogated/propagated Bruce Momjian wrote: Here is a new replication documentation section I want to add for 8.2: ftp://momjian.us/pub/postgresql/mypatches/replication Comments welcomed. -- Regards, Alexey Klyukin

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-26 Thread Richard Troy
The documentation comes with the open source tarball. Yuck. I would welcome if the docs point to an unofficial wiki (maintained externally from authoritative PostgreSQL developers) or a website listing them and giving a brief of each solution. postgresql.org already does this for events

Re: [HACKERS] Replication documentation addition

2006-10-26 Thread Robert Treat
On Thursday 26 October 2006 10:45, Andrew Sullivan wrote: On Wed, Oct 25, 2006 at 05:46:33PM -0400, Bruce Momjian wrote: Josh Berkus wrote: So, like www.postgresql.org/docs/techdocs/replication? That would work. Yes. I like that idea, but I think that the URL needs to be decided

Re: [HACKERS] Replication documentation addition

2006-10-26 Thread Richard Troy
On Wed, 25 Oct 2006, Josh Berkus wrote: Bruce, It isn't designed for that. It is designed for people to understand what they want, and then they can look around for solutions. I think most agree we don't want a list of solutions in the documentation, though I have a few as examples.

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-26 Thread Jim C. Nasby
On Thu, Oct 26, 2006 at 11:59:57AM -0400, Bruce Momjian wrote: Jim C. Nasby wrote: On Wed, Oct 25, 2006 at 08:42:07PM -0400, Bruce Momjian wrote: Jim C. Nasby wrote: Something else worth doing though is to have a paragraph explaining why there's no built-in replication. I don't have

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-26 Thread Bruce Momjian
Jim C. Nasby wrote: On Thu, Oct 26, 2006 at 11:59:57AM -0400, Bruce Momjian wrote: Jim C. Nasby wrote: On Wed, Oct 25, 2006 at 08:42:07PM -0400, Bruce Momjian wrote: Jim C. Nasby wrote: Something else worth doing though is to have a paragraph explaining why there's no

Re: [HACKERS] Replication documentation addition

2006-10-26 Thread Andrew Sullivan
On Thu, Oct 26, 2006 at 03:06:13PM -0400, Robert Treat wrote: Unfortunately the techdocs system won't support a url like the one above, rather you'll end up with something more like the following http://www.postgresql.org/docs/techdocs.54 which is the GUI Tools Guide (which is linked in

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Cesar Suga
Hi, I also wrote Bruce about that. It happens that, if you 'freely advertise' commercial solutions (rather than they doing so by other vehicles) you will always happen to be an 'updater' to the docs if they change their product lines, if they change their business model, if and if. If you

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Hannu Krosing
Krosing Cc: PostgreSQL-documentation; PostgreSQL-development Subject: Re: [HACKERS] Replication documentation addition OK, I have updated the URL. Please let me know how you like it. There's a typo on line 8, first paragraph: perhaps with only one server allowing write

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Markus Schiltknecht
Hi, Bruce Momjian wrote: I have updated the text. Please let me know what else I should change. I am unsure if I should be mentioning commercial PostgreSQL products in our documentation. I support your POV and vote for not including any pointers to commercial extensions in the official

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Magnus Hagander
I don't think the PostgreSQL documentation should be mentioning commercial solutions. I think maybe the PostgreSQL documentation should be careful about trying to list a complete list of commercial *or* free solutions. Instead linking to something on the main website or on techdocs that can

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Shane Ambler
Bruce Momjian wrote: OK, does that mean we mention EnterpriseDB in the section about Oracle functions? Why not mention MS SQL if they have a better solution? I just don't see where that line can clearly be drawn on what to include. Do we mention Netiza, which is loosely based on PostgreSQL?

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Jim C. Nasby
On Wed, Oct 25, 2006 at 08:22:25PM +0930, Shane Ambler wrote: Bruce Momjian wrote: OK, does that mean we mention EnterpriseDB in the section about Oracle functions? Why not mention MS SQL if they have a better solution? I just don't see where that line can clearly be drawn on what to

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Jim C. Nasby
On Wed, Oct 25, 2006 at 11:38:11AM +0200, Markus Schiltknecht wrote: I can't really get excited about the exclusion of the term 'replication', because it's what most people are looking for. It's a well known term. Sorry if it sounded that way, but I've not meant to avoid that term. snip

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Joshua D. Drake
I am not inclined to add commercial offerings. If people wanted commercial database offerings, they can get them from companies that advertize. People are coming to PostgreSQL for open source solutions, and I think mentioning commercial ones doesn't make sense. If we are to add them, I

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Joshua D. Drake
A big part of the value of Postgresql is the applications and extensions that support it. Hiding the existence of some subset of those just because of the way they're licensed is both underselling postgresql and doing something of a disservice to the user of the document. OK, does that

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Markus Schaber
Hi, Cesar, Cesar Suga wrote: If people (who read the documentation) professionally work with PostgreSQL, they may already have been briefed by those commercial offerings in some way. I think only the source and its tightly coupled (read: can compile along with, free as PostgreSQL)

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Joshua D. Drake
Cesar Suga wrote: Hi, I also wrote Bruce about that. It happens that, if you 'freely advertise' commercial solutions (rather than they doing so by other vehicles) you will always happen to be an 'updater' to the docs if they change their product lines, if they change their business

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
I would think that companies that sell closed-source solutions for PostgreSQL would be modest enough not to push their own agenda for the documentation. I think they should just sit back and hope others suggest it. [ Josh Berkus recently left Green Plum for Sun. ]

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian Sent: Tuesday, October 24, 2006 5:16 PM To: Hannu Krosing Cc: PostgreSQL-documentation; PostgreSQL-development Subject: Re: [HACKERS] Replication documentation addition

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Joshua D. Drake
Bruce Momjian wrote: I would think that companies that sell closed-source solutions for PostgreSQL would be modest enough not to push their own agenda for the documentation. I think they should just sit back and hope others suggest it. [ Josh Berkus recently left Green Plum for Sun. ]

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Magnus Hagander
I also wrote Bruce about that. It happens that, if you 'freely advertise' commercial solutions (rather than they doing so by other vehicles) you will always happen to be an 'updater' to the docs if they change their product lines, if they change their business model, if and if.

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Joshua D. Drake
they change their business model, if and if. That is no different than the open source offerings. We have had several open source offerings that have died over the years. Replicator, for example has always been Replicator and has been around longer than any of the current replication

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Tom Lane
Magnus Hagander [EMAIL PROTECTED] writes: I think this is a good reason not to list *any* of the products by name in the documentation, but instead refer to a page on say techdocs that can be more easily updated. I agree with that. If we have statements about other projects in our docs, we

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Joshua D. Drake
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: I think this is a good reason not to list *any* of the products by name in the documentation, but instead refer to a page on say techdocs that can be more easily updated. I agree with that. If we have statements about other projects

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
Markus Schiltknecht wrote: Hi, Bruce Momjian wrote: I have updated the text. Please let me know what else I should change. I am unsure if I should be mentioning commercial PostgreSQL products in our documentation. I support your POV and vote for not including any pointers to

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
Jim C. Nasby wrote: On Wed, Oct 25, 2006 at 11:38:11AM +0200, Markus Schiltknecht wrote: I can't really get excited about the exclusion of the term 'replication', because it's what most people are looking for. It's a well known term. Sorry if it sounded that way, but I've not meant to

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Markus Schiltknecht
Hi, Jim C. Nasby wrote: Those to statements are at odds with each other, at least based on everyone I've ever talked to in a commercial setting. People will use terms like 'replication', 'HA' or 'clustering' fairly interchangably. Usually what these folks want is some kind of high-availability

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: I think this is a good reason not to list *any* of the products by name in the documentation, but instead refer to a page on say techdocs that can be more easily updated. I agree with that. If we have statements about other

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Joshua D. Drake
Bruce Momjian wrote: Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: I think this is a good reason not to list *any* of the products by name in the documentation, but instead refer to a page on say techdocs that can be more easily updated. I agree with that. If we have statements

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
Joshua D. Drake wrote: Bruce Momjian wrote: Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: I think this is a good reason not to list *any* of the products by name in the documentation, but instead refer to a page on say techdocs that can be more easily updated. I agree with

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Richard Troy
Hi Hannu, everyone, I apologize for not having read the document in question - will do shortly. My comments are brought about by the dialogue I read on list this morning... Here is a new replication documentation section I want to add for 8.2:

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread David Fetter
On Wed, Oct 25, 2006 at 11:38:11AM +0200, Markus Schiltknecht wrote: Can we name the chapter Fail-over, Load-Balancing and Replication Options? That would fit everything and contain the necessary buzz words. ... IMHO, it does not make sense to speak of a synchronous replication for a

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
David Fetter wrote: On Wed, Oct 25, 2006 at 11:38:11AM +0200, Markus Schiltknecht wrote: Can we name the chapter Fail-over, Load-Balancing and Replication Options? That would fit everything and contain the necessary buzz words. ... IMHO, it does not make sense to speak of a

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Casey Duncan
Totally agree. The docs will tend to outlive whatever projects or websites they mention. Best to not bake that into stone. -Casey On Oct 25, 2006, at 3:36 AM, Magnus Hagander wrote: I don't think the PostgreSQL documentation should be mentioning commercial solutions. I think maybe the

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Richard Troy
Here is a new replication documentation section I want to add for 8.2: ftp://momjian.us/pub/postgresql/mypatches/replication ...Read the document, as promissed... First paragraph, (fail over) is inconsistent with title, failover, as are other spots throughout the document. The whole

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
Alexey Klyukin wrote: Hi, A typo: (a write to any server has to be _propogated_) s/propogated/propagated Thanks, fixed. --- Bruce Momjian wrote: Here is a new replication documentation section I want to add for

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Josh Berkus
Bruce, ftp://momjian.us/pub/postgresql/mypatches/replication I'm still not seeing anything in this patch that tells users where they can get replication solutions for PostgreSQL, either OSS or commercial. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
Richard Troy wrote: Here is a new replication documentation section I want to add for 8.2: ftp://momjian.us/pub/postgresql/mypatches/replication ...Read the document, as promissed... First paragraph, (fail over) is inconsistent with title, failover, as are other spots

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
Josh Berkus wrote: Bruce, ftp://momjian.us/pub/postgresql/mypatches/replication I'm still not seeing anything in this patch that tells users where they can get replication solutions for PostgreSQL, either OSS or commercial. It isn't designed for that. It is designed for

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Dawid Kuroczko
On 10/25/06, Bruce Momjian [EMAIL PROTECTED] wrote: Joshua D. Drake wrote: Bruce Momjian wrote: Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: I think this is a good reason not to list *any* of the products by name in the documentation, but instead refer to a page on say

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Josh Berkus
Bruce, It isn't designed for that. It is designed for people to understand what they want, and then they can look around for solutions. I think most agree we don't want a list of solutions in the documentation, though I have a few as examples. Do they? I've seen no discussion of the

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
Josh Berkus wrote: Bruce, It isn't designed for that. It is designed for people to understand what they want, and then they can look around for solutions. I think most agree we don't want a list of solutions in the documentation, though I have a few as examples. Do they? I've

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
Dawid Kuroczko wrote: Bruce, I've read Your documentation and I was left a bit with a feeling that it's a bit too generic. It's almost as if it could be about just about any major database, not PostgreSQL specific. I feel that, when I'm reading PostgreSQL docs I would like to know how to set

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Josh Berkus
Bruce, Most people didn't want a list because there is no way to keep it current in the docs, and a secondary web site was suggested for the list. So, like www.postgresql.org/docs/techdocs/replication? That would work. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
Josh Berkus wrote: Bruce, Most people didn't want a list because there is no way to keep it current in the docs, and a secondary web site was suggested for the list. So, like www.postgresql.org/docs/techdocs/replication? That would work. Yes. -- Bruce Momjian [EMAIL PROTECTED]

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Jim C. Nasby
On Wed, Oct 25, 2006 at 04:42:17PM -0400, Bruce Momjian wrote: Dawid Kuroczko wrote: Bruce, I've read Your documentation and I was left a bit with a feeling that it's a bit too generic. It's almost as if it could be about just about any major database, not PostgreSQL specific. I feel

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Bruce Momjian
Jim C. Nasby wrote: Something else worth doing though is to have a paragraph explaining why there's no built-in replication. I don't have time to write something right now, but I can do it later tonight if no one beats me to it. I thought that was implied in the early paragraph about why there

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread Cesar Suga
Joshua D. Drake wrote: Cesar Suga wrote: Hi, I also wrote Bruce about that. It happens that, if you 'freely advertise' commercial solutions (rather than they doing so by other vehicles) you will always happen to be an 'updater' to the docs if they change their product lines, if they change

Re: [HACKERS] Replication documentation addition

2006-10-24 Thread Hannu Krosing
Ühel kenal päeval, T, 2006-10-24 kell 00:20, kirjutas Bruce Momjian: Here is a new replication documentation section I want to add for 8.2: ftp://momjian.us/pub/postgresql/mypatches/replication This is how data partitioning is currently described there Data Partitioning

Re: [HACKERS] Replication documentation addition

2006-10-24 Thread Markus Schiltknecht
Hannu Krosing wrote: I think the official term for this kind of replication is Shared-Nothing Clustering. Well, that's just another distinction for clusters. Most of the time it's between Shared-Disk vs. Shared-Nothing. You could also see the very Big Irons as a Shared-Everything Cluster.

Re: [HACKERS] Replication documentation addition

2006-10-24 Thread Josh Berkus
Bruce, Here is my first draft of a new replication section for our documentation. I am looking for any comments. Hmmm ... while the primer on different types of replication is fine, I think what users were really looking for is a listing of the different replication solutions which are

Re: [HACKERS] Replication documentation addition

2006-10-24 Thread Markus Schiltknecht
Hello Josh, Josh Berkus wrote: Hmmm ... while the primer on different types of replication is fine, I think what users were really looking for is a listing of the different replication solutions which are available for PostgreSQL and how to get them. Well, let's see what we have: * Shared

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-24 Thread Joshua D. Drake
Looking at that, I'm a) missing PgCluster and b) arguing that we have to admit that we simply can not 'list .. replication solutions ... and how to get them' because all of the solutions mentioned need quite some knowledge and require a more or less complex installation and configuration.

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-24 Thread Simon Riggs
On Tue, 2006-10-24 at 12:34 -0700, Joshua D. Drake wrote: Looking at that, I'm a) missing PgCluster and b) arguing that we have to admit that we simply can not 'list .. replication solutions ... and how to get them' because all of the solutions mentioned need quite some knowledge and

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-24 Thread Joshua D. Drake
Simon Riggs wrote: On Tue, 2006-10-24 at 12:34 -0700, Joshua D. Drake wrote: Looking at that, I'm a) missing PgCluster and b) arguing that we have to admit that we simply can not 'list .. replication solutions ... and how to get them' because all of the solutions mentioned need quite some

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-24 Thread Simon Riggs
On Tue, 2006-10-24 at 15:13 -0700, Joshua D. Drake wrote: If it were me, I would say that the replication option has to be specific to PostgreSQL (e.g; cjdbc or synchronous jakarta pooling doesn't go in). ...and how do you define PostgreSQL exactly? -- Simon Riggs

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-24 Thread Joshua D. Drake
Simon Riggs wrote: On Tue, 2006-10-24 at 15:13 -0700, Joshua D. Drake wrote: If it were me, I would say that the replication option has to be specific to PostgreSQL (e.g; cjdbc or synchronous jakarta pooling doesn't go in). ...and how do you define PostgreSQL exactly? I replication

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-24 Thread Simon Riggs
On Tue, 2006-10-24 at 15:33 -0700, Joshua D. Drake wrote: Simon Riggs wrote: On Tue, 2006-10-24 at 15:13 -0700, Joshua D. Drake wrote: If it were me, I would say that the replication option has to be specific to PostgreSQL (e.g; cjdbc or synchronous jakarta pooling doesn't go in).

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-24 Thread Joshua D. Drake
Simon Riggs wrote: On Tue, 2006-10-24 at 15:33 -0700, Joshua D. Drake wrote: Simon Riggs wrote: On Tue, 2006-10-24 at 15:13 -0700, Joshua D. Drake wrote: If it were me, I would say that the replication option has to be specific to PostgreSQL (e.g; cjdbc or synchronous jakarta pooling

Re: [HACKERS] Replication documentation addition

2006-10-24 Thread Jim C. Nasby
On Mon, Oct 23, 2006 at 11:39:34PM -0400, Bruce Momjian wrote: Query Broadcast Replication --- This involves sending write queries to multiple servers. Read-only queries can be sent to a single server because there is no need for all servers to process it. This

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-24 Thread Jim C. Nasby
On Tue, Oct 24, 2006 at 03:33:03PM -0700, Joshua D. Drake wrote: Simon Riggs wrote: On Tue, 2006-10-24 at 15:13 -0700, Joshua D. Drake wrote: If it were me, I would say that the replication option has to be specific to PostgreSQL (e.g; cjdbc or synchronous jakarta pooling doesn't go

<    1   2   3   4   5   6   7   >