Search Postgresql Archives

Re: database files are incompatible with server, after

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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? 

> 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.

> 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.

-Doug


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux