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(dot)Grittner(at)wicourts(dot)gov]
Sent: Thursday, August 02, 2012 2:18 AM
To: Manoj Agarwal; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] File system level backup

"Manoj Agarwal" <ma(at)ockham(dot)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