Re: Comparing 2 databases - Mailing list pgsql-general

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-----