Re: PG_RESTORE/DUMP Question

Is it enough to just copy the global and the base directory ?
Is there any reason the db would not come up if the data is copied form
solaris to linux or vice versa as long as the db version is the same?

Shridhar Daithankar wrote:

> 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 not find any postings on
>> the net suggesting otherwise. Is there anything to pay attention too ?
>
>
> Yes. just shutdown production postmaster. Copy the entire data
> directory over to test system.
>
> Two system should be absolutely identical. Same architecture,
> preferrably same OS, same postgresql client and server version etc.
>
> Or investigate some of the asynchronous replication systems. That
> would save you some time but will affect production performance a bit.
>
> HTH
>
> Shridhar
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>