Hi Everyone, I am trying to import data from a backed up PostgreSQL tablespace. The server which the original data was on has been wiped.
1. I saved the tablespace onto a portable harddrive from the old server. This contains the tablespace folder (with PG_VERSION file) and a folder named 225809. This folder contains about 300gb of info. 2. Now I want to view the data on another computer. I am not sure of the best way to do this. I have tried to create a new tablespace and copy the data into it - but the OID is different and so the data cannot be read. 3. I realise now that I should have used the backup/restore function in PGAdmin III. I did not do this. Is there anyway to retrieve the data so that I can view it again? I hope you can help and I hope this makes sense. Thanks, Chris Ewing Visit our website at http://www.halcrow.com ------------------------------------------------------------------------ The contents of this email are confidential, for the sole use of the intended recipient at the email address to which it has been addressed and do not give rise to any binding legal obligation upon Halcrow companies unless subsequently confirmed on headed business notepaper sent by fax, letter or as an email attachment. Whilst reasonable care has been taken to avoid virus transmission, no responsibility for viruses is taken and it is your responsibility to carry out such checks as you feel appropriate. Emails supplied are as found and there's no guarantee that the messages contained within the body of the email have not been edited after receipt. If you receive this email in error, please contact the sender immediately and delete the message from your system. Thank you. Halcrow Group Limited. Registered office: Vineyard House, 44 Brook Green London, W6 7BY. Registered in England and Wales, Number 3415971. -------------------------------------------------------------------------
