Re: Two 'identical' DB's not acting identically

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Two 'identical' DB's not acting identically
Date: 2003-04-15 09:52:02
Message-ID: 3E9BD642.3060100@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Shridhar Daithankar wrote:
>
> Do a pg_dump -s on both the databases to produce their schemas. Then diff
> those two schemas to find out anything is missing.

I forgot to mention that the test db was created this way:

- on the live db do a pg_dump TAL > dump
- copy dump file to test database server
- on the test db do a createdb TEST; psql TEST < dump

This way the two dbs will have the schemas no?

Thanks,

Jean-Christian Imbeault

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-04-15 09:55:47 Re: Two 'identical' DB's not acting identically
Previous Message Michael Paesold 2003-04-15 09:45:21 Re: Backpatch FK changes to 7.3 and 7.2?