Dev Process - Mailing list pgsql-admin

From Medi Montaseri
Subject Dev Process
Date
Msg-id 8078a1730804181152m199faeb5j47efa7c72a9571c7@mail.gmail.com
Whole thread Raw
Responses Re: Dev Process  ("H. Hall" <hhall1001@reedyriver.com>)
List 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


pgsql-admin by date:

Previous
From: "Peter Koczan"
Date:
Subject: Re: PG 8.3 and kerberos failures
Next
From: "Jaisen N.D."
Date:
Subject: Re: Re: Problem:- createdb: could not connect to database postgres: could not connect to server: No such file or directory