var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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 ?
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:
In your case, unless you have the entire postgreSQL directory available (and not just the single tablespace) I think you are stuck.
Finally, it is not possible to restore a single database or table from a filesystem archive
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