pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedDetecting postgres servers
4+ messages / 3 participants
[nested] [flat]
* Detecting postgres servers
@ 2005-11-19 17:34 Murray Cumming <murrayc@murrayc.com>
2006-01-10 20:42 ` Re: Detecting postgres servers Murray Cumming <murrayc@murrayc.com>
0 siblings, 1 reply; 4+ messages in thread
From: Murray Cumming @ 2005-11-19 17:34 UTC (permalink / raw)
To: pgsql-interfaces
Is there any way, without a username and password, to
1. Detect whether a Postgres server is running on a certain host on a
certain port.
2. Detect whether a Postgres server is running on a certain host.
3. Detect whether a Postgres server is running somewhere on the local
network, via some bonjour/rendezvous/avahi/howl-type thing?
--
Murray Cumming
murrayc@murrayc.com
www.murrayc.com
www.openismus.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Detecting postgres servers
2005-11-19 17:34 Detecting postgres servers Murray Cumming <murrayc@murrayc.com>
@ 2006-01-10 20:42 ` Murray Cumming <murrayc@murrayc.com>
2006-01-10 20:49 ` Re: Detecting postgres servers Jaime Casanova <systemguards@gmail.com>
2006-01-10 21:00 ` Re: Detecting postgres servers Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 4+ messages in thread
From: Murray Cumming @ 2006-01-10 20:42 UTC (permalink / raw)
To: pgsql-interfaces
On Sat, 2005-11-19 at 18:34 +0100, Murray Cumming wrote:
> Is there any way, without a username and password, to
> 1. Detect whether a Postgres server is running on a certain host on a
> certain port.
> 2. Detect whether a Postgres server is running on a certain host.
> 3. Detect whether a Postgres server is running somewhere on the local
> network, via some bonjour/rendezvous/avahi/howl-type thing?
Does anybody have any ideas about this?
Is a patch to add discovery via avahi likely to be accepted?
--
Murray Cumming
murrayc@murrayc.com
www.murrayc.com
www.openismus.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Detecting postgres servers
2005-11-19 17:34 Detecting postgres servers Murray Cumming <murrayc@murrayc.com>
2006-01-10 20:42 ` Re: Detecting postgres servers Murray Cumming <murrayc@murrayc.com>
@ 2006-01-10 20:49 ` Jaime Casanova <systemguards@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Jaime Casanova @ 2006-01-10 20:49 UTC (permalink / raw)
To: Murray Cumming <murrayc@murrayc.com>; +Cc: pgsql-interfaces
On 1/10/06, Murray Cumming <murrayc@murrayc.com> wrote:
> On Sat, 2005-11-19 at 18:34 +0100, Murray Cumming wrote:
> > Is there any way, without a username and password, to
> > 1. Detect whether a Postgres server is running on a certain host on a
> > certain port.
> > 2. Detect whether a Postgres server is running on a certain host.
> > 3. Detect whether a Postgres server is running somewhere on the local
> > network, via some bonjour/rendezvous/avahi/howl-type thing?
>
> Does anybody have any ideas about this?
>
> Is a patch to add discovery via avahi likely to be accepted?
>
> --
> Murray Cumming
> murrayc@murrayc.com
> www.murrayc.com
> www.openismus.com
>
>
imagine you can port scan, and try to connect on every open port
starting with default one for postgres (5432)...
but this sounds like an attack to me...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Detecting postgres servers
2005-11-19 17:34 Detecting postgres servers Murray Cumming <murrayc@murrayc.com>
2006-01-10 20:42 ` Re: Detecting postgres servers Murray Cumming <murrayc@murrayc.com>
@ 2006-01-10 21:00 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2006-01-10 21:00 UTC (permalink / raw)
To: Murray Cumming <murrayc@murrayc.com>; +Cc: pgsql-interfaces
Murray Cumming <murrayc@murrayc.com> writes:
> On Sat, 2005-11-19 at 18:34 +0100, Murray Cumming wrote:
>> Is there any way, without a username and password, to
>> 1. Detect whether a Postgres server is running on a certain host on a
>> certain port.
>> 2. Detect whether a Postgres server is running on a certain host.
>> 3. Detect whether a Postgres server is running somewhere on the local
>> network, via some bonjour/rendezvous/avahi/howl-type thing?
We have bonjour code, but it's written to Apple's API and hence only
works on Darwin. There was some talk recently of revising that code
to be more portable ... dunno if anyone is actually working on it,
but check the archives.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-01-10 21:00 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-19 17:34 Detecting postgres servers Murray Cumming <murrayc@murrayc.com>
2006-01-10 20:42 ` Murray Cumming <murrayc@murrayc.com>
2006-01-10 20:49 ` Jaime Casanova <systemguards@gmail.com>
2006-01-10 21:00 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox