"Manoj Agarwal" <ma@xxxxxxxxx> wrote: > From: Kevin Grittner [mailto:Kevin.Grittner@xxxxxxxxxxxx] >> "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. That's old, and long out of support. http://www.postgresql.org/support/versioning/ >> You cannot use file system level copy for individual databases in >> a cluster. > > I have two identical Centos 4.6 Virtual machines with postgresql > database from different customers. Can't I swap the databases > between these two machines using file level copy, without > requiring pg_dump and pg_restore? I don't wish to use file system > level copy for individual database in a cluster, but as a whole, > is it possible? Yes, if you copy the whole database *cluster* (everything under the the directory you get when you run `show data_directory;` -- you can't pick individual databases). Be sure to read this page carefully: http://www.postgresql.org/docs/7.4/interactive/backup-file.html -Kevin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
