Re: Comparing 2 databases - Mailing list pgsql-general

From Joshua Tolley
Subject Re: Comparing 2 databases
Date
Msg-id 20091229185740.GA31937@eddie
Whole thread Raw
In response to Comparing 2 databases  (akp geek <akpgeek@gmail.com>)
Responses Re: Comparing 2 databases  (akp geek <akpgeek@gmail.com>)
List 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

Attachment

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Planner Row Estimate with Function
Next
From: "Leonardo M." Ramé
Date:
Subject: Re: DDL commands take forever