"Manoj Agarwal" <ma@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
