Re: Noob Q: Is the PG database its own source code backup? - Mailing list pgsql-general

From Ian Barwick
Subject Re: Noob Q: Is the PG database its own source code backup?
Date
Msg-id 1d581afe0904272223t3fe3c66aib5806f9258e97f88@mail.gmail.com
Whole thread Raw
In response to Noob Q: Is the PG database its own source code backup?  (Kenneth Tilton <kentilton@gmail.com>)
List pgsql-general
2009/4/28 Kenneth Tilton <kentilton@gmail.com>:
> I find myself hacking away in pgAdmin most of the time now, after early on
> keeping PG source code in text files I could preserve in SVN. At this point
> I cannot point to anything other than the pg db itself that has a full
> description.
>
> Is this normal? Or do folks assiduously maintain an external set of scripts
> and always work from those, resisting the temptation to just hack at the db
> with pgAdmin or psql? Or_______?

By "source code" you mean the definitions of database objects (tables,
views, functions etc.?)

Usually with the projects I work with, I treat these as an integral
part of the application code and is maintained as a matter of course
in the source repository. I usually maintain a master file (or set of
files) containing the object definitions, a file (or script) to create
an initial application database setup from these; and a file which
contains the SQL required to make the changes between application
releases.

Ian Barwick

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: how do you get there from here?
Next
From: David
Date:
Subject: Sequence Incrementing by 2 insted of 1