SOLVED!
With firewall off and pf disabled I spotted a process intended to keep
an audit trail of Internet access. I uninstalled it and hey presto.
Thanks for your help, everyone! Glad to see my macbook is not haunted.
Regards,
Fritz
On Wed, Jul 22, 2015 at 9:23 AM, Chris Mair wrote:
> The plot
425 CEST DEBUG: shmem_exit(0): 7 on_shmem_exit
callbacks to make
2015-07-22 12:03:27.425 CEST DEBUG: proc_exit(0): 2 callbacks to make
2015-07-22 12:03:27.425 CEST DEBUG: exit(0)
Fritz
On Wed, Jul 22, 2015 at 12:05 AM, Adrian Klaver
wrote:
> On 07/21/2015 01:58 PM, Fritz Meissner
This is interesting, I tried nc a few times. Inconsistent results:
- most of the time the first line doesn't get through, even after a long wait
- on sending a second line from the client both lines appear
instantly, and it's 100% from there on
- or I can send a line from the server. The first lin
> 2) I know in your original post you did a which on psql, but is there more
> then one instance/install of Postgres on this machine?
>
> The reason I ask is this from the original post:
>
> psql -Umyuser -d mydb
> sql (9.3.5)
> Type "help" for help.
>
> myuser=#
>
Yeah sorry, that's a copy/paste
>
> So what happens if you?:
>
> ping 127.0.0.1
ping 127.0.0.1
PING 127.0.0.1 (127.0.0.1): 56 data bytes
64 bytes from 127.0.0.1: icmp_seq=0 ttl=64 time=0.044 ms
64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.162 ms
...
> ping localhost
ping localhost
PING localhost (127.0.0.1): 56 data bytes
> and if you have it listen to 127.0.0.1, you see 127.0.0.1 in netstat?
Yes, netstat reflects exactly what I have in listen_addresses:
listen_addresses = '127.0.0.1, ::1'
~ netstat -an | grep 5432
tcp6 0 0 ::1.5432*.*LISTEN
tcp4 0 0
Hosts file:
127.0.0.1 localhost
255.255.255.255 broadcasthost
::1 localhost
On Tue, Jul 21, 2015 at 7:42 PM, Adrian Klaver
wrote:
> On 07/21/2015 10:40 AM, Fritz Meissner wrote:
>
> CCing list
>>
>> On Tue, Jul 21, 2015 at 7:30 PM, Adrian Klaver
>
> Use netstat to look what IP postgres actually binds to.
Nothing unusual:
~ netstat -an | grep 5432
tcp4 0 0 *.5432 *.*LISTEN
tcp6 0 0 *.5432 *.*LISTEN
9767b1c9fd5d8ab1 stream 0 0 9767b1ca01
Hi,
>From the terminal in Mac OS X Yosemite, connecting to homebrew
installed 9.4.4, I have a problem if I specify the host (I know this
comes up all the time, bear with me as I have done a fair amount of
digging already). This works:
psql -Umyuser -d mydb
sql (9.3.5)
Type "help" for help.
myuse
