From: Rod Taylor <pg@rbt.ca>
To: SZŰCS Gábor <surrano@mailbox.hu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Constraint->function dependency and dump in 7.3
Date: Tue, 13 Jul 2004 14:03:37 -0400
Message-ID: <1089741816.48027.89.camel@jester> (raw)
In-Reply-To: <022401c46900$b85c26e0$0403a8c0@fejleszt4>
References: <GFEPILCFHLAKEKOGANLLCEDLCBAA.verebes@freemail.hu>
<00a001c4680b$f14c60a0$0403a8c0@fejleszt4>
<1089636713.58812.37.camel@jester>
<01f401c468f6$90905c80$0403a8c0@fejleszt4>
<1089739239.48027.64.camel@jester>
<022401c46900$b85c26e0$0403a8c0@fejleszt4>
On Tue, 2004-07-13 at 13:42, SZŰCS Gábor wrote:
> Dear Rod,
>
> Thanks. It'll be a pain to have two versions between the prod and devel
> servers, but I'll forward this info to the chief.
You can make this part easier on yourself.
Dump the structure from production and migrate it to devel (fix the dump
file). Keep this file.
From now on when applying changes to production, keep the structural
changes applied as a separate SQL file (numbers work well).
When building a new box to duplicate production:
1. Apply all patches in order
for i in `ls *.sql` ; do cat $i | psql test_db ; done
2. Do a data dump of production and restore that to the testing area
pg_dump --data-only prod_db | psql test_db
Now you don't need to worry about whether the production schema will or
will not dump properly, since you can reproduce that using external
files.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pg@rbt.ca, surrano@mailbox.hu
Subject: Re: Constraint->function dependency and dump in 7.3
In-Reply-To: <1089741816.48027.89.camel@jester>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox