|From:||Mathias Hasselmann <mathias(at)openismus(dot)com>|
|Cc:||pgsql-patches(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, Murray Cumming <murrayc(at)openismus(dot)com>|
|Subject:||Re: [HACKERS] Avahi support for Postgresql|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
Am Samstag, den 29.03.2008, 12:25 +0000 schrieb tomas(at)tuxteam(dot)de:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> On Sat, Feb 23, 2008 at 01:13:38PM +0100, Mathias Hasselmann wrote:
> > Avahi/Bonjour/DNS-SD support is very important, for integrating
> > Postgresql with modern desktop environments like OSX, GNOME, KDE: It's
> > very convenient to choose active DBMS servers in your local network from
> > a list, instead of memorizing "cryptic" connection parameters.
> > People not wanting DNS-SD support for their server can easily control
> > that feature via the "--with-avahi" configure scripts.
> Sorry for a dumb question, but I couldn't figure that out from your
> references ..: does that mean that the PostgreSQL server would
> "advertise itself" on the local net? Or what is the purpose of liking-in
> libavahi into the postmaster?
Yes, that's the purpose.
> Surely one wouldn't want this in a data center?
Yes, this feature definitely targets small-office use, personal use, DB
developers. Don't know enough about data centers to judge the impact
there, but since Avahi - as used in the patch - announces to the local
network only, the impact sould be small.
Still you can tell Avahi to explicitly announce at a certain, non-local
domain, but this feature is not implemented by the patch. Maybe database
developers in large network environments could make use of such
announcements. It would be trivial to add.
> Is there a possiblity to disable that at run time?
The feature is disabled by default. As long as you do not specify a
zeroconf_name in your configuration file, nothing happens. This is the
same behavior as established by the Bonjour code.
Mathias Hasselmann <mathias(at)openismus(dot)com>
http://www.openismus.com/ - We can get it done.
|Next Message||NikhilS||2008-04-01 08:40:02||Re: [email@example.com: Re: [BUGS] Problem identifying constraints which should not be inherited]|
|Previous Message||Tom Lane||2008-04-01 04:58:44||Re: Consistent \d commands in psql|
|Next Message||Pavan Deolasee||2008-04-01 07:37:20||Re: [HACKERS] ANALYZE getting dead tuple count hopelessly wrong|
|Previous Message||Guillaume Smet||2008-04-01 06:52:55||Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work|