PostgreSQL unable to start on Mac OS X
От | agoetz@mac.com (Andrew Goetz) |
---|---|
Тема | PostgreSQL unable to start on Mac OS X |
Дата | |
Msg-id | 23486e24.0303070955.66ec1731@posting.google.com обсуждение исходный текст |
Список | 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
В списке pgsql-admin по дате отправления: