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 3E9BD7FA.6000003@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  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
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 did as you suggested just in case and found only TOC entry differneces
such as:

 > -- TOC entry 299 (OID 3953732)
3219c3219
< -- TOC entry 300 (OID 457305)

Jean-Christian Imbeault

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Re: Two 'identical' DB's not acting identically
Next
From: "Wayne Armstrong"
Date:
Subject: Re: Are we losing momentum?