| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | Wells Oliver <wellsoliver(at)gmail(dot)com>, "gilberto(dot)castillo(at)etecsa(dot)cu" <gilberto(dot)castillo(at)etecsa(dot)cu> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Creating new cluster by copying directory? |
| Date: | 2013-07-11 20:48:50 |
| Message-ID: | 1373575730.11179.YahooMailNeo@web162904.mail.bf1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Wells Oliver <wellsoliver(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gilberto Castillo | 2013-07-11 20:50:29 | Re: Creating new cluster by copying directory? |
| Previous Message | Wells Oliver | 2013-07-11 20:42:01 | Re: Creating new cluster by copying directory? |