Re: Comparing 2 databases

thanks for the repsonse. I appreciate it. are there any limitations on using
this one? Means that we have to the same user on both databases and same
passwords.

I have used the command following way

check_postgres.pl --action=same_schema -H 172.xxxx -p 1550
--db=myProdDB --dbuser=prodUser --dbpass=prodPwd --dbhost2=172.xxxxx
--db=testDB --dbuser=testUser --dbpass=testPwd --verbose > difference.txt

what happend was , it complained about the password, then I tried replacing
the testPwd with prodPwd, then it started executing. but it prompted for
password for testuser. that's where I got confused

One question I have is, is there an option to specify schema also

Thanks once again

Regards

On Tue, Dec 29, 2009 at 1:57 PM, Joshua Tolley <eggyknap(at)gmail(dot)com> wrote:

> 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
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iEYEARECAAYFAks6USQACgkQRiRfCGf1UMOvoQCgm5R9XioQ8mKcw2sDkYtW8SbO
> k3gAn3jDp/xhzHjQkE0O2MCHVcYrQlLL
> =dwE1
> -----END PGP SIGNATURE-----
>
>