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

2006-08-29 Thread CSN
--- Douglas McNaught <[EMAIL PROTECTED]> wrote: > CSN <[EMAIL PROTECTED]> writes: > > > I'm stymied. ;) > > So you've tried running both pg_ctl binaries against the data > directory and both don't work? Yes. > I wonder how you ever had a database > working in that case. :) Me too! After 'i

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

2006-08-29 Thread CSN
--- Douglas McNaught <[EMAIL PROTECTED]> wrote: > CSN <[EMAIL PROTECTED]> 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/pg

Re: [GENERAL] database files are incompatible with server, after

2006-08-29 Thread Douglas McNaught
CSN <[EMAIL PROTECTED]> 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 sa

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

2006-08-29 Thread CSN
--- Douglas McNaught <[EMAIL PROTECTED]> wrote: > CSN <[EMAIL PROTECTED]> writes: > > > 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

Re: [GENERAL] database files are incompatible with server, after

2006-08-29 Thread Douglas McNaught
CSN <[EMAIL PROTECTED]> writes: > 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

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

2006-08-28 Thread CSN
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/lo

Re: [GENERAL] database files are incompatible with server, after

2006-08-28 Thread Douglas McNaught
CSN <[EMAIL PROTECTED]> 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 tryin