Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006

    Question Unanswered: Restoring a tablespace directory on a different server


    My postgresql server crashed and the only thing I saved was an hardrive containing the directory of a tablespace.

    How can I restore it on a different server with POstgresql ?

    I tried to create a tablespace with the same name & directory, then put files in it, it does not complain but I cannot access any database.

    Any idea ?


  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    Sorry, I don't think so. According to the Douglesses (authors of PostgreSQL, 1st and 2nd editions) when discussing the disadvantages of using a filesystem backup mechanism:
    Finally, it is not possible to restore a single database or table from a filesystem archive
    In your case, unless you have the entire postgreSQL directory available (and not just the single tablespace) I think you are stuck.

    You should probably ask this question over at the PostgreSQL mailing list archives.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

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