From: | "Herbie McDuck" <herbie(at)faams(dot)net> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Incremental Dump |
Date: | 2003-06-26 16:58:57 |
Message-ID: | 009001c33c04$3c35f250$0a0ca8c0@FAAMSPROJECT |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Well Tom, the two databases are production and development. The table create
sequence should be the same.
Thanks for the insight !!
Herbie McDuck
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Herbie McDuck" <herbie(at)faams(dot)net>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Thursday, June 26, 2003 6:52 AM
Subject: Re: [NOVICE] Incremental Dump
> "Herbie McDuck" <herbie(at)faams(dot)net> writes:
> > Is there a proceedure to allow one to compare the database structure of
a
> > deployed database against a developmenmt database to note any structural
> > change in one or more tables?
>
> I'd try pg_dump -s (schema only) and diff the two dumps. You might have
> to do some fooling around if objects were created in different orders in
> the two databases, though, since that would affect the dump order.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
From | Date | Subject | |
---|---|---|---|
Next Message | Chad Thompson | 2003-06-26 17:07:47 | Removing foreign key and adding sequence |
Previous Message | Joe Conway | 2003-06-26 16:26:05 | Re: [NOVICE] connectby(... pos_of_sibling) |