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="" -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@xxxxxxxxx> wrote:
That depends on what you mean by "compare". check_postgres[1] has a schemaOn 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
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-----
