Re: Comparing 2 databases

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: akp geek <akpgeek(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Comparing 2 databases
Date: 2009-12-29 18:57:40
Message-ID: 20091229185740.GA31937@eddie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 29, 2009 at 11:43:58AM -0500, akp geek wrote:
> Hi all -
>
> I have postgres running on 2 servers. one production and one
> testing. What would be the best way to compare the 2 database, so find out
> the differences? Can you please advice?
>
> regards

That depends on what you mean by "compare". check_postgres[1] has a schema
comparison action you can use.

[1] http://bucardo.org/wiki/Check_postgres

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leonardo M. Ramé 2009-12-29 19:02:06 Re: DDL commands take forever
Previous Message Thomas Kellerer 2009-12-29 18:39:40 Re: Planner Row Estimate with Function