Vangelis,
Did you find a best way to achieve what you were asking about? I have a
similar desire to migrate a large table and its indices.
Regards,
Sky
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/tablespace-restore-tp3272200p3361935.html
Sent from the PostgreSQL -
On 11/19/10 3:52 AM, Vangelis Katsikaros wrote:
Hello
I use postgres 8.3.12 on machineA and 8.4.5 on machineB.
On machineA I have created a tablespace with
CREATE TABLESPACE tablelocation_name LOCATION '/my/location/machineA';
I then created a database with
CREATE DATABASE db_name TABLESPACE t
The problem is that there is a lot of metadata outside the tablespace you
created (information that the catalog tables keep on your new database and
its objects) and this can only be restored with a full restore which would
overwrite your pre-existing databases on your target. I hate to say it
can
On 11/19/2010 03:12 PM, Matthew Walden wrote:
Vangelis,
I don't believe you can do file level copying of single databases
(especially as they are different versions).
Hi Matthew, thanks for your answer.
If the different versions is a problem, I can downgrade one server and
then upgrade after
Vangelis,
I don't believe you can do file level copying of single databases
(especially as they are different versions).
Take a look at pg_dump in the documentation. This will do what you need I
think but at a logical level rather than physical.
On Fri, Nov 19, 2010 at 11:52 AM, Vangelis Katsik
