Re: Testing Technique when using a DB - Mailing list pgsql-general

From Steve Crawford
Subject Re: Testing Technique when using a DB
Date
Msg-id 51409F74.2050008@pinpointresearch.com
Whole thread Raw
In response to Re: Testing Technique when using a DB  (Perry Smith <pedzsan@gmail.com>)
Responses Re: Testing Technique when using a DB
List pgsql-general
On 03/12/2013 09:05 PM, Perry Smith wrote:
> To all who replied:
>
> Thank you. ...
>
> I had not seriously considered pg_dump / pg_restore because I assumed
> it would be fairly slow but I will experiment with pg_restore and
> template techniques this weekend and see which ones prove viable.

Another possibility a bit outside my area of expertise but what about a
VM image configured to your needs that you just spin up as needed then
discard when done (i.e. always spinning up the same starting image)?

Cheers,
Steve


pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: table spaces
Next
From: Joe Van Dyk
Date:
Subject: Re: Testing Technique when using a DB