Skip site navigation (1) Skip section navigation (2)

Dev Process

From: "Medi Montaseri" <montaseri(at)gmail(dot)com>
To: postgresql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Dev Process
Date: 2008-04-18 18:52:57
Message-ID: 8078a1730804181152m199faeb5j47efa7c72a9571c7@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

I was wondering if you could critique the following DB application
development process.

Given a production DB and a Dev DB:
1- Develope schema and code on Dev including test data which will impact
sequences, etc
2- Dump the schema only (not the data) from Dev and restore it into the
production DB
3- Populate DB with real data, usage begins
4- Enhancement to schema on Dev DB including unit testing again with impact
on sequences
5- Dump schema and move to production
6- Goto 4

Thanks
Medi

Responses

pgsql-admin by date

Next:From: Jaisen N.D.Date: 2008-04-19 04:29:25
Subject: Re: Re: Problem:- createdb: could not connect to database postgres: could not connect to server: No such file or directory
Previous:From: Peter KoczanDate: 2008-04-18 17:43:20
Subject: Re: PG 8.3 and kerberos failures

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group