plain text difference with pg_dump - Mailing list pgsql-admin

From Sabin Coanda
Subject plain text difference with pg_dump
Date
Msg-id gqg4vc$3ut$1@news.hub.org
Whole thread Raw
Responses Re: plain text difference with pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: plain text difference with pg_dump  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-admin
Hi there,

I have two databases DD and DP. DD is used for development, and DP in
production.
After develop something on DD, a diff package is made and it upgrades DP.
Normally after that DD has to be identically with DP.

The problem is when I check the structure difference between DD and DP. My
procedure is to use pg_dump to make a plain text dump of the two databases,
and compare them, ignoring the comments. All the procedures are sorted
identically, excepting those with the same name, but different arguments.

Do you know a method to get the same text dump ?

TIA,
Sabin



pgsql-admin by date:

Previous
From: Tony Webb
Date:
Subject: pg_ctlcluster not logging error (memory problem likely)
Next
From: Tom Lane
Date:
Subject: Re: plain text difference with pg_dump