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