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

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

> CSN <cool_screen_name90001(at)yahoo(dot)com> writes:
>
> > I don't know which to run now! I tried both
> > '/opt/local/lib/pgsql8/bin/pg_ctl start -D pgdata'
> and
>
> You might want an absolute path for 'pgdata'
> here--have you tried
> that?

~ $ /opt/local/lib/pgsql8/bin/pg_ctl start -D
/Users/csn/pgdata/
postmaster starting
~ $ FATAL: database files are incompatible with
server
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.

> > putting /opt/local/lib/pgsql8/bin before
> > /usr/local/bin in PATH and still get the same
> error.
>
> Why don't you run both pg_ctl binaries with the
> --version option, then
> compare against the pg_control file in the data
> directory (I think
> that's what it's called). That should hopeully tell
> you which one to run

~ $ /usr/local/bin/pg_ctl --version
pg_ctl (PostgreSQL) 8.1.3

~ $ /opt/local/lib/pgsql8/bin/pg_ctl --version
pg_ctl (PostgreSQL) 8.1.3

pgdata/global/pg_control seems to be binary.
pgdata/PG_VERSION has 8.1 in it.

> > Is there some way to specify HAVE_INT64_TIMESTAMP
> to
> > pg_ctl or just export what's in the existing
> pgdata
> > and initdb a new dir and import?
>
> You need to have the server running to export. :)
>
> I'm pretty sure you can get it running; you just
> haven't tried the
> right way yet.

I'm stymied. ;)

Thanks,
csn

>
> -Doug
>

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