Postgres Pro
Downloads
Home   >   mailing lists

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

From Shridhar Daithankar
Subject Re: Two 'identical' DB's not acting identically
Date
Msg-id 200304151525.47353.shridhar_daithankar@nospam.persistent.co.in
Whole thread Raw
In response to Two 'identical' DB's not acting identically  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Tree view 
On Tuesday 15 April 2003 15:13, you wrote:
> How can I find out what is different betweeb my live db and TEST db? I
> had a look at the postgres.conf files but those were identical.

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

HTH

 Shridhar

pgsql-general by date:

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