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

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Two 'identical' DB's not acting identically
Date: 2003-04-15 09:55:47
Message-ID: 200304151525.47353.shridhar_daithankar@nospam.persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christian Imbeault 2003-04-15 09:59:22 Re: Two 'identical' DB's not acting identically
Previous Message Jean-Christian Imbeault 2003-04-15 09:52:02 Re: Two 'identical' DB's not acting identically