Re: More Snow Leopard problems...

On Sep 7, 2009, at 11:36 AM, Adrian Klaver wrote:

> On Monday 07 September 2009 6:03:28 am Jerry LeVan wrote:
>> On Sep 6, 2009, at 7:29 PM, Tom Lane wrote:
>>> Jerry LeVan <jerry(dot)levan(at)eku(dot)edu> writes:
>>>> I have compiled a 32 bit ( CC="gcc -arch i386" ) version of
>>>> PG 8.4.0.
>>>
>>> Since that's not the default on SL, have you tried 64 bit?
>>>
>>>> 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.
>>>
>>> regards, tom lane
>>
>> I have killed my database....
>>
>> I rebuilt Postgresql 8.4.0 as a 64 bit system without bonjour...no
>> errors
>>
>> I stopped the backend via pg_ctl stop -D /usr/local/pgsql/data
>>
>> I installed the freshly compiled code
>>
>> I restarted the postgresql backend with /sbin/SystemStarted start
>> PostgreSQK
>>
>> The system does not start because of a checksum error in a control
>> file...
>>
>> Here is the end of the logfile:
>> LOG: received smart shutdown request <--- the shutdown command
>> LOG: shutting down
>> LOG: database system is shut down
>> FATAL: incorrect checksum in control file <--- when I try to
>> restart.
>> FATAL: incorrect checksum in control file <--- second try at
>> restarting...
>>
>> Is there any way I can recover?
>>
>> Jerry
>
> I do not see an initdb in your sequence. You are probably seeing a
> problem with
> the 64 bit version of Postgres trying to read a 32 bit cluster.
>
> --
> Adrian Klaver
> aklaver(at)comcast(dot)net

Gack....Is that documented anywhere?

Anyway due to advanced bit rot (machine refusing to boot) I had to
restore the whole
machine from from Friday's backup and add the missing records from my
10 year old db...

Snow Leopard needs a bit of work... On my main machine, a macbook
pro3,1 the mds processes
keep dumping core and so spotlight does not work ( and for some reason
I have to reboot
my Airport Extreme Base Station when when the repeated core dumps
start heating the machine).

I have not had any problems on my generic local server a core duo mac
mini (which I think is
a 32 bit machine).

It is still not clear to me why dblink cannot do name resolution on my
64 bit machine...

In any case I am back on the air and postgresql seems to be working
mod the dblink problem.

Thanks,

Jerry