#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    69
    Rep Power
    13

    Angry Error during Startup ???


    Hi

    Now, I get the following error... on startup...

    postmaster does not find the database system.
    Expected to find it in the PGDATA directory "/usr/local/pgsql/data",
    but unable to open file "/usr/local/pgsql/data/global/pg_control": No such file or directory
    How can I rectify this ?

    Thanks & Regards.
  2. #2
  3. Second highest poster :p
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jul 2001
    Posts
    7,322
    Rep Power
    33
    I assume you have just installed this on a server or machine. Have you ran initdb yet? This program creates the database structure for PostgeSQL
    - Andreas Koepke

    Koepke Photography

  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    69
    Rep Power
    13
    Hi

    Thanks for your reply, I've already run initdb.

    This was a development database, being used for different projects. Today, I used the postgresql in /etc/init.d to stop it. Normally, I use...
    Code:
    kill -INT `head -1 /var/lib/pgsql/data/postmaster.pid`
    to stop and
    Code:
    postmaster -i -D /var/lib/pgsql/data > logfile 2>&1 &
    When I wanted to restart I got the FATAL error. (logged in previous post). After this, I got the error listed in this post.

    It seems that pg_control file has become corrupt...???

    Well, had to create another database and restore from backup.

    Still, I'm curious about what caused this problem.

    Regards.

IMN logo majestic logo threadwatch logo seochat tools logo