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