Wells Oliver <wellsoliver@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
