Re: database files are incompatible with server, after computer restart - Mailing list pgsql-general

From CSN
Subject Re: database files are incompatible with server, after computer restart
Date
Msg-id 20060829022525.54746.qmail@web52906.mail.yahoo.com
Whole thread Raw
In response to Re: database files are incompatible with server, after  (Douglas McNaught <doug@mcnaught.org>)
Responses Re: database files are incompatible with server, after
List pgsql-general
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@mcnaught.org> wrote:

> CSN <cool_screen_name90001@yahoo.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

pgsql-general by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: database files are incompatible with server, after
Next
From: Markus Schiltknecht
Date:
Subject: Re: Postgresql mentioned on Newsforge MySQL article