Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43133=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XynKM-0007at-M4
 for pgsql-admin@arkaria.postgresql.org; Wed, 10 Dec 2014 19:53:38 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43133=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XynKM-0004qb-53
 for pgsql-admin@arkaria.postgresql.org; Wed, 10 Dec 2014 19:53:38 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <jaime.soler@gmail.com>)
 id 1XynKK-0004oF-Of
 for pgsql-admin@postgresql.org; Wed, 10 Dec 2014 19:53:36 +0000
Received: from mail-wi0-x233.google.com ([2a00:1450:400c:c05::233])
 by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <jaime.soler@gmail.com>)
 id 1XynKH-0008LM-DA
 for pgsql-admin@postgresql.org; Wed, 10 Dec 2014 19:53:34 +0000
Received: by mail-wi0-f179.google.com with SMTP id ex7so6384907wid.6
 for <pgsql-admin@postgresql.org>; Wed, 10 Dec 2014 11:53:31 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=message-id:subject:from:reply-to:to:cc:date:in-reply-to:references
 :content-type:mime-version:content-transfer-encoding;
 bh=3NzqvFZ1ARowshJLZL7RaGwFWVxCLA4aUbYj50arglA=;
 b=Ic5gPO/mR+30Lyizx9E8qXEdXg/todtos8Sr0GjXfHIie1ZDxtMuWcLjXc+wSjHisS
 gondQDj3zYTo4ha9uM1l5p0q6Qwg1w04MCnntvAocegMpBUvnFdhh4cYABF4g30J+PwS
 bn7ihblXa7BTYIh18NU9HM4PtcAnL6xaBSKv7iv3S5XXkMRnC2Mr0uoMQKtuMFFxoxru
 rgC0zJd8wyq+RekqfVW1OvuAu8eCKoKPYbSDW2lJZ39b/kbGovid3d6mO5sv7NsV+HS0
 cUmm+f5MjXSdTkTdC9L5Fmeme86UwtXl//zkC8Siv+8G2RN7anC5JrF8oTDir5HtetMO
 CESQ==
X-Received: by 10.180.228.72 with SMTP id sg8mr9268003wic.48.1418241211564;
 Wed, 10 Dec 2014 11:53:31 -0800 (PST)
Received: from enterprisedb01 (84.125.177.156.dyn.user.ono.com.
 [84.125.177.156])
 by mx.google.com with ESMTPSA id l9sm2260wic.21.2014.12.10.11.53.30
 for <multiple recipients>
 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
 Wed, 10 Dec 2014 11:53:30 -0800 (PST)
Message-ID: <1418241209.4563.1.camel@gmail.com>
Subject: Re: Comparing two databases for differences
From: jaime soler <jaime.soler@gmail.com>
Reply-To: jaime.soler@gmail.com
To: "Ferrell, Denise CTR NSWCDD, Z11" <denise.ferrell.ctr@navy.mil>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Date: Wed, 10 Dec 2014 20:53:29 +0100
In-Reply-To: 
 <2BC18916DE4BF141AC1EFC55CE2CAE7D5C096E@NAEANRFKXM01V.nadsusea.nads.navy.mil>
References: 
 <2BC18916DE4BF141AC1EFC55CE2CAE7D5C096E@NAEANRFKXM01V.nadsusea.nads.navy.mil>
Content-Type: text/plain; charset="UTF-8"
X-Mailer: Evolution 3.12.7-0ubuntu1 
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

El mié, 10-12-2014 a las 14:08 +0000, Ferrell, Denise CTR NSWCDD, Z11
escribió:
> Running PostgreSQL 9.3.5 on Linux.
> 
> Does anyone know of an easy way to compare 2 database instances?  Especially the stored procedures and tables from the two databases.

I have used several times aquadatastudio:
http://www.aquafold.com/aquadatastudio/schema_sql_compare.html
> 
> Thank you in advance.
> 




-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin