PG_RESTORE/DUMP Question

From: Alex <alex(at)meerkatsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PG_RESTORE/DUMP Question
Date: 2003-10-29 13:52:02
Message-ID: 3F9FC602.5030800@meerkatsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2003-10-29 14:01:47 Re: PG_RESTORE/DUMP Question
Previous Message Fernando Nasser 2003-10-29 13:49:29 Re: JDBC DatabaseMetaData problem