Results 1 to 2 of 2

Thread: Postgres8.4

  1. #1
    Join Date
    Dec 2010

    Unanswered: Postgres8.4

    Postgres 8.4 not start after data recovery...

    There was a power outage this PC installed with WIN7 and after this the DB not starts

    Why does this happen?

    What should i do?


  2. #2
    Join Date
    Oct 2010
    Orlando, FL
    Provided Answers: 1
    Post your database logs. It will tell you exactly why your daemon for PG isn't starting.

    Usually logs are located in /var/log/

    [root@slave log]# tail -n 5 postgresql.log
    ERROR:  syntax error at or near "cell" at character 26
    STATEMENT:  ALTER TABLE contacts SET cell = '444-444-4444' WHERE id = 9;
    ERROR:  duplicate key value violates unique constraint "contacts_cell_key"
    DETAIL:  Key (cell)=() already exists.
    STATEMENT:  UPDATE contacts SET cell = '' WHERE id = 9;
    Hope that helps!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts