PG_RESTORE/DUMP Question - Mailing list pgsql-general

From Alex
Subject PG_RESTORE/DUMP Question
Date
Msg-id 3F9FC602.5030800@meerkatsoft.com
Whole thread Raw
Responses Re: PG_RESTORE/DUMP Question  (Shridhar Daithankar <shridhar_daithankar@myrealbox.com>)
Re: PG_RESTORE/DUMP Question  (Ken Godee <ken@perfect-image.com>)
List 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



pgsql-general by date:

Previous
From: Fernando Nasser
Date:
Subject: Re: JDBC DatabaseMetaData problem
Next
From: Doug McNaught
Date:
Subject: Re: PG_RESTORE/DUMP Question