Also check this out Very interesting – it can compare data between the DBs (tables/views). Check this out –
http://www.zidsoft.com/screenshots.html
Thanks
Deepak
On Tue, Dec 29, 2009 at 4:37 PM, Joshua Tolley <eggyknap@xxxxxxxxx> wrote:
On Tue, Dec 29, 2009 at 03:21:18PM -0500, akp geek wrote:You might try a pgpass file[1] and skip providing the passwords on the command
> 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
line.
Check the docs under BASIC FILTERING[2]. You can tell it to ignore objects
> One question I have is, is there an option to specify schema also
with certain names, or to include only those objects with the given names.
[1] http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html
[2] http://bucardo.org/check_postgres/check_postgres.pl.html#basic_filtering
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAks6oNcACgkQRiRfCGf1UMOQVgCghRaU2VCwyXNg0KbkqI/FhA9J
xpoAn2RJRSmJmbgybRytNjo0ZiPNruL4
=Lk0m
-----END PGP SIGNATURE-----
