Обсуждение: 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
>

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

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.