Re: [GENERAL] Database snapshots or clones for staging and testing.

2014-02-05 Thread Jeff Janes
On Thu, Jan 30, 2014 at 2:12 PM, Tim Uckun wrote: > Hi all. > > I have the following scenario I want to accomplish. > > In order to test a new branch of code I want to create a snapshot of the > live database into a testing database. > How do you do that? Running pg_basebackup live? What I do

Re: [GENERAL] Database snapshots or clones for staging and testing.

2014-01-30 Thread salah jubeh
Hello, For backup restore solution, one could create a snapshot and use it as a template for later use. For example, if the changes can not be revoked, and something wrong went with the tests; creating a a database form a template is much faster than backup and restore. Regards On Thursday

Re: [GENERAL] Database snapshots or clones for staging and testing.

2014-01-30 Thread Adrian Klaver
On 01/30/2014 02:12 PM, Tim Uckun wrote: Hi all. I have the following scenario I want to accomplish. In order to test a new branch of code I want to create a snapshot of the live database into a testing database. The code will be deployed after that and it may run some migrations which will cha

[GENERAL] Database snapshots or clones for staging and testing.

2014-01-30 Thread Tim Uckun
Hi all. I have the following scenario I want to accomplish. In order to test a new branch of code I want to create a snapshot of the live database into a testing database. The code will be deployed after that and it may run some migrations which will change the schema of the database. The code i