Re: [GENERAL] PG_RESTORE/DUMP Question

2003-10-29 Thread Shridhar Daithankar
Alex wrote: 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 n

[GENERAL] PG_RESTORE/DUMP Question

2003-10-29 Thread Alex
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 p

Re: [GENERAL] PG_RESTORE/DUMP Question

2003-10-29 Thread Doug McNaught
Alex <[EMAIL PROTECTED]> writes: > 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