X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EAF203B6E66 for ; Thu, 16 Dec 2004 17:01:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51762-03 for ; Thu, 16 Dec 2004 17:01:17 +0000 (GMT) Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by svr1.postgresql.org (Postfix) with ESMTP id 1429F3B6ECA for ; Thu, 16 Dec 2004 17:01:16 +0000 (GMT) Received: from DonAcer (unknown [84.12.26.148]) by smtp.nildram.co.uk (Postfix) with SMTP id 61196274E33 for ; Thu, 16 Dec 2004 17:01:11 +0000 (GMT) Message-ID: <002801c4e390$d6633c40$6464a8c0@DonAcer> From: "Donald Fraser" To: "[ADMIN]" References: <002e01c4e37a$5ab3bae0$6464a8c0@DonAcer> <25438.1103215307@sss.pgh.pa.us> Subject: Re: Notifications Date: Thu, 16 Dec 2004 17:01:04 -0000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.014 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/170 X-Sequence-Number: 15756 Hmm I thought as much but I'm not really that up on socket connections to know whether a connection could share both TCP and UPD packet types. This leaves me rather clueless as to why I don't get NOTIFY messages accross the internet yet I can connect, send and receive sql statements no problems. Actually thinking about it now - connections to our sever accross the internet use SSL whilst local connections don't. Could there be some sort of problem with SSL ? I guess I can change the software to force local users to use SSL as another test. Other than that I'm lost as to what is happening to the messages.... Regards Donald Fraser ----- Original Message ----- From: "Tom Lane" To: "Donald Fraser" Cc: "[ADMIN]" Sent: Thursday, December 16, 2004 4:41 PM Subject: Re: [ADMIN] Notifications > "Donald Fraser" writes: >> I'm having problems receiving NOTIFY messages when outside our local = >> network. >> I have dissabled firewall setting but nothing seems to fix the problem. >> I was wandering if NOTIFY messages use UDP or TCP, as that would = >> possibly explain why they are not arriving? > > You're certainly barking up the wrong tree. NOTIFY messages go through > your regular database connection --- if you are able to connect to the > database at all, you can get NOTIFY messages. > > regards, tom lane >