Re: File system level backup

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