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@wicourts.gov]
Sent: Thursday, August 02, 2012 2:18 AM
To: Manoj Agarwal; pgsql-general@postgresql.org
Subject: Re: [GENERAL] File system level backup
"Manoj Agarwal" <ma@ockham.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
