Re: More Snow Leopard problems...

________________________________________
From: Jan Otto [asche@me.com]
Sent: Monday, September 07, 2009 9:37 AM
To: Tom Lane
Cc: Levan, Jerry; pgsql-general@postgresql.org general
Subject: Re: [GENERAL] More Snow Leopard problems...

hi jerry,

>> could not lookup DNS configuration info service: (ipc/send) invalid
>> destination port
>> LOG:  could not resolve "localhost": nodename nor servname provided,
>> or not known
>> LOG:  disabling statistics collector for lack of working socket
>> WARNING:  autovacuum not started because of misconfiguration
>> HINT:  Enable the "track_counts" option.
>> DNSServiceDiscoveryLookupServer(): {/SourceCache/mDNSResponder/
>> mDNSResponder-212.1/mDNSMacOSX/DNSServiceDiscovery.c:143}
>> bootstrap_look_up() failed: $10000003
>
> I wonder whether adding or removing --with-bonjour (whichever way
> you didn't configure it) would make a difference.

try killing mDNSResponder before restarting postgres:

sudo killall mDNSResponder

hopefully apple fixes this dns-problems in 10.6.1.

regards, jan otto


Wow, everything has really gone to h*ll...

I must be cursed. Yesterday I booted the SL Distribution disk and used the Disk Utility
to check the integrity of the disk... Disk Utility could not find any problems.

Today after I found that pg would not start due to a checksum error in the Control File
I *tried* to reboot the system but I get a kernel trap at boot so no joy in Mudville...

I am running a clone of the system I made friday via SuperDuper.  Postgresql is
running in the clone ( all I am missing is about 15 records I inserted Saturday).

I probably will try to restore from the clone...

It might be best to reformat and reinstall SL but I find the prospect of trying to restore and
configure the vast amount of apps mind boggling....

Sigh,

Jerry