Hi, 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? Kind Regards, Manoj Agarwal -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@xxxxxxxxxxxx] Sent: Thursday, August 02, 2012 2:18 AM To: Manoj Agarwal; pgsql-general@xxxxxxxxxxxxxx Subject: Re: File system level backup "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
