"Manoj Agarwal" <ma(at)ockham(dot)be> wrote:
> I need to transfer the database from one machine to other. Both
> machines contain a database with the same name, for example:
> testdb, but with different data/values, but the structure is
> exactly same.
> Take file system level backup from from first machine for
> Postgres database 'testdb' and restore it in another instance that
> has SAME version of Postgres. i.e. backup the database 'testdb'
> from Postgres 7.4.19 and restore it on another virtual machine
> with same Postgres version 7.4.19.
You cannot use file system level copy for individual databases in a
cluster.
-Kevin