Re: More Snow Leopard problems...

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.levan@eku.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@comcast.net