Re: Creating new cluster by copying directory?

Wells Oliver <wellsoliver@gmail.com> wrote:

> So it's safe to copy the files in /var/lib/postgresql/9.1/main to
> /var/lib/postgresql/9.1/test while main is running?

As long as you copy the whole $PGDATA tree while the source cluster
is stopped, or use PITR recovery techniques:

http://www.postgresql.org/docs/9.2/interactive/backup.html

Of course, the machines must be of the same architecture.

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company