On Tue, Nov 5, 2013 at 3:11 PM, sparikh <sparikh(at)ecotality(dot)com> wrote:
> I need to clone production database to development server ? What is the
> best
> and simplest way to achieve that? Both my production and development
> postgres versions are same. Will copy over data folder using rsync work?
>
How are you currently backing up your production database? I usually
piggy-back off of that method to set up the clone. It kills two birds with
one stone, you both get your clone for dev, and you exercise your disaster
recovery procedure.
Cheers,
Jeff