Skip site navigation (1) Skip section navigation (2)

Re: [COMMITTERS] pgsql: Add connection messages for streaming replication.

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [COMMITTERS] pgsql: Add connection messages for streaming replication.
Date: 2010-03-24 10:29:56
Message-ID: 1269426596.8481.7714.camel@ebony (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
On Wed, 2010-03-24 at 17:36 +0900, Fujii Masao wrote:
> On Wed, Mar 24, 2010 at 2:25 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> > The main thing for me was that it logged something. The above two ways
> > occurred to me and figured we'd end up discussing it.
> >
> > The first way is slightly confusing for the reason stated, agreed. By
> > using the same form of words as is used currently, all existing scripts
> > that search for connection details will all still work. The second way
> > is more informative, if you don't know "replication" is a
> > pseudo-database, but it will break all existing scripts.
> >
> > My own feeling was that breaking existing scripts was not a price worth
> > paying for the extra information in the second form of the message,
> > since its just the same words re-arranged.
> 
> Since the meaning of the first message is different between 8.4 and 9.0
> (in 8.4, the normal connection to the database 'replication', in 9.0, the
> connection for replication from the standby server), we would still need
> to change the existing scripts. No?
> 
> What is worse is that we can connect to the real database 'replication'
> in 9.0. So we might be unable to discern that normal connection from the
> replication connection by seeing the first message.

So we are allowing a database to be called "REPLICATION"? Surely there
are some significant problems in that case. How will access control to
that database work in the pg_hba.conf?

-- 
 Simon Riggs           www.2ndQuadrant.com


In response to

Responses

pgsql-hackers by date

Next:From: Fujii MasaoDate: 2010-03-24 10:49:48
Subject: Re: [COMMITTERS] pgsql: Add connection messages for streaming replication.
Previous:From: Fujii MasaoDate: 2010-03-24 08:36:18
Subject: Re: [COMMITTERS] pgsql: Add connection messages for streaming replication.

pgsql-committers by date

Next:From: Fujii MasaoDate: 2010-03-24 10:49:48
Subject: Re: [COMMITTERS] pgsql: Add connection messages for streaming replication.
Previous:From: User ItagakiDate: 2010-03-24 08:45:03
Subject: pgstatsinfo - pg_statsinfo: Allow syslog and eventlog for

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group