Search Postgresql Archives

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

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

 



--- Douglas McNaught <doug@xxxxxxxxxxxx> wrote:

> CSN <cool_screen_name90001@xxxxxxxxx> 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 'initdb -D pgdata' and 'pg_ctl start -D pgdata' it ran for days during which I used
it quite a bit. But once I restarted the computer...

> Are you sure you have the right data directory?
> Maybe the one you
> think was used isn't the one that was actually used.

Yes. But I looked around and couldn't find any other data dirs.

> If you can't get either to work, you should hopefully be able to
> compile a version of the code with HAVE_64BIT_TIMESTAMP and get it to
> start up with your data.

Hmm, I installed using DarwinPorts (I think, if that uses 'port') -- I wonder if it can be
reinstalled that way and pass a HAVE_64BIT_TIMESTAMP flag to it. Besides my current problem, does
HAVE_64BIT_TIMESTAMP have much impact on things?

> But I still strongly suspect this'll be an
> easy fix once we figure it out.  :)

Heh, I hope. :) I've never had a problem with PG before, and I have no idea how or why this
happened (other than it coincided with rebooting).

Thanks,
csn


> -Doug
> 


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


[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