PostgreSQL unable to start on Mac OS X

From: agoetz(at)mac(dot)com (Andrew Goetz)
To: pgsql-admin(at)postgresql(dot)org
Subject: PostgreSQL unable to start on Mac OS X
Date: 2003-03-07 17:55:22
Message-ID: 23486e24.0303070955.66ec1731@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear all,

I have installed PostgreSQL on my company's iMac OS X server (not my
choice, but you use what you've got), via Marc Liyanage's directions.
(Thanks Marc! http://www.entropy.ch/software/macosx/postgresql/) It
worked well for several months until it knew that I would be out of
the country. While I was gone, it stopped working. One of our
workers kindly tried to reboot the machine, and postgres was never
able to start again.

Upon my return, I tried unsuccessfully to restart postmaster. It
would always say that postmaster started successfully, but then
nothing would happen. The logfile contained this message:

DEBUG: database system was shut down at 2003-02-26 01:19:59 GMT
FATAL 2: open of /usr/local/pgsql/data/pg_xlog/0000000000000000 (log
file 0, segment 0) failed: Permission denied
DEBUG: startup process (pid 485) exited with exit code 2
DEBUG: aborting startup due to startup process failure

In my finite wisdom, I tried to change the permissions on the file
with all the zeros. I got the same response from postmaster, but the
logfile contained a different message:

DEBUG: database system was shut down at 2003-02-26 01:19:59 GMT
DEBUG: ReadRecord: read of log file 0, segment 0, offset 9494528
failed: No such file or directory
DEBUG: invalid primary checkpoint record
DEBUG: ReadRecord: read of log file 0, segment 0, offset 9494528
failed: No such file or directory
DEBUG: invalid secondary checkpoint record
FATAL 2: unable to locate a valid checkpoint record
DEBUG: startup process (pid 726) exited with exit code 2
DEBUG: aborting startup due to startup process failure

I searched this group, and it seems that others have had this problem,
but the answer is to run some programs that I cannot find under a
contrib/ directory which I do not have. I suspect that this is
because I did not compile from source.

Being very new to postgreSQL, and databases, servers, and *nix in
general, I have now used up all my knowledge. If anyone would take
pity on me and tell me whether they believe any of this data is
recoverable and how I might accomplish such a feat, I would apreciate
the help.

Thanks,
Andrew

Browse pgsql-admin by date

  From Date Subject
Next Message Aspire Something 2003-03-07 19:00:03 Re: Successful regression testing???
Previous Message P G 2003-03-07 17:42:24 Successful regression testing???