| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Phil Campaigne <pcampaigne(at)charter(dot)net> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Incremental Development |
| Date: | 2004-01-13 23:22:38 |
| Message-ID: | Pine.LNX.4.33.0401131621310.23196-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 13 Jan 2004, Phil Campaigne wrote:
> I am developing a java/postgresql application using ant and junit. I
> want to deploy tested builds along with matching tables in
> postgresqlwith test data in them.
>
> What is the best way to deploy versions of the tables with test data to
> postgresql to match a war file for each new build of the application?
> thanks,
> Phil
the best way I've found is to just use a pg_dump file of the database (I
usually put individual apps in their own database / schema for easy backup
and restore and such.)
If you can't run psql by shelling out, you can just execute each line of
the sql dump one at a time, inside a transaction block.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2004-01-13 23:25:31 | Re: Nested transaction - I am a bank ?? |
| Previous Message | Phil Campaigne | 2004-01-13 23:12:48 | Incremental Development |