On Fri, Apr 14, 2006 at 02:59:10PM +0200, Magnus Hagander wrote:
> > omega kernel: Shorewall:all2all:REJECT:IN= OUT=lo SRC=x.x.x.x
> > DST=x.x.x.x LEN=1016 TOS=0x00 PREC=0x00
> > TTL=64 ID=21629 DF PROTO=UDP SPT=32769 DPT=32769 LEN=996
>
> The PostgreSQL stats collector uses UDP over a random loopback port. It
> should normally use localhost, though and not a "real" IP.
It's a virtual server, that (currently) has no loopback device.
Is it possible to tell the stats collector to use a specific port?
> To see if that's it, turn of the stats collector
> (start_stats_collector=off), restart postgresql (restart needed ,not
> enough to just HUP) and see if they go away.
Apparently this didn't prevent those UDP packets... I'm not certain
about this one, though, since I wasn't the one testing this.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
