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.levan@xxxxxxx> 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@xxxxxxxxxxx
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
