Re: Comparing 2 databases

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 <eggyknap(at)gmail(dot)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-----
>
>