pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Comparing 2 data base or 2 tables
Date: Mon, 28 Jun 2021 13:26:04 +0200
Message-ID: <EAC73B19-3E0C-42DA-85D6-AEF9BECDA7DA@jakobs.com> (raw)
In-Reply-To: <DBAPR01MB66628936B4775452DAEBBAD7CA039@DBAPR01MB6662.eurprd01.prod.exchangelabs.com>
References: <CALhHtcDip7W6WvDdW6JNAYChpYfO0An8CMFCejLpAY9yP_kUjA@mail.gmail.com>
	<CAOBaU_ZS2_3_TCW7TZBJMb9kRZMS+oLssU=HwVTQDZ0L1GWYTw@mail.gmail.com>
	<DBAPR01MB66628936B4775452DAEBBAD7CA039@DBAPR01MB6662.eurprd01.prod.exchangelabs.com>

Dump them using pg_dump and compare the files.

Am 28. Juni 2021 13:12:26 MESZ schrieb koff10 <koff10@hotmail.com>:
>
>Hi All,
>I am in trouble with a production database.So, I'm looking for a script
>
>or tools comparing 2 postgre database schemas
>and extract data differences.
>I need a little help please.
>thanks lot.
>
>koff Berta

-- 
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -

view thread (8+ messages)  latest in thread

Message-ID: <EAC73B19-3E0C-42DA-85D6-AEF9BECDA7DA@jakobs.com>
Permalink:  ../EAC73B19-3E0C-42DA-85D6-AEF9BECDA7DA@jakobs.com/
Also on:    postgresql.org/message-id/EAC73B19-3E0C-42DA-85D6-AEF9BECDA7DA@jakobs.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Comparing 2 data base or 2 tables
  In-Reply-To: <EAC73B19-3E0C-42DA-85D6-AEF9BECDA7DA@jakobs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox