Re: More Snow Leopard problems...

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