#1
  1. Me likey breadsticks...
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2003
    Location
    Los Angeles
    Posts
    1,189
    Rep Power
    18

    Power outage, now can't start Postgres


    Well, not sure exactly how it happened but there was a power outage in our server room which despite backup power took down the web servers and db server (yup, today's going to be fun).

    Anyways, postgres won't start on the db server (of course that's the only server we need it to run on). The box is running pg 7.1.3. Manual invocations of the /etc/init.d/postgresql startup script fail. I found this link which I thought would solve my problem, however after deleting the postmaster.pid file it still fails when running the startup script.

    Any ideas would be greatly appreciated. We do have db dumps, however I'd prefer not to have to go that route.

    -b
    PostgreSQL, it's what's for dinner...
  2. #2
  3. Me likey breadsticks...
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2003
    Location
    Los Angeles
    Posts
    1,189
    Rep Power
    18
    Whew... all fixed. For future reference, the postmaster.pid file should be deleted, but for some reason my postgresql.conf had permissions of 755 on it and postgres did not like that so after a chmod 744 postgresql.conf startup went fine.

    -b

IMN logo majestic logo threadwatch logo seochat tools logo