Re: database files are incompatible with server, after computer restart

[CSN <cool_screen_name90001(at)yahoo(dot)com>]

I don't think so -- I followed the instructions here:

http://www.robbyonrails.com/articles/2006/05/29/install-ruby-rails-and-postgresql-on-osx

But looking around, I see there's a pg_ctl in
/usr/local/bin, but 'port contents postgresql8' shows
a pg_ctl in /opt/local/lib/pgsql8/bin.

~ $ ll /opt/local/lib/pgsql8/bin/pg_ctl 
-rwxr-xr-x   2 root  admin  47380 Aug 24 14:24
/opt/local/lib/pgsql8/bin/pg_ctl
~ $ ll /usr/local/bin/pg_ctl 
-rwxr-xr-x   1 root  admin  149456 Apr 23 15:00
/usr/local/bin/pg_ctl

I can't remember if I tried installing PostgreSQL some
time ago using Fink or some other way. Any further
ideas?

Thanks,
csn


--- Douglas McNaught <doug(at)mcnaught(dot)org> wrote:

> CSN <cool_screen_name90001(at)yahoo(dot)com> writes:
> 
> > DETAIL:  The database cluster was initialized
> without
> > HAVE_INT64_TIMESTAMP but the server was compiled
> with
> > HAVE_INT64_TIMESTAMP.
> > HINT:  It looks like you need to recompile or
> initdb.
> 
> Is it possible you have two PG installs on this
> machine, and you're
> trying to start the wrong one?  Because it's hard to
> see how a restart
> could cause this error message--it's saying that
> your data files are
> incompatible with the code you're trying to run.
> 
> -Doug
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com