Re: [HACKERS] Avahi support for Postgresql

From: tomas(at)tuxteam(dot)de
To: 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
Date: 2008-04-01 12:02:14
Message-ID: 20080401120213.GA18336@www.trapp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, Apr 01, 2008 at 09:35:56AM +0200, Mathias Hasselmann wrote:
> Am Samstag, den 29.03.2008, 12:25 +0000 schrieb tomas(at)tuxteam(dot)de:
> [...]
> > Sorry for a dumb question, but I couldn't figure that out from your
> > references [1]..[4]: 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 [...]
> 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.

Personally, I'be rather scared than delighted ;-)

> > 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.

Thanks, good to know.

Isn't there a less-intrusive option to linking a lib into each and every
possible server, like a config file in which to put what is to be announced?

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFH8iRFBcgs9XrR2kYRAmJ0AJkB7MkxfYI0nVa4RqHVEV1HYjz41gCdEgWz
YQ2T4Y/xfoLRF4D6hMLbpEk=
=Goho
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonah H. Harris 2008-04-01 12:17:57 Re: actualized SQL/PSM patch
Previous Message Dave Cramer 2008-04-01 11:14:34 Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work

Browse pgsql-patches by date

  From Date Subject
Next Message Albe Laurenz 2008-04-01 13:34:17 Improve shutdown during online backup
Previous Message NikhilS 2008-04-01 08:40:02 Re: [badalex@gmail.com: Re: [BUGS] Problem identifying constraints which should not be inherited]