Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2009
    Posts
    2

    Unanswered: Database Recovery

    Hi,

    My name is Victor. I am using postgresql 7.3.2. As my database server hardisk corrupted, I can only recovery the file in /usr/local/pgsql.

    Now, I have created a new database server with same setting and version. How can I recover the database by using the file that I recovered?

    Many Thanks.

    Victor Hung

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Oh, just restore from backup.

    Sarcasm aside, you'll need to copy the data directory into your new installation.
    PostgreSQL: Documentation: Manuals: PostgreSQL 7.3: File system level backup

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    And upgrade to a recent and supported version of PostgreSQL as well.
    The current version is 8.4.1
    7.3.x is no longer maintained let alone supported

  4. #4
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Well initially OP will need the same version if he hopes to restore from file system.

  5. #5
    Join Date
    Dec 2009
    Posts
    2
    Yes, there are some necessary data which backup doesn't included. So, any clue for this?

Posting Permissions

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