Importing PostgreSQL data from another database

From: "Ewing, Chris" <EwingC(at)Halcrow(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Importing PostgreSQL data from another database
Date: 2008-01-09 14:06:40
Message-ID: 582EFACE28CEF44581C4656CB34D1F5D10B82EE9@LOND-MX-01.halcrow.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
-------------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2008-01-09 14:07:13 Re: quick question abt pg_dump and restore
Previous Message Josh Harrison 2008-01-09 14:02:23 quick question abt pg_dump and restore