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 <spar...@ecotality.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- - *Laurentius Purba* - SproutLoud Media Networks, LLC. - lpu...@sproutloud.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> -
