From: Mario Splivalo <mario.splivalo@mobart.hr>
To: pgsql-admin@postgresql.org
Subject: Diffs between two databases...
Date: Fri, 18 Nov 2005 14:47:26 +0100
Message-ID: <1132321646.7965.22.camel@ekim> (raw)
I have a production server (7.4.9) with, of course, a production
database with 30 tables, 250 functions, types, views, indices, ...
My developers have created new version of the software, that includes
the new version of the datbase. They've changed 6 tables, two dozen
views and almost one hundred stored procedures. Now I need to apply
those changes on the production server.
Is there a way to generate a 'diff' script for the two databases? I'd
write script myself if I'd be able to 'script' just the desired object.
For instance, just the function.
I've seen that I can do pg_dump to a file with pg_dump -Fc, and then I
can do pg_restore -Fc -l <dump.file> to have the list of all the
database objects. There I can see the functions, but how do I (re)create
just the desired function?
What would suit me the best would be a tool/util that would drop each
db.object into a separate file. Then I could create a script wich will
'load' each object from the file when I want it (so I don't have
dependency problems).
Is there a tool like that, or should I stick with pg_dump/pg_restore, or
maybe even going trough information_schema to see all the objects in the
database?
Mario
--
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mario.splivalo@mobart.hr
Subject: Re: Diffs between two databases...
In-Reply-To: <1132321646.7965.22.camel@ekim>
References: <1132321646.7965.22.camel@ekim>
* 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