From: Alex <alex@meerkatsoft.com>
To: Postgre Admin <pgsql-admin@postgresql.org>
Subject: PG_DUMP Question
Date: Wed, 29 Oct 2003 22:43:15 +0900
Message-ID: <3F9FC3F3.2020509@meerkatsoft.com> (raw)
Hi,
I have a test system that is setup the same as a production system and
would like to frequently copy the database over.
pg_dump takes a few hours and even sometimes hangs.
Are there any reasons not to simply just copy the entire data directory
over to the test system? I could not find any postings on the net
suggesting otherwise. Is there anything to pay attention too ?
Thanks for any advise
Alex
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alex@meerkatsoft.com
Subject: Re: PG_DUMP Question
In-Reply-To: <3F9FC3F3.2020509@meerkatsoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox