Thread: Comparing databases
To all, I have two databases which need to be the same structurally. However members on my team have gone ahead and made structural changes to one and not the other. I am trying to sync up the database structure and I can't copy one to the other. Does anyone know how to structurally compare a list of tables between two different databases without going through them one by one? Sean
"Sugrue, Sean" <Sean.Sugrue@analog.com> writes:
> Does anyone know how to structurally compare a list of tables
> between two different databases without going
> through them one by one?
You might try "pg_dump -s" on both databases and diff the output.
Not a perfect tool but it will serve for minor differences.
regards, tom lane
Navicat has built-in support for schema synchronization. It's pretty good. ____________________________________________________________________ Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com On Jan 11, 2006, at 1:34 PM, Tom Lane wrote: > "Sugrue, Sean" <Sean.Sugrue@analog.com> writes: >> Does anyone know how to structurally compare a list of tables >> between two different databases without going >> through them one by one? > > You might try "pg_dump -s" on both databases and diff the output. > Not a perfect tool but it will serve for minor differences. > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend >
Attachment
Hi everyone
This is not intended as a spam email.
As a new person to postgresql, I recently signed up to the "novice" mailing
list. However I struggle to read the mail replies as people are in different
timezones etc and the replies to questions are scattered.
I was wondering if you would prefer to use a forum instead, as someone can ask a
question and all replies are kept in one thread. If you are interested I have
created a PostgreSql forum which can be found at the following URL -
http://www.systemshock.co.za/forums/index.php?showforum=83 and the main forum
is at http://www.systemshock.co.za/forums/index.php?act=idx . The forums are
diverse and discuss many topics.
It would be great to have you guys with all the knowledge helping us out.
Regards
Mark
This is not intended as a spam email.
As a new person to postgresql, I recently signed up to the "novice" mailing
list. However I struggle to read the mail replies as people are in different
timezones etc and the replies to questions are scattered.
I was wondering if you would prefer to use a forum instead, as someone can ask a
question and all replies are kept in one thread. If you are interested I have
created a PostgreSql forum which can be found at the following URL -
http://www.systemshock.co.za/forums/index.php?showforum=83 and the main forum
is at http://www.systemshock.co.za/forums/index.php?act=idx . The forums are
diverse and discuss many topics.
It would be great to have you guys with all the knowledge helping us out.
Regards
Mark
Mark Campbell mdc@ucs.co.za (011) 712 1521 Confidentiality Notice: http://ucs.co.za/conf.html
am 12.01.2006, um 15:38:43 +0200 mailte Mark Campbell folgendes: > Hi everyone > > This is not intended as a spam email. > > As a new person to postgresql, I recently signed up to the "novice" mailing > list. However I struggle to read the mail replies as people are in > different > timezones etc and the replies to questions are scattered. That is not correct. Many modern email-clients can sort emails by thread. Btw, your Thunderbird can this also, but your version are old. > I was wondering if you would prefer to use a forum instead, as someone can > ask a > question and all replies are kept in one thread. If you are interested I I'm subscribed in a lot of different mailing lists and i have all this list in one email programm (mutt) and so i have full control with ONE program. With, for instance, 20 different foren i had to go to visit 20 different websites with different lookout. This, a forum, isn't a sense alternative for me, sorry. Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===
At 08:38 AM 1/12/06, Mark Campbell wrote: >As a new person to postgresql, I recently signed up to the "novice" mailing >list. However I struggle to read the mail replies as people are in different >timezones etc and the replies to questions are scattered. Try an email client that supports threads. I don't use one, but some people prefer them for the reasons you give. In some email clients sorting the messages by subject helps.
On Thu, Jan 12, 2006 at 13:48:09 -0500, Frank Bax <fbax@sympatico.ca> wrote: > At 08:38 AM 1/12/06, Mark Campbell wrote: > >As a new person to postgresql, I recently signed up to the "novice" mailing > >list. However I struggle to read the mail replies as people are in > >different > >timezones etc and the replies to questions are scattered. > > > Try an email client that supports threads. I don't use one, but some > people prefer them for the reasons you give. In some email clients sorting > the messages by subject helps. His at least partially supports threads, since the headers from his message indicates that he replied to an existing thread to start a discussion on a completely different topic.