Postgres Pro
Downloads
Home   >   mailing lists

Re: Two 'identical' DB's not acting identically - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject Re: Two 'identical' DB's not acting identically
Date
Msg-id 3E9BD642.3060100@mega-bucks.co.jp
Whole thread Raw
In response to Two 'identical' DB's not acting identically  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
Responses Re: Two 'identical' DB's not acting identically  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Two 'identical' DB's not acting identically
Next
From: Jean-Christian Imbeault
Date:
Subject: Re: Two 'identical' DB's not acting identically