--- Douglas McNaught <doug@xxxxxxxxxxxx> wrote: > CSN <cool_screen_name90001@xxxxxxxxx> 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
