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 Katsikaros <ibo...@yahoo.gr>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 tablelocation; > > I created tables, inserted data and created indexes. > > I now want to "move" the db from '/my/location/machineA' of machine A to > '/other/location/machineB' of machine B. My question is how I can do a > filesystem backup/restore (I want to move the indexes too - too time > consuming to reindex). > > Machine B already has a postgres running, and postgres on machine B already > has other databases. During this process I have no problem of shutting down > postgres. > > > I have tried some things unsuccessfully: > 1) - stop postgres on machine B > - copy dir of tablelocation of machine A to '/other/location/machineB' > on machine B > - start postgres on machine B > - CREATE TABLESPACE tablelocation_name LOCATION > '/other/location/machineB'; > ERROR: directory "/other/location/machineB" is not empty > > > Regards > Vangelis > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
