Re: Clone database using rsync?

From: Laurentius Purba <lpurba(at)sproutloud(dot)com>
To: sparikh <sparikh(at)ecotality(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Clone database using rsync?
Date: 2013-11-14 19:53:17
Message-ID: CAMfLBng6VAiGVuMKRVvogy+KTd7=MbnK=akw71NaoNTtywTczQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just want to give you some idea for your reference.

If you are using zfs, you will be gaining lots of advantages. A simple
clone and send command from zfs will help you big time.

Check it out: http://docs.oracle.com/cd/E18752_01/html/819-5461/docinfo.html

On Tue, Nov 5, 2013 at 6: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?
>
> Thanks in advance.
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Clone-database-using-rsync-tp5777141.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--

- *Laurentius Purba*
- SproutLoud Media Networks, LLC.
- lpurba(at)sproutloud(dot)com
- www.sproutloud.com
- •

- [image: Facebook] <http://www.facebook.com/SproutLoud> [image:
Twitter]<http://twitter.com/sproutloud>
[image: Google+] <http://plus.google.com/100508252462681981365> [image:
LinkedIn] <http://www.linkedin.com/company/440456?trk=tyah> [image:
YouTube] <http://www.youtube.com/user/sproutcms> [image:
Pinterest]<http://pinterest.com/sproutloud/>
[image: Blog RSS] <http://blog.sproutloud.com/> [image: SproutLoud
Newsletter] <http://market.sproutloud.com/Newsletter-signup.html>
-

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2013-11-14 21:05:30 Re: Tuning 9.3 for 32 GB RAM
Previous Message Helio Campos Mello de Andrade 2013-11-14 18:42:15 PostgreSQL now on Amazon RDS